Classify your Azure SQL Database
Here I am talking about SQL Data Discovery & Classification feature that is built into Azure SQL Database. With this feature you...
2019-02-04
191 reads
Blog Posts
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework. That’s right. Entity Framework is...
2019-02-04
13 reads
Combine Extended Events and TagWith to Monitor Entity Framework
I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer,...
2019-02-04
164 reads
Cool Stuff in Snowflake – Part 5: Finding Previous Non Null Value
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....
2019-02-04
66 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)
2,504 reads
Interview Trick Questions
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to...
2019-02-04
5 reads
Learning for Feb
By the time you read this, I’ll have decided, but I just finished the first book and need to pick...
2019-02-04
680 reads
SQL Homework – February 2019 – Instance configurations
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not...
2019-02-04
198 reads
SQL Server Monitoring: Keeping track of missing index requests
A lot of us turn to execution plans when we see a slow running query, and it’s not uncommon to...
2019-02-04
190 reads
Step-by-Step: How to configure a SQL Server 2008 R2 Failover Cluster Instance in Azure
Introduction
If you are reading this article you probably are still using SQL Server 2008/2008 R2 and want to take advantage...
2019-02-04
1,016 reads
Blogs
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...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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