Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,040 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)
868 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,551 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,078 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,630 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,131 reads
2010-07-19 (first published: 2009-11-16)
2,481 reads
2010-07-15 (first published: 2010-06-16)
1,857 reads
Blogs
Restoring Backups from Azure Blob with dbatools
Recently I needed to write a PowerShell script that could build a backup set...
Good to see you at Houston Tech Fest 2019!
By Will Assaf
It was awesome to see a great crowd at the triumphant return of Houston...
Using kubectl logs to read the SQL Server Error Log in Kubernetes
When working with SQL Server running containers the Error Log is written to standard...
Forums
Is Data the Future of the Vibrant Web?
Comments posted to this topic are about the item Is Data the Future of...
Primary server stay on resolving state- Always ON
Hi All , In my case we’re Looking the cause why in our Always...
fail over database in high availability - Always On
Hi All, Currently we have configured Always on - High Availability in our SQL...
Ask SSC