-
Limits vs Goals
1March 14, 2017 by Kenneth Fisher
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us. …
Continue reading -
Review of Azure Fundamentals class on Openedx
Leave a commentMarch 8, 2017 by Kenneth Fisher
My company has recently adopted a Cloud first attitude. Now that’s different from Microsoft’s Cloud first. Microsoft is putting new …
Continue reading -
Using GROUP BY instead of DISTINCT
6March 6, 2017 by Kenneth Fisher
Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
Continue reading -
Event storming! It’s raining emails!
5March 1, 2017 by Kenneth Fisher
One of the most common ways to get an event notification is by email. So what happens when you get …
Continue reading -
Queries with optional parameters
20February 27, 2017 by Kenneth Fisher
These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
Continue reading -
What’s in my backup file?
Leave a commentFebruary 22, 2017 by Kenneth Fisher
Restoring a backup file is pretty easy right? Ok, but what if more than one database backup is stored in …
Continue reading -
Penny wise, pound stupid
Leave a commentFebruary 20, 2017 by Kenneth Fisher
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the …
Continue reading -
Deadlock on ALTER DATABASE
5February 16, 2017 by Kenneth Fisher
I had an interesting problem recently. A database was stuck in single user mode. How exactly was it stuck you …
Continue reading -
Server level database permissions
4February 14, 2017 by Kenneth Fisher
Sometimes you have a requirement to grant permissions to every database on an instance. Historically this has required creating a …
Continue reading -
Deadlock priority
5February 8, 2017 by Kenneth Fisher
Everyone deals with deadlocks from time to time. But sometimes we need to control who’s the deadlock victim and who …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 