SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction.
MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.
When should you hire a DBA? Always, of course! Actually Steve Jones doesn't have an answer, but he does talk about why a DBA can help you.
The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.
Computer Systems are aging and as companies try to save money by extending their lifetimes, are we going to see more issues?
What happens when double clicking a .SQL file doesn't open the file in SSMS? This article provides the solution to fixing that annoying SSMS issue.
This article examines the difference between adding a nullable column to a table or a column with a default value.
Steve Jones talks telecommuting today as a recent survey shows that a third of IT professionals would take less pay to work away from the office.
In the second part of the Resource Monitor series we conclude with a look using the Memory tab and Disk tab to diagnose performance issues.
A new project from Microsoft Research has Steve Jones interested. It deals with large data sets to perform graphical modeling. The storage mechanism has Steve Jones interested.
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Comments posted to this topic are about the item Pro SQL Server Internals
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Comments posted to this topic are about the item Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers