Changing Server Default Collation
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...
2009-05-29
1,615 reads
Blog Posts
Found a Bug in SQL Server 2005
It doesn’t happen often but every once in a while you may be the lucky person to find a previously...
2009-05-29
2,147 reads
Fusion IO’s on Their Way!
My company has taken the plunge and we have two of the Duo 640’s coming. As soon as they get...
2009-05-29
1,533 reads
Security Basics: Applying the Principle of Least Privilege Properly
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do...
2009-05-29
3,155 reads
SQL Rockstar
I was scanning blogs the other day, and noticed Tom LaRock's new image on Twitter. He's SQLRockstar after a little...
2009-05-29
2,006 reads
The Conference ROI
I saw recently that Brent Ozar wrote a blog about justifying the cost of attending the 2009 PASS Summit. I...
2009-05-29
3,370 reads
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and...
2009-05-29
1,947 reads
Book Review: Real Leaders Don't Do Powerpoint
I bought Real Leaders Don't Do Powerpoint by Christoper Witt ($15 at Amazon) on a trip, Powerpoint catching my eye...
2009-05-28
1,735 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,160 reads
Give Us TRIM()!
If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL...
2009-05-28
1,940 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers