An Example of Test-Driven Development, Part 4
Continuing on with his testing series for T-SQL code, MVP Andy Leonard looks at deployment here.
2010-11-19 (first published: 2009-07-15)
8,915 reads
Articles
Querying Active Directory using SSIS Script Task
One of the most distinguishing characteristics of Control Flow Script Task available in SQL Server 2008 Integration Services is its flexibility. This article demonstrates some of these capabilities by describing an approach that employs the Script Task to query data residing in an Active Directory domain database.
2010-11-19
2,759 reads
SSIS Training Live and In-Person
MVP and author of our Stairway Series on SSIS, Andy Leonard, is holding an SSIS class this December in northern Virginia. If you are interested in top notch SSIS training, read on.
2010-11-19 (first published: 2010-11-02)
5,610 reads
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
2010-11-19
2,168 reads
Improving Database Design and Performance Using Compression
This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.
2010-11-18
9,213 reads
SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
2010-11-18
512 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-18
3,382 reads
SQL Server Agent Job Management Scripts
In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.
2010-11-18
4,353 reads
Handy Hardware Assessment Tools For SQL Server
Here is a small selection of useful tools for getting some specific hardware information from any Windows based system you...
2010-11-17
4,097 reads
Implementing SQL Server Database Mail
Have you ever wished your database could tell you what's wrong or let you know when a task has completed? SQL Server's Database Mail allows the database to send out messages over SMTP. Deanna Dicken shows you how to set up Database Mail and send some messages.
2010-11-17
3,693 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers