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
149 reads
Blog Posts
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
451 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)
859 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)
592 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
11 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
113 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
192 reads
Running Azure from my android phone
The other day I had a random thought. I wonder if there is a version of Azure Portal for Android. ... Continue reading
2020-05-13
73 reads
Daily Coping 12 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-12
16 reads
New Webinar with Kevin Kline: Learning from Data Breaches, a Deeper Dive
I’ve done a follow-on to my webinar with Kevin Kline on Learning from Data Breaches. Here we’ll talk about some specific technologies that come out of the box with...
2020-05-12
28 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers