Running SQL Server on my Mac with Docker
My day to day work machine is a Windows 10 HP laptop. It remains docked at my desk where it happily helps me to go about my daily business. ...
2020-05-14 (first published: 2020-05-01)
402 reads
Blog Posts
SSMS Quick Tip
Today’s quick tip is for SQL Server Management Studio (SSMS). From time to time when I’m speaking I’ll get a question on how I pulled up help for a...
2020-05-14 (first published: 2020-04-30)
987 reads
TIL: Get-DbaAgentJobHistory
Another blog post, another dbatools command. Today’s command: Get-DbaAgentJobHistory Basic command, gets all the job history info and pipes it to gridview, because there’s a LOT of info here....
2020-05-14
55 reads
What is Hyper-V? and how to enable it?
Hyper-V is a Microsoft feature to create a virtualized environment. Hyper-V is available in your windows OS and you need to enable it from “Turn On or Off Windows...
2020-05-14
135 reads
Adding Analysis Services (SSAS) to your SQL Server instance–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple task, but recently...
2020-05-13
436 reads
Clustered Index Key – Natural or Surrogate?
This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of...
2020-05-13 (first published: 2020-04-28)
856 reads
Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2020-05-13 (first published: 2020-04-29)
589 reads
Daily Coping 13 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-05-13
9 reads
How SQL Server stores data types: integers and decimals
Last time we looked at the internals of how dates and times are stored in SQL Server. This week we’re going to look at how numbers are stored. This...
2020-05-13
99 reads
Installing the #SQLPrompt Public Preview in ADS
The SQL Prompt Public preview extension for Azure Data Studio is out and you can add this easily. This is a quick post showing a few ways to install...
2020-05-13
181 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers