Category Archives: Microsoft SQL Server
-
Azure: What’s the difference between SQL Database and SQL Server?
5August 9, 2016 by Kenneth Fisher
If you want to blog T-SQL Tuesday is a great way to get started. On the first Tuesday of each …
Continue reading -
What’s the difference between LEFT and RIGHT OUTER JOINs?
1August 3, 2016 by Kenneth Fisher
A DBA walked into a bar, saw a couple of tables, and asked “Can I JOIN you?” There are several …
Continue reading -
Using impersonation to allow a task without granting the required permission.
9August 1, 2016 by Kenneth Fisher
I use impersonation on a regular basis for a number of different tasks. This one is pretty basic but can …
Continue reading -
When was this database restored?
6July 27, 2016 by Kenneth Fisher
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis. …
Continue reading -
Blogger Questions: What should I blog about?
3July 25, 2016 by Kenneth Fisher
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride, …
Continue reading -
Want to be able to read your database between restores?
Leave a commentJuly 20, 2016 by Kenneth Fisher
When restoring a database there are times when it would nice to restore a bit, check what’s been restored so …
Continue reading -
Is the network your last performance bottleneck?
6July 18, 2016 by Kenneth Fisher
Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options …
Continue reading -
Altering a column in a large table: A case study
21July 14, 2016 by Kenneth Fisher
Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
Continue reading -
Default database file sizes
5July 12, 2016 by Kenneth Fisher
It’s Chris Yates (b/t) birthday! (I think he just tured 19.) And in honor of his birthday we are writing …
Continue reading
SQL Studies 