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
Daniel Janik
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
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
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
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
458 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
Spark Connect Dotnet November 2024 Where are we?
By Ed Elliott
All Spark Connect Posts Introduction There have been quite a few changes in the last...
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Forums
How Do You Patch 100 Database Servers?
Comments posted to this topic are about the item How Do You Patch 100...
Microsoft SQL announcements at PASS Data Community Summit 2024
Comments posted to this topic are about the item Microsoft SQL announcements at PASS...
How to Develop Custom T-SQL Code Snippets in Azure Data Studio
Comments posted to this topic are about the item How to Develop Custom T-SQL...
Question of the Day
What's the Ceiling?
What do I get as the results from this code?
SELECT CEILING (999.999), CEILING (-999.999);See possible answers