SQL Server 2012: Installing Data Quality Services
Greg Larsen shows you how to install Data Quality Services and the companion client tool called Data Quality Client for SQL Server 2012.
Tracking Database File AutoGrowth with Event Notifications
As discussed in my previous Getting Started with SQL Server Event Notifications article, SQL Server Event Notifications allow us to capture and handle events that occur inside the SQL Server database engine. Event Notifications execute for DDL Events and Trace Events and we can use to capture information about the event that fired, and automate […]
Unprotected Queries
There are over half a million database servers out on the Internet without protection. How can this happen?
Free eBook: SQL Server Hardware
A free eBook from SQLServerCentral and Red Gate software can help you learn about the best hardware for your SQL Server instances.
Using SQL Server Concatenation Efficiently
This article shares some tips on using concatenation efficiently for application development, pointing out some things that we must consider and look at when concatenating values or fields in our queries or stored procedures.
Stairway to XML: Level 8 - Deleting Data from an XML Instance
in order to use the modify() method to delete data from typed and untyped XML instances, you must pass an XML DML expression as an argument to the method. That expression must include the delete keyword, along with an XQuery expression that defines the XML component to be deleted. Robert makes it seem simple, as usual.
Working Your 40
Will the 40 hour work week change anytime soon? A survey seems to think so, and Steve Jones (somewhat) agrees.
SSIS Basics: Using the Execute SQL Task to Generate Result Sets
The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.
Last chance for a day of free SQL Server training at SQL in the City 2012
SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012.
Parsing Parameters in a Stored Procedure
This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.
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?