Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,076 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)
913 reads
Parallel Processing Using Jobs
Learn about a simple way to run uniform tasks in parallel using self-deleting jobs.
2013-04-29
7,236 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,556 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,644 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,140 reads
2010-07-19 (first published: 2009-11-16)
2,532 reads
2010-07-15 (first published: 2010-06-16)
1,897 reads
Blogs
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
is the ssrs auto refresh without its faults
Hi, i considered power bi with embedded for this. Not a big fan...
What Can a Digital Marketing Agency in the USA Do for Your Business?
A digital marketing agency USA can transform your business by building an effective online...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers