Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,037 reads
Peter Sloboda
Object dependencies in xml format
Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
867 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,532 reads
CONTEXT_INFO() and the SQL Calling Stack
Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.
2011-08-29
4,957 reads
Just for fun
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,629 reads
Custom Logging in a transaction
Ever happened that your custom log got rolled back and you were left with nothing but an error_message()?
Try to log into a table variable.
2010-07-22 (first published: 2010-06-30)
1,129 reads
2010-07-19 (first published: 2009-11-16)
2,480 reads
2010-07-15 (first published: 2010-06-16)
1,857 reads
Blogs
Containers: Create a Custom Container
Creating a custom container is where things get truly exciting. There’s actually a ton...
Mini-Rant: Spoofed Phone Numbers and Trust
By Brian Kelley
I’ve seen this more and more over the last year: I receive a phone...
Speaking at SQL Saturday Dallas
Speaking at SQLSaturday Dallas! I’m proud to announce that I will be speaking at SQL...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Reporting Server
I have reporting server which gets replicated from other OLTP server.However, the reporting server...
FlushCache Error Message
While analyzing an issue, I stumbled on to a "FlushCache" error message (error log). ...
Ask SSC