Monthly Archives: September 2016
-
Pinned Tabs
5September 27, 2016 by Kenneth Fisher
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) …
Continue reading -
Nil to Speaker: Improving your PowerPoint skills
1September 26, 2016 by Kenneth Fisher
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve …
Continue reading -
A quick fix for a full identity column.
2September 21, 2016 by Kenneth Fisher
A while back I wrote a post on everything I knew about identity columns. In it I mentioned the following: …
Continue reading -
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