Practical Applications of Extended Properties
Produced: 25/12/2016 12:01:00
So you might be wondering what use Extended Properties could have outside of the simplistic “this helps explain columns” approach that I mentioned?

Continued...
Querying Extended Properties
Produced: 18/12/2016 11:58:00
Now you know all about Extended Properties, I’ll provide a quick script that allows you to query them effectively and quickly.

Continued...
Adding and Removing Extended Properties
Produced: 11/12/2016 11:54:00
This is an obvious continuation of my previous post about Extended Properties in which I will show you how easy it is to add and remove Extended Properties from a table in SQL Server.

Continued...
What Are Extended Properties
Produced: 04/12/2016 11:50:00
Extended Properties are a feature of SQL Server which are, in my opinion at least, massively underutilized and should be embraced a lot more frequently.

Continued...
Statistics On Views Via Linked Server
Produced: 27/11/2016 17:51:00
As a follow-up to my last post about accessing synonyms via a linked server (you can’t), I stated that it was therefore better to use a view. However, that has issues of its own to consider.

Continued...
Accessing Synonyms Via Linked Server
Produced: 20/11/2016 17:48:00
This was new to me and something which has appeared as a major downside for me when considering whether to use synonyms or views within my databases.

Continued...
Should I Use Synonyms or Views
Produced: 13/11/2016 17:44:00
This is a discussion I’ve had recently and it’s a bit of a weird one because there are actually very few times in which I would ever use a synonym, more often than not I would favour the view.

Continued...
Temp Tables vs Variable Tables
Produced: 01/12/2013 16:39:00
This is possibly one of the most contentious issues I’ve come across in SQL Server. If you look online then there are numerous people arguing numerous aspects of these two types of table and weighing the benefits and pitfalls of each. This includes where they’re stored, how they’re used, which is best etc.

Well I figured that it was time for me to give my own spin on the topic so I’ve spent some time poking around in SQL Server to see what I can find and deduce. So here it is… my musings over a topic that tends to upset all and sundry which therefore means I’m likely to do the same. I’ll try not to disappoint by including wild accusations, general stabs in the dark, and back it all up with flimsy evidence at best.

Continued...
SQL Server 2008 Swapping Database Names (sp_renameDB Bug)
Produced: 27/10/2013 19:08:00
This is a bug I found within SQL 2008 (and R2) which has caused me endless problems within my system. I now have a workaround, but it’s clumsy and I really don’t appreciate having to do it.

Continued...
How to Set Up a Linked Server Using SSMS
Produced: 09/06/2013 11:42:00
In environments in which multiple SQL Servers (or other databases such as mySQL) are present, there are many times in which server A could require data from a database on server B. In order to accommodate this scenario SQL Server presents us with the Linked Server.

This is basically an integrated means of connecting to other SQL Servers whilst also giving a level of control between the systems such as security settings.

Continued...
Create a Database Using SSMS
Produced: 10/03/2013 13:04:00
This article will show you how to create your very first database using SQL Server Management Studio's GUI. This is a very simple process and will allow you to then move on to creating tables and other objects in which to store your data.
How to Create a Table in SQL Server
Produced: 03/03/2013 19:00:00
There are a couple of ways of achieving this, the first is using SQL Server Management Studio as a “point and click” tool, and the other is using T-SQL code.

Personally I only ever use T-SQL and therefore this article will focus on that approach. Personally I find that T-SQL offers much clearer control and power than solely using the GUI.

Continued...
How to Create a Database Using T-SQL
Produced: 24/02/2013 10:26:00
This article will show you how to create your very first database using T-SQL code. This is a very simple process and will allow you to then move on to creating tables and other objects in which to store your data.

Continued...