Why I Write
I have a great job. Actually it’s a fantastic job for me. I have flexible hours, I can work almost...
2010-07-13
372 reads
Blog Posts
Writing Better Queries in Steel City
T-SQL is a very forgiving language. As long as you have the basic syntax of the statement correct, SQL Server...
2010-07-13
428 reads
Conversion Between Unicode and Non-Unicode Data Flow Pattern
I don't think I'm alone when I find myself having to convert several columns in my Data Flow from Unicode...
2010-07-12
1,014 reads
Degree Seeker Week at SQL University, Extra Credit
Degree Seeker Week at SQL University, Extra Credit
Welcome back to Degree Seeker Week at SQL University. If you have returned...
2010-07-12
1,752 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
949 reads
Exceptional DBA of the Year 2010 Finalist!
This post is a tad overdue as the public announcement was a few weeks back but it’s been a topsy-turvy...
2010-07-12
451 reads
It is Great to Get Feedback From My Readers
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
508 reads
Mix & Match – Day 4
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
382 reads
Old McDonalds and The Cow Store
As a child did you have a place that was your ‘thing’, something that just the mention of it would...
2010-07-12
511 reads
PowerShell and Effective Meetings at PASS 2010
Last week, PASS announced this year’s program for the 2010 Summit in Seattle, Washington. The program session are available online....
2010-07-12
443 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers