SQL Saturday #167 - Columbus, GA
A free day of training in Columbus, GA. Come meet the local SQL professionals and spend a day talking SQL Server.
Outsourcing Jobs
This week Steve Jones looks at some of the jobs being outsourced and how that might affect data professionals.
Ten Million Lines of Code
Intuit manages ten million lines of code in a single codebase and does a great job of it. Read a little about what they do.
Practical PowerShell for SQL Server Developers and DBAs – Part 1
There is a lot of confusion amongst DBAs about using PowerShell due to existence the deprecated SQLPS mini-shell of SSMS and the newer SQLPS module. In a two-part article and wallchart, Michael Sorens explains how to install it, what it is, and some of the excellent things it has to offer.
Fix v. Create
This Friday Steve Jones wants to know how you spend your time. Do you get to do a lot of new development or do you end up fixing, tuning, and improving old code. Let us know.
Solving the SQL Server Multiple Cascade Path Issue with a Trigger
This tip will look at how you can use triggers to replace the functionality you get from the ON DELETE CASCADE option of a foreign key constraint.
SQL in Boston -- Red Gate Style
Adam Machanic is speaking at SQL in the City - Boston on Oct 8, 2012.
Being Exceptional
It's time to vote for the Exceptional DBA awards, and Steve Jones is asking for your opinion. Take a moment and recognize one of your peers as the best DBA in 2012.
Working with SQL Agent Durations
SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.
Provisioning a New SQL Server Instance – Part Two
So how should you install and configure SQL Server 2012 properly? Glenn Berry completes his two-part series by explaining the steps needed to complete the preparation and do the actual installation.
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