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.
2010-01-14
2,270 reads
Articles
Invitation to startup meeting for PASS Scania and SQLUG
A new user group in Sweden. Read for more details.
2010-01-13
424 reads
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
2010-01-13
12,618 reads
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.
2010-01-13
5,114 reads
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-13
1,708 reads
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.
2010-01-13
2,248 reads
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.
2010-01-13
2,500 reads
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.
2010-01-13
2,382 reads
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.
2010-01-12
9,712 reads
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-12
628 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers