Tag Archives: microsoft sql server
-
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 -
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
SQL Studies 