I’m speaking at SQL Saturday 553 in Oklahoma City
This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...
2016-08-16
509 reads
Confessions of a Microsoft Addict
Using PowerShell to find Processor issues & more
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second...
2016-08-18 (first published: 2016-08-11)
2,142 reads
Inside the mind of a c# developer
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
615 reads
Off-Topic: Phone number spoofing. Why is this still a thing?
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
898 reads
SQL Server 2016 FK operator bug?
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,020 reads
I’m speaking at the first ever SQL Saturday San Antonio on 8/13/16!
San Antonio is such a great city with a lot to see and do, such as the Alamo and the...
2016-07-23
359 reads
Off topic–Would you SQL your license plate?
I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought....
2016-07-21
581 reads
Retrieving diagnostic data from SQL Server’s Default Trace
Have you ever tried to query the contents of the default trace and then spent more time trying to figure...
2016-07-18
459 reads
I’m speaking at SQL Saturday Baton Rouge on 8/06/16.
If you’re in Louisiana or Texas this is one SQL Saturday you won’t want to miss. This annual event is...
2016-07-18
294 reads
Azure SQL Database waits you should be aware of…
I’ve been using Microsoft’s cloud database for some time now. I’ve had a few customers with various performance problems and...
2016-07-15
2,194 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