Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,057 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)
897 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,664 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,684 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,638 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,136 reads
2010-07-19 (first published: 2009-11-16)
2,490 reads
2010-07-15 (first published: 2010-06-16)
1,861 reads
Blogs
Daily Coping 24 Sept 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using environment variable files for SQL Server in containers
There are a whole bunch of environment variables that can be used to configure...
How to Design Backups in SQL Server?
By nelsonaloor
The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...
Forums
Making Software Decisions
Comments posted to this topic are about the item Making Software Decisions
Working with the Delete Activity in Azure Data Factory
Comments posted to this topic are about the item Working with the Delete Activity...
Ask SSC