Enter the 2012 Exceptional DBA of the Year Awards
I was just at SQLRally in Dallas, and I was speaking to a DBA friend of mine over lunch. He...
2012-05-14
1,027 reads
Blog Posts
How To Use T-SQL TIMESTAMP (ROWVERSION) in SSIS
In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type. What are these,...
2012-05-14 (first published: 2012-05-08)
7,998 reads
PASS Data Architecture VC presents Mike Fal: SQL Server Table Partitioning
Thursday’s (May 17th, 2012) PASS Data Architecture Virtual Chapter has Mike demonstrating some cool Table Partitioning scripts which I was...
2012-05-14
550 reads
SQL Rally 2012 Recap
Much Learning Was Had By All
SQL Rally 2012 had a diverse group of speakers and something for all levels of...
2012-05-14
854 reads
SQL Server – Check SQL Agent Job History using T-SQL
To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...
2012-05-14
2,831 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult...
2012-05-14
1,066 reads
The Effective Permissions Tool is Handy
An recurring issue with Integration Services packages that read or write to file systems is permissions issues. It's quite difficult to have a package run properly when it can't...
2012-05-14
13 reads
Varied and Interesting Links
Here are some things I’ve run across in the past few weeks you may find interesting:
FailCon. Billed as a one-day...
2012-05-14
571 reads
We Need More Folks in Technology, Period.
I took my boys to a game design workshop on Saturday that was sponsored and put on by an organization...
2012-05-14
1,280 reads
Chance to win a free seat in my SQL Server 2012 Deep Dive Days workshop in London!
As you might know, I'm
running my "SQL Server 2012 Deep Dive Days Workshop" from May 28
– 30 in Central London....
2012-05-13
957 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