Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We...
2009-02-13
2,151 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,151 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,222 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
888 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,256 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,784 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,221 reads
I should have put this out earlier, before going to the SQL Server Innovators Guild, but I got too busy....
2009-02-06
685 reads
As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...
2009-02-05
823 reads
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
3,935 reads
A while back I wrote about how to use a Cross Platform (or Clusterless)...
By Brian Kelley
Tomorrow, November 19, 2024, at 1 PM EST, I'm giving a webcast on SQL...
Today I have uploaded SQL Server Quickie #48 to YouTube. This time I’m talking...
I need help, please! I have a monitoring table that pulls in information about...
We still have a couple of dino's. What should I check to re-enable access...
Hi All, I have few sql server agent scheduled jobs which are supposed to...
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers