Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,070 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)
906 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
6,969 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
6,297 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,643 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,138 reads
2010-07-19 (first published: 2009-11-16)
2,508 reads
2010-07-15 (first published: 2010-06-16)
1,865 reads
Blogs
Creating an Empty Repo in GitHub–#SQLNewBlogger
By Steve Jones
I saw someone struggling with getting started with a Visual Studio project and Azure...
Product Review: DataVeil
By Brian Kelley
If you’re looking at data masking tools, I recently was able to review the...
The Last Price Bump for the Data Community Summit
By Steve Jones
This week the cost of the PASS Data Community Summit jumps up to full...
Forums
Partition Large Tables needed
Hello Gurus, I have a requirement and need to implement the solution quickly. SQL...
Deleting the Standby file
Comments posted to this topic are about the item Deleting the Standby file
If You Build It, Will They Use Linux?
Comments posted to this topic are about the item If You Build It, Will...
Ask SSC