Making the case for CamelCase naming
Coding and database standards like a religion or politics. Some people are fanatics and others really don’t care whatsoever. Getting...
2016-10-17 (first published: 2016-10-10)
3,837 reads
Confessions of a Microsoft Addict
Understanding the new MAXDOP settings in SQL 2016
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,055 reads
SQL 2016 SSMS memory leak?
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,161 reads
An observation about Unicode in SQL Server Management Studio
A week or so ago I read a blog post and tweet about using an emoji in SQL Server. This...
2016-10-14 (first published: 2016-10-02)
2,177 reads
I’m speaking at SQL PASS 2016 (Speaker Idol)
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience...
2016-09-29
773 reads
A really simple bug with SSMS
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...
2016-09-28
525 reads
Splitting CSV strings in SQL 2016
Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...
2016-09-15 (first published: 2016-09-08)
2,690 reads
Join me and Kalen Delaney today for 24HOP
I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...
2016-09-07
345 reads
When should I use a CTE?
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...
2016-08-27
768 reads
I’m speaking at SQL Saturday 563 in Dallas
This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...
2016-08-25
430 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers