Hugo’s SQL Server Execution Plan Reference
I’m a big fan of T-SQL Tuesday. Each month there is a host who comes up with a topic, and...
2019-03-18
443 reads
Blogs
Disk Space and SQL Server
Disk Space in SQL Server
One of the frequently required job functions of the database administrator is to track disk space...
2019-04-04 (first published: 2019-03-18)
2,256 reads
Writing a presentation 3: Entering the PowerPoint world
This is a series I’m writing as I prepare for SQL Saturday Chicago 2019. My session is called Performance tuning...
2019-03-18
289 reads
Presenting with VS Code and Running Commands on Remote Hosts
In this blog post, I’m going to show you how to use VS Code and Azure Data Studio for presentations...
2019-03-17
318 reads
Kernel Migrator for SQL Server – Expert Product Review
Ease of use, accuracy, integrity, efficiency, and security are some characteristics which a good software should have, and when we...
2019-03-17
419 reads
Last Week Reading (2019-03-17)
Hi there! I’m in Bellevue, WA today when finishing this post. My first MVP Summit and the second trip to...
2019-03-17
364 reads
Certification on Orchestrating Big Data with Azure Data Factory
I took a break from blogging this week to finish the course for and get certified with Orchestrating Big Data...
2019-04-03 (first published: 2019-03-16)
1,062 reads
Checking Open Ports in Azure
Let’s be honest here, data security is really important to me. Some people probably think that I go to extremes...
2019-04-03 (first published: 2019-03-15)
700 reads
Deploying a stand-alone SQL Server Instance into a Kubernetes Cluster
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2019-05-28 (first published: 2019-03-14)
917 reads
Azure Data Explorer
Azure Data Explorer (ADX) was announced as generally available on Feb 7th. In short, ADX is a fully managed data...
2019-03-14
2,160 reads
Blogs
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Forums
Issue importing data to SQL table
Hi everyone, I have a XML file in which data looks like this: <ArrayOfHomeModel...
Database details missing in SYS.MASTER_FILES view
Hi, I noticed that one of the database information is missing in sys.master_files catalog...
Single index reorg took 2 full days or more to complete
I'm running an index maintenance job on 1 of my large database as the...
Ask SSC