Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,044 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)
881 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,557 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
5,219 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,631 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,132 reads
2010-07-19 (first published: 2009-11-16)
2,482 reads
2010-07-15 (first published: 2010-06-16)
1,857 reads
Blogs
How I passed the 70-761 certification exam
By DesertDBA
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over...
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Forums
Relatively easy query assistance - datediff
Hi all, I have a question since I'm new to SQL: I have a...
Mirroring alerts
Hi, In one of our customers the database mirroring was already configured. After long...
On Looking and Acting the Part
Comments posted to this topic are about the item On Looking and Acting the...
Ask SSC