Monthly Archives: August 2016
-
The new Data Migration Assistant has been released!
5August 31, 2016 by Kenneth Fisher
Monday Bob Ward (b/t) announced on twitter that the new Data Migration Assistant had been released. First things first the …
Continue reading -
Natural vs Artificial Primary Keys
6August 29, 2016 by Kenneth Fisher
There has been a long standing debate over the use of a natural primary key vs an artificial one. I …
Continue reading -
Copying an on-premise Database to an Azure SQL Database
4August 24, 2016 by Kenneth Fisher
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud. …
Continue reading -
Cloud Security
1August 22, 2016 by Kenneth Fisher
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those …
Continue reading -
RBAR vs Batch
10August 17, 2016 by Kenneth Fisher
Many years ago Jeff Moden (of SQL Server Central fame) came up with the concept of RBAR. Row-By-Agonizing-Row. At it’s …
Continue reading -
Temper, Temper
7August 15, 2016 by Kenneth Fisher
Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a …
Continue reading -
Azure: What’s the difference between SQL Database and SQL Server?
5August 9, 2016 by Kenneth Fisher
If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each …
Continue reading -
What’s the difference between LEFT and RIGHT OUTER JOINs?
1August 3, 2016 by Kenneth Fisher
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
Continue reading -
Using impersonation to allow a task without granting the required permission.
9August 1, 2016 by Kenneth Fisher
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
Continue reading
SQL Studies 