SQL Overview SSIS Package II - Retrieving SQL Error Log
In Part II of his series on monitoring SQL Servers, David Bird takes a look at importing data from your error logs.
How to develop TSQL Code
The basic texts for developing SQL code tend to leave unsaid the basic techniques for building routines such as stored procedures in TSQL. Phil Factor is well-known for his more lengthy and complex stored procedures, so we asked him to explain in more detail how he goes about developing things without the comfort of Visual Studio.
Measurements
"If you cannot measure something, you cannot improve it." - Lord Kelvin. That quote and a blog about it inspired today's editorial.
The RECOMPILE Options
This artcle attempts to differentiate between the uses of WITH RECOMPILE and OPTION (RECOMPILE) features.
Table Value Constructors in SQL Server 2008
Table Value Constructors (TVCs) are a useful feature of 2008, allowing you to specify tables of values and expressions. Users who are stuck with previous versions of SQL Server can play along, since Rob Sheldon demonstrates that there have always been ways of doing this in SQL Server, though less elegantly.
We Need a DBA Boot Camp
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
Whether to use UNION or OR in SQL Server Queries
Recently I came across with an article on DB2 about using Union instead of OR. So I thought of carrying out a research on SQL Server on what scenarios UNION is optimal in and which scenarios OR would be best. I will analyze this with a few scenarios using samples taken from the AdventureWorks database
How Much Is It Worth?
This editorial was originally published on Nov 21, 2005. It is being re-run today as Steve is on holiday. How much money is it worth to compromise your ethics? Steve Jones asks today as many companies around the world seem to be doing that.
Raw Materials - Disapproval
: "It is a narrow mind that cannot see things from more than one point of view." —George Eliot
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?