SQL server connection and blocking finding script
SQL server connection and blocking finding script...
[[ This is a content summary only. Visit my website for full links, other...
2019-02-06
178 reads
Blog Posts
Using Cloud Academy
The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using...
2019-02-06
213 reads
Using Docker to run Integration Tests for dbachecks
My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...
2019-02-06 (first published: 2019-01-19)
2,268 reads
Versions of Stored Procedures
I never knew this, but stored procedures have versions.
I was browsing the CREATE PROCEDURE doc page, and stumbled upon this...
2019-02-06
1,046 reads
What is Azure Key Vault?
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud...
2019-02-06
252 reads
When the buffer pool isn’t just in memory
Last time we looked at the four major components of a computer system, and then looked at the SQL Server...
2019-02-06
193 reads
Forensic Analysis on Updated Values of Database Tables to Check Any Digital Crime
SQL Server is a relational database management product developed by Microsoft. It is prominently deployed by enterprises all over the...
2019-02-05
520 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
4 reads
Automating Database Maintenance with Jess Pomfret and dbatools
Watch this week's video on YouTube
dbatools is one of the coolest community projects I've seen - it is amazing how many commands are available to help make managing your...
2019-02-05
5 reads
Automating Database Maintenance with Jess Pomfret and dbatools
dbatools is one of the coolest community projects I’ve seen – it is amazing how many commands are available to help...
2019-02-05
199 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