When databases suddenly stop working, it can be for a number of different reasons. Human error plays a large part, of course, and the DBA needs to know what these various humans are up to. DDL triggers can help alert the DBA to unauthorized tampering with a production system, of course, but DDL triggers can't tell you everything. At some point, you will need to implement your own checks. Randy certainly reached that point!
2008-07-15
2,971 reads
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
2008-07-15
53 reads
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
2008-07-15
65 reads
How much data do you have that's never accessed. Apparently most of it on a network is just stored and never re-examined. Steve Jones comments on a few statistics.
2008-07-15
66 reads
Table locking hints provide developers much tighter control of their transactions. Look at the benefits and disadvantages of using the NOLOCK and READPAST table hints in SQL Server
2008-07-15
5,492 reads
We're sponsoring over 5 hours over 5 days of training on SSIS and Business Intelligence with Brian Knight, SQL Server MVP and founder of Pragmatic Works.
2008-07-14 (first published: 2008-07-01)
23,866 reads
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
2008-07-14
66 reads
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
2008-07-14
70 reads
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
2008-07-14
53 reads
I need to write a function to determine if particular year is a leap year (i.e. February contains 29 days rather than 28 days). I know that there are various rules for calculating leap years. Is there an easy way to figure this out? Can you provide an example or two to validate various years?
2008-07-14
5,755 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers