Tag Archives: best practices
-
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
4November 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?
3November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your log file. This one is going to …
Continue reading -
When is it a good idea to consolidate multiple instances?
1October 23, 2017 by Kenneth Fisher
In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
Continue reading -
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
2October 11, 2017 by Kenneth Fisher
I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
Continue reading -
Small identity columns
5October 9, 2017 by Kenneth Fisher
We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
Continue reading -
Do what I say, not what I do
Leave a commentSeptember 20, 2017 by Kenneth Fisher
I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, …
Continue reading -
Turning ANSI_PADDING off, and why you shouldn’t
4June 15, 2017 by Kenneth Fisher
I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
Continue reading
SQL Studies 