This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We went at the old tried and true way, we detached the databases, moved the files, and re-attached the databases. That seemed to work well...
2009-02-20
2,133 reads
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,095 reads
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,159 reads
Brent Ozar wrote his Things you know now and in it he says this under his first point, Pick one...
2009-02-11
2,232 reads
Affected Versions:
SQL Server 2000 SP4SQL Server 2005 SP2Unaffected Versions:
SQL Server 2005 SP3 SQL Server 2008Original Vulnerability Report:http://www.securityfocus.com/archive/1/archive/1/499042/100/0/threaded
Microsoft Security Bulletin Link:http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx
Brief Analysis:
The...
2009-02-11
891 reads
This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...
2009-02-10
1,277 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild , but I got too busy. Here are my current speaking / teaching engagements for the first half of the year:
2009-02-10
158 reads
This is something that bit us over the weekend as we attempted to install two new SQL Server 2008 Enterprise...
2009-02-09
1,793 reads
Every time management / professional development book out there tells one to not only develop goals but actually write them down. That's...
2009-02-06
1,227 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....
2009-02-06
691 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers