-
Zilch to Speaker: 2016 Summit Abstract Reviews
4July 7, 2016 by Kenneth Fisher
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along …
Continue reading -
Phantom SSIS Changes
Leave a commentJuly 5, 2016 by Kenneth Fisher
That SSIS change just won’t stick! There is a new business requirement, so now you have to change an existing …
Continue reading -
Finding, disabling and enabling foreign keys
3June 29, 2016 by Kenneth Fisher
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if …
Continue reading -
Perfectly Placed Parentheses
14June 27, 2016 by Kenneth Fisher
Like many other programming languages T-SQL uses parentheses () for a number of tasks. To help determine precedence, function calls …
Continue reading -
Database snapshots
4June 22, 2016 by Kenneth Fisher
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating. …
Continue reading -
Minimizing Cloud cost
9June 20, 2016 by Kenneth Fisher
The cloud can be expensive. I had this hammered home the other day by a simple mistake. I’m currently working …
Continue reading -
Help! My backup file has doubled in size.
2June 16, 2016 by Kenneth Fisher
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400! …
Continue reading -
Comparing two query plans
3June 14, 2016 by Kenneth Fisher
This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
Continue reading -
Comparing the contents of two tables Redux
Leave a commentJune 8, 2016 by Kenneth Fisher
I did a post the other day on comparing two tables. It was meant as a general overview but I …
Continue reading -
I need help with DBCC
2June 6, 2016 by Kenneth Fisher
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
Continue reading
SQL Studies
Live, Learn, Share
SQL Studies 