Executing all SSIS packages in a folder: three methods
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
Migrating From DTS to SSIS - Part 1
In this presentation, Brian talks about the good, the bad, and the ugly of DTS migrations. Then, he shows you how to migrate a simple DTS package to SSIS and some of the challenges you will see.
SQL Server Spotlight on Ian Jose
We've been profiling quite a few members of the SQL Server development team and this time we get a few minutes with Ian Jose, one of the query processing team.
Anticipate the worst when developing SQL Server databases
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
Writing Simple Select Statements - Part 2
In this second part video from Kathi, she covers how to write T-SQL in much more indepth. She covers how to handle NULLs and many more items in this video.
Reporting Services 2005 101 using Web Client
Continuing with his series on different aspects of Reporting Services, Asif Sayed examines the next installment with a step by step tutorial demonstrating the power of locally processed Reporting Services with the ASP.NET Web Client.
Dealing with Database Concurrency Conflicts in the Real World
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
Stress Testing SQL Server
Properly sizing your SQL Server hardware and testing application loads against them is a complex and difficult topic. Anthony Bressi brings us a great new article that gives you a systematic approach to performing your own stress test.
Executing predictions from the SQL Server relational engine
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
Self Eliminated Parameters
Optional parameters are easily handled with NULL values in T-SQL, but there are cases where this doesn't always work. Alex Grinberg brings us a new technique to allow your stored procedures to be structured to deal with this situation without dynamic SQL.
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
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...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
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...
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