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)
673 reads
John
Secure Travel
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in...
2019-03-22 (first published: 2019-03-08)
1,948 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
412 reads
Restoring a Database from Azure
In a previous post, I described how you can use Azure storage to store SQL Server database backup files. This...
2019-03-01
469 reads
Adding Azure VM Boot Diagnostics
A couple of weeks ago, I blogged about boot diagnostics and how they can help you troubleshoot issues when virtual...
2019-02-22
185 reads
Modern Hardware with 64 CPUs
In today’s world, more often then not you might run into systems that have large beefy hardware. Hundreds of gigabytes...
2019-02-21 (first published: 2019-02-01)
2,445 reads
Achievement Unlocked – SQL Bits
Several weeks ago, while on a flight traveling home from San Francisco, I received an exciting email. I had submitted...
2019-02-15
450 reads
Azure Virtual Machine Boot Diagnostics
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state,...
2019-02-08
226 reads
Finding Cluster Log Errors
Sometimes you know that a problem occurred, but the tools are not giving you the right information. If you ever...
2019-02-04 (first published: 2019-01-18)
1,847 reads
Microsoft Update Catalog
In today’s world of database administrations, there are a plethora of tools and resources that can be available to utilize...
2019-01-25
171 reads
Blogs
Containers: Working With Volumes
In the previous two posts on containers I showed how use Docker commands to...
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the...
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
By Steve Jones
I was recently doing some work on Always Encrypted in SQL Server 2019 and...
Forums
The Change Failure Rate
Comments posted to this topic are about the item The Change Failure Rate
Query help on Pivoting on two columns
DECLARE @RegionCounts Table ( TYear char(2), Region varchar(30), RowCnt int ) Insert into @RegionCounts...
Response to Bloor article on SQL Provision
I found the article https://www.sqlservercentral.com/articles/bloor-scores-sql-provision-4-5-out-of-5-for-test-data-provisioning Interesting if a little shallow. It would be more...
Ask SSC