Using SQL Prompt Code Snippets for Repetitive Tasks
The post Using SQL Prompt Code Snippets for Repetitive Tasks appeared first on SQLServerCentral.
Configure SQL Server Transparent Data Encryption with PowerShell
The post Configure SQL Server Transparent Data Encryption with PowerShell appeared first on SQLServerCentral.
Interesting Undocumented Tidbits in SQL Server 2019 CU2
SQL Server 2019 Cumulative Update 2 is out, and Microsoft snuck in a few things that they didn’t mention in the release notes. Contained Availability Groups continue to get new investments. In the lead-up to SQL Server 2019’s release, we go …
WHERE GETDATE() BETWEEN StartDate AND COALESCE(CancelDate, EndDate) Is Even Harder to Tune.
In my last post, we started with a memberships table, and each membership had start & end dates. I’m going to create the table and populate it with everyone having an active membership – their StartDate is the same as their Stack Overfl …
SQL SERVER – Linked Server Error – Msg 3910 – Transaction Context In Use By Another Session
One of my clients contacted me for an error that appeared while performing a distributed transaction over a linked server. The interesting part was that the linked server was local SQL Server, this is also called a loopback linked server. In this blog, …
SQL Server CASE Statement Example
The post SQL Server CASE Statement Example appeared first on SQLServerCentral.
Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server
The post Quickly Find and Mask all Sensitive Data with Data Masker for SQL Server appeared first on SQLServerCentral.
WHERE GETDATE() BETWEEN StartDate AND EndDate Is Hard to Tune.
Say you’ve got a memberships (or policies) table, and each membership has start & end dates:USE StackOverflow; GO DROP TABLE IF EXISTS dbo.UsersMemberships; CREATE TABLE dbo.UsersMemberships (Id INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, UserId …
Choosing a Processor for SQL Server
Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same. I have request SQL Server Expert Glenn Berry (b|t) to help us in selecting the right CPU. I am confident that this blog will hel …
Record responses for the State of Database DevOps report
The post Record responses for the State of Database DevOps report appeared first on SQLServerCentral.
Storage 101: Understanding the Hard-Disk Drive
The series so far: Storage 101: Welcome to the Wonderful World of Storage Storage 101: The Language of Storage Storage 101: Understanding the Hard-Disk Drive The storage solutions used by today’s organizations contain hard disk drives (HDDs …
Database Normalization in SQL with Examples
Introduction As a database developer, we might often come across terms like normalization and denormalization of a database. Database normalization is a technique that helps to efficiently organize data in a given database. Essentially, it is a systema …
General Purpose Tier for Azure SQL Database
The post General Purpose Tier for Azure SQL Database appeared first on SQLServerCentral.
Recommended SQL Server Books, 2020 Edition
If you’re the kind of person who likes to read books, here are some that I think would expand your horizons. These links are Amazon affiliate links, so I make a few cents when you buy through ’em. It’s your way of tipping me for the b …
SQL SERVER – Stream Aggregate and Hash Aggregate
SQL Server Performance tuning is an amazing subject, it never stops to amaze me. Every single day, I take only one Comprehensive Database Performance Health Check and keep the rest of the time open for either learning new stuff or helping people with O …