Category Archives: Microsoft SQL Server
-
Using an ORDER BY in a view
27September 19, 2016 by Kenneth Fisher
For many years it’s been a best practice to never put an ORDER BY in a view. The idea is …
Continue reading -
Emojis in SQL Server
13September 15, 2016 by Kenneth Fisher
I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures …
Continue reading -
Azure: Creating a BACPAC from an On-Premises SQL Server Database
1September 13, 2016 by Kenneth Fisher
So to start, what’s a BACPAC? Per the Azure documentation When you need to create an archive of an Azure …
Continue reading -
SA Spoof
14September 8, 2016 by Kenneth Fisher
This is nothing new but it’s still a fun idea. The problem: The vendor app we just purchased (and are …
Continue reading -
Accidental DBAs, the Developer Edition
Leave a commentSeptember 6, 2016 by Kenneth Fisher
I recently spoke at the OKC SQL Saturday. I had an wonderful time and the organizers, volunteers and other speakers …
Continue reading -
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
SQL Studies 