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
Articles
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,211 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
TSQL Challenge 43 – Identifying incomplete segments and missing elemen
This challenge involves writing a logic to identify incomplete segments and missing elements in an electronic data integration file exchanged between two applications.
2010-11-16
856 reads
Capturing and Logging Data Load Errors for an SSIS Package
In an ETL solution, error logging is a fundamental requirement for various aspects of the application and is very useful at various stages of the ETL execution life-cycle. Let's consider a scenario where our requirement is to insert records into a SQL Server table. The package should attempt loading all the records and whichever records fail, error details reported by the database engine should be reported. We will look at how to implement this in a SSIS package.
2010-11-16
3,997 reads
SQL Saturday #59 - New York City
A free day of training in New York City just before Thanksgiving. Come see Steve Jones and Grant Fritchey, along with a number of other great speakers.
2010-11-16 (first published: 2010-11-04)
2,471 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Finding Motivation
Comments posted to this topic are about the item Finding Motivation
The Last Binary Value of the Year
Comments posted to this topic are about the item The Last Binary Value of...
SQL Art, Part 2: New Year Fireworks in SSMS
Comments posted to this topic are about the item SQL Art, Part 2: New...
Question of the Day
The Last Binary Value of the Year
What does this code return?
SELECT cast(0x2025 AS NVARCHAR(20))Image 1:
Image 2: 
Image 3: 
Image 4: 
See possible answers