Get Set For Speed
Loops are common in application code, but set-based solutions are the way to go with SQL.
2018-02-23 (first published: 2015-12-29)
6,337 reads
Tom Staab
Temporary exclusive database access
This simple script disconnects any other session that is connected to the specified database by temporarily switching the database to single user.
2015-11-20 (first published: 2015-10-25)
927 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
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...
Random Execute SQL Task(s) keeps hanging when I try to run it in parallel
Hi everyone I am trying to implement parallelism in my SSIS package. There are...
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