Blogs

Blogs

TSQL – ISNULL or COALESCE
TSQL – ISNULL or COALESCE
20th June 2016
ISNULL, SQL, SQL Server
What? Really! Just Use ISNULL… I hear this all the time (especially from developers that are new to SQL). Here is a story about George and how Jim ch
SQL Server - Linked Server Between SQL Server 2012 and SQL Server 2000
SQL Server - Linked Server Between SQL Server 2012 and SQL Server 2000
2nd June 2015
Linked Servers, PSP Knowledge, SQL
The Issue If you have ever used Linked Servers within SQL then you will appreciate the benefits of being able to connect directly from one SQL Server
Backup Microsoft SQL Server 2014 Express Databases Automatically
Backup Microsoft SQL Server 2014 Express Databases Automatically
11th May 2015
Microsoft, PSP Knowledge, SQL
We have a client who has SQL Express 2014 and wanted to automate backups. Please find the steps to create automated backups using SQL Express 2014.Ste
SQL Server Tips: SQL CRUD
SQL Server Tips: SQL CRUD
11th March 2015
Create, CRUD, Delete
Overview CRUD? Create Read Update Delete – CRUD. This term refers to the four general actions that can be taken when it comes to data. This is a glob
SQL Server Tips: Primary Keys, Foreign Keys and Indexes
SQL Server Tips: Primary Keys, Foreign Keys and Indexes
26th February 2015
Columns, Foreign Keys, Indexes
Overview When it comes to retrieving data from your tables, indexes play a fundamental role in finding that data you require and finding it fast. Pre
SQL Server: Databases
SQL Server: Databases
16th January 2015
Database, PSP Knowledge, SQL
Overview Databases are formed, primarily, from tables with each table containing columns and rows similar in appearance to that of a spreadsheet. Thi
SQL Server Tips: Tables and Columns
SQL Server Tips: Tables and Columns
16th January 2015
Columns, PSP Knowledge, SQL
Overview A database is made up primarily of tables, a table is made up of columns and rows and each row contains data for each column. When creating
SQL Server: Security
SQL Server: Security
16th January 2015
Security, SQL
Overview Like many things, databases contain a method of keeping data secure.  Where the operating system handles security at a file level, SQL
SQL Server: Databases via a Service
SQL Server: Databases via a Service
13th January 2015
PSP Knowledge, Service, SQL
Overview Microsoft SQL Server, along with many other enterprise level database solutions, runs as a service. It is important to understand the differ
Data Warehousing – The SME Legacy
Data Warehousing – The SME Legacy
13th November 2014
Data Warehouse, Excel, Investments
Once only larger companies needed to consolidate ‘big’ data sets from multiple systems into a single reporting and analysis Data Warehouse but with SM
SQL: String Concatenation
SQL: String Concatenation
16th October 2014
Concatenation, ISNULL, Join
The Issue A few days ago I was asked to look over some SQL statements written by someone new to SQL.  They were getting some unexpected results
Tip: Retrieving SQL Commands from SQL Profiler
Tip: Retrieving SQL Commands from SQL Profiler
13th October 2014
PSP Knowledge, SQL, SQL Profiler
The Issue So, the other day I am sitting around watching a bit of SQL Profiling on the old laptop, to see what a set of API requests were actually do
This website uses cookies to provide the best possible experience. By continuing to use our website you are agreeing to our use of cookies.