Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,058 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)
903 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,741 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,951 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,640 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,137 reads
2010-07-19 (first published: 2009-11-16)
2,499 reads
2010-07-15 (first published: 2010-06-16)
1,863 reads
Blogs
SQL Server In Place Upgrades
By gbargsley
Good morning dear blog reader. Today’s episode is fresh from a great weekend with...
Daily Coping 27 Sep 2022
By Steve Jones
Today’s coping tip is take your time. Make space to just breathe and be...
Running SQL Server in Windows Subsystem for Linux (WSL)
I previously wrote a post on how to convert a SQL Server Docker image...
Forums
The Migration Tool to Use III
Comments posted to this topic are about the item The Migration Tool to Use...
SSIS File System Deployments
I created a package that utilizes environment variables in the configuration manager to toggle...
Create a DACPAC to only update not replace a SQL Server Database
Hi there We have been creating a DACPAC from a SQL server database project...
Ask SSC