Dynamic Search Conditions
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2007 Tech Salary Survey Results
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
A Bad Report Card
The Federal Communications Commission doesn't get a good report on it's data handling and management processes.
Feature (In)Complete
A look at some of the interesting database news from the previous week (March 24, 2008).
Name value pair (EAV) model
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
Ready Made Code Snippet Tool Box Courtesy of SCOM
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
March Madness
How disruptive is the annual college basketball tournament to work? Steve Jones doesn't think it's a problem.
SQL Server 2008 security and compliance features reduce security risks
Looking at this from a confidentiality, integrity and availability perspective – the essence of security and compliance – there are quite a few new selling points.
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers