by Mandy Doward - 6/12/2016

Although we can create Linked Tables in Access that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Access Query.

Using VBA we can do this!

We will look at an example that enables us to lookup a customer’s total revenue value from an Access Query.

 


by Mandy Doward - 6/12/2016

Although we can create External Data Sets in Excel that pull information from a SQL Server Database there are times when you want to check a value or lookup a value from an underlying SQL Server database directly from an Excel formula.

Using VBA we can do this!

We will look at an example that enables us to lookup a customer’s total revenue value from an Excel Formula.

 


by Mandy Doward - 18/1/2017

Extracting All The Words From a String In A SQL Server Database Query

It is easy enough to extract the first word from a string in a database query, but what if you need to separate all words in a given string into a list of separate words?

This is a job for Common Table Expressions (CTEs) as they enable us to repeatedly read a single record while changing it each time.

Here is a SQL Server example which takes a string variable and spearates it into inidividual words. We use a combination of CHARINDEX, LEFT and RIGHT functions to achieve it.


by Mandy Doward - 11/11/2016

Linux Systems offer an X Windows interface which can make changing system settings and configuration pretty straight forward, but what if you remotely log in via a Secure Shell (SSH) session using a tool such as putty?

Here is how to change the system date and time and the hostname from the command line.

Changing The Date & Time in Linux

The date command can be used by root to change the system date and time.


by Ian Roberts - 24/1/2023

If you've heard of the cloud, and wondered what it could do for your business, you've probably encountered a dazzling lexicon of jargon about it - as well as some who claim it's the future of IT, and others who say it's complex and problematic. So what is cloud computing and what is the truth? As is so often the case, it comes down to using the technology effectively, not just using it because it's there...

What is cloud computing?

The dictionary definition of cloud:


by Mandy Doward - 21/10/2016
How many times have you asked yourself that question?

If you work with SQL Server based applications then probably quite a few!

No matter what the application you are working with (CRM, Sales Order Processing, Financial Accounting, Contact Management, Booking System (to name but a few!)) there is a database behind it. Most common applications will store their data in either a Microsoft SQL Server Database or an Oracle Database (of course there are other relational database platforms out there).


by Mandy Doward - 4/10/2016

Working With Axes in MDX SELECT Statements

The SQL Server MDX SELECT statement supports the specification of up to 128 axes, but we generally only use two in our queries.

  • The MDX query editor in Management Studio can only represent two axes, columns and rows.
  • SSRS only supports two axes in MDX SELECT statements.

Specialist client tools might require data to be delivered via more than two axes, but in the main two axes is plenty for our requirements.


by Mandy Doward - 30/9/2016

Plotting Charts With SQL Server R Service

Yesterday I posted a blog article about the R Service available in SQL Server 2016 and showed an example of using regular expressions with the stringr R library.

In this blog I am talking about how R can be implemented for chart plotting purposes in SQL Server.

 


Pages