Async Network IO SQL Wait
Over the last few days we have been tracking down the cause of some really high async network IO waits. ...
2018-08-30 (first published: 2018-08-15)
3,007 reads
Blog Posts
Custom Data Purging in SQL Monitor
In talking to a customer recently, they were worried about the amount of data kept by SQL Monitor. That’s a...
2018-08-30
407 reads
Helpful Undocumented Stored Procedure “sp_MsForEachDB”
This week’s post will be a short one to talk about a very helpful stored procedure in SQL Server called...
2018-08-30
278 reads
Maps in Power BI. Do I really need them?
(2018-Aug-30) While preparing for a recent Power BI Toronto meetup session, I found a very valuable whitepaper on Maps in...
2018-08-30
1,106 reads
Repair Visual Studio for Mac: Extension node not found in path
A few months ago I ran into a problem after updating Visual Studio for Mac, where it would not start....
2018-08-30
345 reads
Talking Data: Six Word Stories
In six words, can you give a compelling description of your data?
I’m taking the Microsoft DAT248x course as part of...
2018-08-30
326 reads
The unwanted Side Effects of enabling Read Committed Snapshot Isolation
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-08-30
2,039 reads
A software architect replaces a relational database with a relational database
Content warning: This is the second (and final) rebuttal essay about why someone is wrong on the Internet. It is...
2018-08-29
308 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with a blog post about disaster recovery in Azure SQL...
2018-08-29
28 reads
Azure SQL Database disaster recovery
My last blog post was on Azure SQL Database high availability and I would like to continue along that discussion with...
2018-08-29
1,110 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers