Service Broker Transactional Support in SQL Server 2005 Express Edition
This article provides an overview and presents an example illustrating the role of transactions in processing Service Broker dialogs usage.
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across is that you must trust those folks responsible for account and server management when it comes to securing your data. Yes, you can put in...
Chargeback
Should IT charge other departments for the use of its resources? Is that good for the business? Steve Jones comments on what this could mean for SQL Server DBAs.
XML Workshop XXIII - A TSQL ATOM Library
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
Creating packages in code - Flat File Source to OLE-DB Destination
This code sample programmatically creates a package that imports a text file into SQL Server, with a Flat File Source and the OLE-DB Destination. This shows how you can leverage the SSIS engine to write your own data import tool for example, but beware importing files is not as simple as it may seem
Networking - Part 6
You can read the previous posts here. To finish up (I think), I want to share a networking technique I stumbled on a few years ago, and talk about one more good reason to network.
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
SSIS New Features in SQL Server 2008 - Part 5
This article is final part of a 5 part series that explores the SSIS features introduced in SQL Server 2008. The final artilce in the series will explore VSTA support for the Script Task and Script Component, Import And Export Wizard Enhancements and how SSIS leverages SQL Server 2008 features.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?