Using WMI Data Reader and WMI Event Watcher Tasks in SSIS
Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.
Invitation to startup meeting for PASS Scania and SQLUG
A new user group in Sweden. Read for more details.
Optimising “Ends With” searches with REVERSE
A simple way to improve performance for queries that use the LIKE operator. Ben Seaman shows how to deal with searches that look at the end of a piece of text
All About the Crosstab Query
Most relational databases don't provide an easy way to create crosstabs. Rob Gravelle shows you one of several ways to create crosstabs using regular SQL.
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Why Can't We Go Backwards?
How many times have you wanted to restore a database to an earlier version? Today Steve Jones asks why can't we do this and includes a way for you to vote on this.
Goal Tuesday
Almost halfway into the first month of the new year, Steve Jones reminds us of the power of goals. Today he encourages you to set up your own goals for the coming year.
Run SSIS packages from remote client with stored procedure
By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers