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,095 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
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,159 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,235 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
894 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,279 reads
Speaking / Teaching Engagements
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
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,801 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,229 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
692 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
829 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers