You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across...
2009-02-20
3,060 reads
Databases – Infrastructure – Security
The Limited Usefulness of Encrypting File System (EFS) and Transparent Data Encryption (TDE)
This is something that hit me as I was presenting to the Charlotte SQL Server User Group last night.
Back...
2009-02-18
4,086 reads
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
Counterpoint: Against Specialization
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
New Security Bulletin for SQL Server 2000/2005 (MS09-004)
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
Things you know now...
This was the brainchild of Mike Walsh, who asked, "What do you wish you knew when you were starting?" I...
2009-02-10
1,257 reads
SQL Server 2008 Enterprise Edition install - use the "right" version of the Microsoft .NET 3.5 SP1 install
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
Professional Goals for 2009
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
Speaking / Teaching Engagements
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
SQL Server security bulletin due on Tuesday
As part of its advance notification, Microsoft has released the list of security bulletins that should be coming our way...
2009-02-05
824 reads
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
how to calculate an average only if a minimum number of records exist?
Hi I am working on a rolling average calculation that is not working quite...
Subscribing to a Great New Year
Comments posted to this topic are about the item Subscribing to a Great New...
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers