SQL Server 2008 and 2008 R2 Integration Services - Managing Remote Processes Using Script Task
Marcin Policht discusses ways to launch processes for remote systems using SQL Server 2008 R2 Integration Services.
2011-04-07
3,153 reads
Administration
Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
2011-04-06
4,478 reads
TOP 10 SQL Server Requests That Should Be Automated
What DBA wouldn't want to make their job a little easier?
2011-04-05
6,926 reads
2011-03-23
2,516 reads
Lipoaspiration in your SQL Server Database
Once, when disk space was at a premium, DBAs fought hard to keep the size of their database down. Now there seems less motivation to 'fight the flab' of a database. Fabiano Amorim was watching television recently when the subject matter, cosmetic surgery, gave him the theme and inspiration for this guide to keeping your database fit and trim.
2011-03-16
4,312 reads
2011-03-02
2,287 reads
SQL Server Error Log Scanning
This article will show you how to scan SQL Server Error Logs with ease and track important information that is stored there.
2013-09-06 (first published: 2011-02-14)
15,845 reads
2011-02-11
2,705 reads
2011-02-08
2,749 reads
2011-02-07
3,292 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers