Two Sessions Up for Vote at SQLRally!
I received great news last week that one of my sessions, Windows Operating System Internals for DB Pros, was accepted,...
2012-02-21
857 reads
Blog Posts
What's New is SSIS 2012? - Find out with Andy Leonard at the NJ SQL User Group - tonight!
As us SQL professional folks know, since the advent of SQL Server Integration Services, affectionately known as SSIS, it has...
2012-02-21
2,614 reads
Where’s My Backup? SQL Server Backup Issues
You can cause yourself problems if you don’t know where your backups are stored, and how they are being made....
2012-02-21
1,515 reads
A Script A Day - Day 11 - User Permissions By Database
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,096 reads
A Script A Day - Day 12 - Granting Role Membership to All Principals
Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
901 reads
Essential Trace Flags for Recovery & Debugging
The following trace flags are essential for a variety of recovery scenarios. The use of trace flags allow the DBA...
2012-02-20
1,760 reads
Reconciling SPNs
As part of troubleshooting Kerberos authentication for SQL Server I had to verify SPNs so I thought I’d blog about...
2012-02-20
2,494 reads
Selected to Speak at SQLRally 2012
I was excited to receive the email on Friday that I’d been selected to present at SQLRally #2 in Dallas...
2012-02-20
602 reads
Sorry...
I've been offline for a week to take some annual leave and recharge my batteries. To make up for the...
2012-02-20
465 reads
Speaking at PASS DBA Virtual Chapter
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on...
2012-02-20
605 reads
Blogs
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...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
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