Tag Archives: best practices
-
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
What’s the difference between Files and Filegroups?
Leave a commentMarch 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
GDPR – After the restore
1March 19, 2018 by Kenneth Fisher
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
The default filegroup, and why you should care.
2February 19, 2018 by Kenneth Fisher
You know you can have multiple filegroups right? You might have a separate filegroup for the data (the clustered index …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading -
Restrict the usage of a SQL Server Authenticated Application Id
1December 6, 2017 by Kenneth Fisher
SQL Server login ids may not be the most secure thing in the world but they are likely to be …
Continue reading -
Closing all of the connections to a database
3November 27, 2017 by Kenneth Fisher
Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
Continue reading -
Why shouldn’t I shrink my database data file?
2November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
Continue reading
