Data Masker for SQL Server and Temporal Tables
A customer had a question recently about using Data Masker for SQL Server and temporal (or system versioned) tables. I...
2018-07-18
944 reads
Blog Posts
Is this a SQL Provision Cloned Database?
As I work with SQL Provision, I keep finding new questions and concerns from clients and customers. Recently I had...
2018-07-18
687 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the...
2018-07-18
11 reads
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored...
2018-07-18
2,032 reads
Performance Tuning Exercise: Lazy Table Spool
Folks, it’s time for a bit of a performance tuning exercise. Below is a real world situation where a stored...
2018-07-18
22,826 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends...
2018-07-18
8 reads
TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates...
2018-07-18
240 reads
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,709 reads
Working Hard in Baton Rouge
I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays...
2018-07-18
416 reads
Building Dynamic Table-Driven Queries
This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for...
2018-07-17 (first published: 2018-07-10)
3,384 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