Newsletter Archive

SQL Server Name Convention and T-SQL Programming Style (2019-12-10) (December 10, 2019)
Increase Query Speed with Covering Indexes (2019-12-09) (December 9, 2019)
Azure DevOps - New Microsoft SSIS Deploy task (DBW 2019-12-07) (December 7, 2019)
Performance Tuning Using Extended Events: Part 1 (2019-12-06) (December 6, 2019)
Migrating Column Level Encryption from 2008R2 to Azure SQL Database (2019-12-05) (December 5, 2019)
Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework (2019-12-04) (December 4, 2019)
It's More Than What You Know (2019-12-03) (December 3, 2019)
Query Performance Diagnostics with sp_PerfSQ (2019-12-02) (December 2, 2019)
Azure Arc-Servers, Accelerated Database Recovery, and more in Database Weekly (11/30/2019) (November 30, 2019)
View R Plots from within SQL Server Management Studio (2019-11-29) (November 29, 2019)
The Road to Database CI (2019-11-28) (November 28, 2019)
Stairway to Biml Level 2: Biml Basics (2019-11-27) (November 27, 2019)
Moving Encrypted Data to Azure SQL Database (2019-11-26) (November 26, 2019)
How Bad are Bad Page Splits? (2019-11-25) (November 25, 2019)
When Select * Doesn’t Matter (Database Weekly 2019-11-23) (November 23, 2019)
Best Option for Working with Files in SSIS (2019-11-22) (November 22, 2019)
Verify your SQL Server database backups (2019-11-21) (November 21, 2019)
Stairway to Biml Level 1: What is Biml? (2019-11-20 ) (November 20, 2019)
Understanding Outer Joins in SQL (2019-11-19) (November 19, 2019)
Collections (2019-11-18) (November 18, 2019)
Expensive Indexes, Low Cost Power BI Reports, PowerShell Puzzles, and more in Database Weekly (11/16/19) (November 16, 2019)
Scripting Tables and Procedures from SSMS (2019-11-15) (November 15, 2019)
How to Decipher @@Options (2019-11-14) (November 14, 2019)
Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages (2019-11-13) (November 13, 2019)
ASCII Text Dump (2019-11-12) (November 12, 2019)
Parameter Pain (2019-11-11) (November 11, 2019)
A Big Week for the Data Platform (DBW 2019-11-09) (November 9, 2019)
Displaying Execution Plans (2019-11-08) (November 8, 2019)
Redistributing Data Across Files (2019-11-07) (November 7, 2019)
Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once (2019-11-06) (November 6, 2019)
Managing a Recursive Group on SSRS Reporting Services Reports (2019-11-05) (November 5, 2019)
How to filter non-existing records in SQL (2019-11-04) (November 4, 2019)
SQL Server 2019 Editions and Features Announced - Database Weekly (2019-11-02) (November 2, 2019)
Challenge Your Code Design (2019-11-01) (November 1, 2019)
Using OFFSET for Paging (2019-10-31) (October 31, 2019)
Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL (2019-10-30) (October 30, 2019)
Oops, I deleted that data (2019-10-29) (October 29, 2019)
Transaction Isolation Levels (2019-10-28) (October 28, 2019)
Make the most of your PASS Summit Evenings (Database Weekly 2019-10-26) (October 26, 2019)
Pattern Recognition via Principal Components Analysis (2019-10-25) (October 25, 2019)
Fixing MLS Python Services to Load the Runtime (2019-10-24) (October 24, 2019)
Databases in Azure… Where to begin? Create a Database and log in! (2019-10-23) (October 23, 2019)
Digging into Azure SQL Database Hyperscale Edition (2019-10-22) (October 22, 2019)
Modular ETL Architecture Design in SSIS (2019-10-21) (October 21, 2019)
Protecting Data from the Inside, with Database Weekly (10/19/2019) (October 19, 2019)
Automate MSBI deployments Using PowerShell (2019-10-18) (October 18, 2019)
Using Graph Theory To Group Records (2019-10-17) (October 17, 2019)
Exploring Facts About SQL Server Tables (2019-10-16) (October 16, 2019)
Using a Surrogate vs Natural Key (2019-10-15) (October 15, 2019)
A User-Defined Function returns more rows (2019-10-14) (October 14, 2019)
Where SQL Server monitoring fits into your tech stack (2019-10-12) (October 12, 2019)
Moving beyond principal components analysis (2019-10-11) (October 11, 2019)
The Basics of INCLUDE (2019-10-10) (October 10, 2019)
Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives (2019-10-9) (October 9, 2019)
A Spectacular Case of 100% CPU Caused by Online Reindexing (2019-10-08) (October 8, 2019)
6 steps to a more secure SQL database (2019-10-07) (October 7, 2019)
Which Service in Azure Should You Use for SQL? (DBW 2019-10-05) (October 5, 2019)
Real-time moving averages for IoT with R (2019-10-04) (October 4, 2019)
Getting a List of the Striped Backup Files (2019-10-03) (October 3, 2019)
Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn (2019-10-02) (October 2, 2019)
Adding a dynamic ColumnId to a DAX Calculated Table (2019-10-01) (October 1, 2019)
Transparent Data Encryption and Extensible Key Management – Better Together (2019-09-30) (September 30, 2019)
Job Start Whenever the CPUs Become Idle (September 28, 2019)
WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits (2019-09-27) (September 27, 2019)
Getting Started with SQL Server on Google Cloud Platform (2019-09-26) (September 26, 2019)
Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors (September 25, 2019)
Using tsqlt Tests to Practice Queries (2019-09-24) (September 24, 2019)
Best WordPress Security Practices for 2020 (2019-09-23) (September 23, 2019)
SQL Server Containers, Power BI Dashboards, Big Data and more in Database Weekly (09/21/19) (September 21, 2019)
Loading Data using R and PowerBI (2019-09-20) (September 20, 2019)
Soft Skills: Controlling your career (2019-09-19) (September 19, 2019)
Stairway to SQLCLR Level 2: Sample Stored Procedure and Function (2019-09-18) (September 18, 2019)
“Included columns” for non-clustered indexes explained (2019-09-17) (September 17, 2019)
Managing SQL Server containers using Docker SDK for Python - Part 2 (2019-09-16) (September 16, 2019)
Fantasy SQL Server (Database Weekly 2019-09-14) (September 14, 2019)
Azure DWH part 19: Backup and Restore SSAS (2019-09-13) (September 13, 2019)
Optimize Your SQL by Reformulating the Spec (2019-09-12) (September 12, 2019)
Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions (September 11, 2019)
SQL Server Integrates Hadoop and Spark out-of-the box: The Why? (2019-09-09) (September 9, 2019)
Azure SQL DB Serverless; dbatools book (Database Weekly 2019-09-07) (September 7, 2019)
Distributed Computing Principles and SQL-on-Hadoop Systems (2019-09-06) (September 6, 2019)
SQL Server 2016 Always Encrypted (2019-09-05) (September 5, 2019)
Provisioning ADS - Level 2 of the Stairway to Azure Data Factory (2019-09-04) (September 4, 2019)
How much will it cost or save to rebuild that index? (2019-09-03) (September 3, 2019)
The NoSQL misdirections (2019-09-02) (September 2, 2019)
Are My SQL Server Indexes Being Used? (DBW 2019-08-31) (August 31, 2019)
Loading partitioned table incrementally using SSIS (2019-08-30) (August 30, 2019)
Key Rotation in TDE (2019-08-29) (August 29, 2019)
Stairway to Database Source Control Level 1: Setting Up For Database Source Control (2019-08-28) (August 28, 2019)
A Self-Tuning Fill Factor Technique for SQL Server – Part 2 (2019-08-27) (August 27, 2019)
Azure Stretch Database, Part I: Getting Going (2019-08-26) (August 26, 2019)
TempDB Contention, Query Store Tuning and SQL Tamagotchi (Database Weekly 2019-08-24) (August 23, 2019)
Importing Files in Parallel with SSIS (2019-08-23) (August 23, 2019)
Let’s Start with Architecture (2019-08-22) (August 22, 2019)
Stairway to SQL Server Security Level 3: Principals and Securables (2019-08-21) (August 21, 2019)
A Self-Tuning Fill Factor Technique for SQL Server – Part 1 (2019-09-20) (August 20, 2019)
Memories of DR testing (2019-08-19) (August 19, 2019)
My personal impact of AI (2019-08-17) (August 17, 2019)
Vagrant and SQL Server 2017 on Linux (2019-08-16) (August 16, 2019)
How Often Do You Give Your Server a Physical? (2019-08-15) (August 15, 2019)
Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication (2019-08-14) (August 14, 2019)
Redgate Takes over the SQLCop Project (2019-08-13) (August 13, 2019)
Dynamic SQL for beginners in 33 minutes (2019-08-12) (August 12, 2019)
Improve your indexes, unblock your database builds in Database Weekly (August 10, 2019)
Track Sensitive Data with SQL Server Extended Properties (2019-08-09) (August 9, 2019)
Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie) (2019-08-08) (August 8, 2019)
Stairway to SQL Server Security Level 1: Overview of SQL Server Security (2019-08-07) (August 7, 2019)
SQL Agent in Level 5 of the Stairway of SQL Server on Linux (2019-08-06) (August 6, 2019)
Making Good Use of SQL Server Auditing (August 5, 2019)
Best Practices and Band Plans (Database Weekly 2019-08-03) (August 3, 2019)
Keeping tables online during loading with schema swapping using SSIS (2019-08-02) (August 2, 2019)
How to Unclog SQL Server (2019-08-01) (August 1, 2019)
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory (2019-07-31) (July 31, 2019)
Scaling SSRS Support for SQL Azure with Containers (2019-07-30) (July 30, 2019)
Querying Temporal Tables (2019-07-29) (July 29, 2019)
Shortest Path with T-SQL Graph; FILTER() Function and more in Database Weekly (July 27, 2019) (July 27, 2019)
SQL-On-Hadoop: Hive - Part II (2019-07-26) (July 26, 2019)
Cross Database Queries in Azure SQL Database (2019-07-25) (July 25, 2019)
Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2019-07-24) (July 24, 2019)
Azure Elastic jobs (2019-07-23) (July 23, 2019)
Scaling SSRS Support for SQL Azure with Containers (2019-07-22) (July 22, 2019)
Microsoft Official Support End Dates for Different Versions (DBW 2019-07-20) (July 20, 2019)
SQL-On-Hadoop: Hive - Part I (2019-07-19) (July 19, 2019)
Building Custom Container Images by Hand (2019-07-18) (July 18, 2019)
Connecting - Level 4 of the Stairway to Azure SQL Database (2017-07-17) (July 17, 2019)
SQL and T-SQL for Beginners in 229 minutes (2019-07-16) (July 16, 2019)
Politics makes for bad databases - plus calculate British holidays (2019-07-15) (July 15, 2019)
Max Memory and MAXDOP configuration during install and more in Database Weekly (July 13, 2019) (July 13, 2019)
Create External and Internal tables As Select (2019-07-12) (July 12, 2019)
A DBA's Look at the Data Catalog (2019-07-11) (July 11, 2019)
Stairway to SSAS Tabular Level 7: Time Intelligence (2019-07-10) (July 10, 2019)
The Dangers When Changing Database File Names (2019-07-09) (July 9, 2019)
COLUMNS_UPDATED() and Triggers (2019-07-08) (July 8, 2019)
More Linux than Windows in Azure (2019-07-06) (July 6, 2019)
Some of my greatest mistakes (2019-07-05) (July 5, 2019)
Happy Fourth of July (2019-07-04) (July 4, 2019)
Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values (2019-07-03) (July 3, 2019)
A Step by Step Guide to the Availability Group (AG) Listener (2019-07-02) (July 2, 2019)
Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens (2019-07-01) (July 1, 2019)
Database Horror Stories, Query Store Best Practices and more in Database Weekly (June 29, 2019) (June 29, 2019)
Introduction to Statistics (2019-06-28) (June 28, 2019)
What’s the Difference Between PERCENT_RANK and CUME_DIST? (2019-06-27) (June 27, 2019)
Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions (2019-06-26) (June 26, 2019)
All flash vs adaptive flash storage (SSC 2019-06-25) (June 25, 2019)
Exporting Stored Procedure Results to a Table (2019-06-24) (June 24, 2019)
Microsoft, Think DevOps First (2019-06-22) (June 22, 2019)
Group Managed Service Accounts (gMSAs) in SQL2016 (2019-06-21) (June 21, 2019)
Using VMware VMDKs for SQL Server Database Cloning (2019-06-20) (June 20, 2019)
Building the Ideal VMware-based SQL Server Virtual Machine (2019-06-19) (June 19, 2019)
SQL Server Agent for SQL Express on Linux (2019-06-18) (June 18, 2019)
Watching Out for Deferred Name Resolution (SQLServerCentral 2019-06-17) (June 17, 2019)
INTERSECT and EXCEPT (Database Weekly 2019-06-15) (June 15, 2019)
SQL Server Performance Benchmarking with Patterns (SQLServerCentral 2019-06-14) (June 14, 2019)
Managing SQL Server containers using Docker SDK for Python (SQLServerCentral 2019-06-13) (June 13, 2019)
Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs (SQLServerCentral (2019-06-12) (June 12, 2019)
Slower is Faster (SQLServerCentral 2019-06-11) (June 11, 2019)
Managing Always Encrypted Locally Stored Certificates in PowerShell (SQLServerCentral 2019-06-10) (June 10, 2019)
SQL Server and Antivirus (Database Weekly 2019-06-08) (June 8, 2019)
Parse Data from a Field Containing Multiple Values using CROSS APPLY (SQLServerCentral 2019-06-07) (June 7, 2019)
A Brief History of Data Analysis (SQLServerCentral 2019-06-06) (June 6, 2019)
Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs (SQLServerCentral 2019-06-05) (June 5, 2019)
A Plunge Into TOP (SQLServerCentral 2019-06-04) (June 4, 2019)
Create and deploy Azure Resource Manager templates by using the Azure portal (SQLServerCentral 2019-06-03) (June 3, 2019)
Databases made for Ops, not 'Oops!' (Database Weekly, 2019-06-01) (June 1, 2019)
Create SSRS Data Driven Subscriptions on Standard Edition (SQLServerCentral 2019-05-31) (May 31, 2019)
Connect to Sybase with a Linked Server (SQLServerCentral 2019-05-30) (May 30, 2019)
Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2 (SQLServerCentral 2019-05-29) (May 29, 2019)
Ordering T-SQL Scripts with Git and PowerShell (SQLServerCentral 2019-05-28) (May 28, 2019)
Understanding Machine Learning (SQLServerCentral 2019-05-27) (May 27, 2019)
SQL Server 2019 CTP 3.0 (Database Weekly 2019-05-25) (May 25, 2019)
Exporting Custom Messages from Sys.Messages (SQLServerCentral 2019-05-24) (May 24, 2019)
Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy (SQLServerCentral 2019-05-23) (May 23, 2019)
Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1 (SQLServerCentral 2019-05-22) (May 22, 2019)
DBA Walkthrough – Adding space on IBM AIX Power Machines (SQLServerCentral 2019-05-21) (May 21, 2019)
Creating Aliases for Docker Commands in Linux (SQLServerCentral 2019-05-20) (May 20, 2019)
BIML shortcuts;DMVs for beginners (Database Weekly 2019-05-18) (May 18, 2019)
DBAs and the ITIL Framework, Part II: Asset Management (SQLServerCentral 2019-05-17) (May 17, 2019)
A Self-Serve System to Refresh Databases (Part 3) (SQLServerCentral 2019-05-16) (May 16, 2019)
Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups (SQLServerCentral 2019-05-15) (May 15, 2019)
Using Azure Data Studio with Git (SQLServerCentral 2019-05-14) (May 14, 2019)
The Basics - Level 1 of the Stairway to Query Store (SQLServerCentral 2019-05-13) (May 13, 2019)
Database Weekly 2019-05-11 (May 12, 2019)
Database Cloning Tools in Lower Environments (SQLServerCentral 2019-05-10) (May 10, 2019)
A Self-Serve System that Allows Developers to Refresh Databases (Part 2) (SQLServerCentral 2019-05-09) (May 9, 2019)
Beyond The Basics Level 3: Building a Correlated Subquery - Stairway to T-SQL (SQLServerCentral 2019-05-08) (May 8, 2019)
Using Azure Data Studio with TFVC (SQLServerCentral 2019-05-07) (May 7, 2019)
Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services (SQLServerCentral 2019-05-06) (May 6, 2019)
What is Data Maturity?, Data Breaches: All Your Fault, and The Blast Radius of a Database (Database Weekly 2019/05/04) (May 4, 2019)
The Difference Between Rollup and Cube (SQLServerCentral 2019-05-03) (May 3, 2019)
A Self-Serve System to Refresh Databases – Part 1 (SQLServerCentral 2019-05-02) (May 2, 2019)
Stairway to SSAS Tabular Level 6: Creating Meaningful Measures (SQLServerCentral 2019-05-01) (May 1, 2019)
Build an OLAP Cube in SSAS using an ADO.NET Data Provider (SQLServerCentral 2019-04-30) (April 30, 2019)
Dos and Don’ts of Dynamic SQL (SQLServerCentral 2019-04-29) (April 29, 2019)
SQL Server 2019 CTP 2.5 Is Out! (Database Weekly 2019-04-27) (April 27, 2019)
Hidden Formatting Troubles with STR() (SQL Spackle) (SQLServerCentral - 2019-04-26) (April 26, 2019)
Using Backup Encryption with an External Certificate (SQLServerCentral 2019-04-25) (April 25, 2019)
Stairway to SQL Server Security Level 5: Schemas and Security (SQLServerCentral 2019-04-24) (April 24, 2019)
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS (SQLServerCentral 2019-04-23) (April 23, 2019)
Service Broker Part 2: Why Service Broker (SQLServerCentral 2019-04-22) (April 22, 2019)
Implicit Conversions; Single Sign-On in Azure (Database Weekly 2019-04-20) (April 20, 2019)
Group Islands of Contiguous Dates (SQL Spackle) (SQLServerCentral 2019-04-19) (April 19, 2019)
A Quick Start to Running Python Code in SQL Server (SQLServerCentral 2019-04-18) (April 18, 2019)
Stairway to AlwaysOn Level 6: Analyse and Deploy an AlwaysOn Availability Group (SQLServerCentral 2019-04-17) (April 17, 2019)
Create Table DDL via TSQL (SQLServerCentral 2019-04-16) (April 16, 2019)
The Canine Corgi Completion Contest (SQLServerCentral 2019-04-15) (April 15, 2019)
How to Fix Databases with High VLF Count (Database Weekly 2019-04-13) (April 13, 2019)
Sorting Months By Number (SQLServerCentral 2019-04-12) (April 12, 2019)
Using Notebooks in Azure Data Studio (SQLServerCentral 2019-04-11) (April 11, 2019)
Turning Data On Its Side Using PIVOT Operator (SQLServerCentral 2019-04-10) (April 10, 2019)
More On Column Order Indexes – Part 2 (SQLServerCentral 2019-04-09) (April 9, 2019)
A tour of the Execute Package Task (SQLserverCentral 2019-04-08) (April 8, 2019)
Musings of a DevOps Data Pro, SQL for Cosmos DB, and Why should SQL Server 2019 excite developers? (Database Weekly 4/6/2019) (April 6, 2019)
Calculating Elapsed Times (SQLServerCentral 2019-04-05) (April 5, 2019)
Creating a comma-separated list (SQLServerCentral 2019-04-04) (April 4, 2019)
Stairway to Database Design Level 6: Procedure Bodies (SQLServerCentral 3 Apr 2019) (April 3, 2019)
Reaping the benefits of the Window functions in T-SQL (SQLServerCentral 04/02/2019) (April 2, 2019)
SQL Server 2019 Adds CosmosDB Support (SQLServerCentral 04/01/2019) (April 1, 2019)
Containers Are The Present, Not the Future, Get Back to Basics, and a Brief History of Machine Learning (Database Weekly 3/30/2019) (March 30, 2019)

SSC Newsletters

Subscribe to the daily newsletter to get fresh SQL Server articles, scripts and info every day, and Database Weekly for a roundup of all the big stories in the SQL Server world.

Email

SSC Daily Newsletter

Database Weekly

CPU

Memory

Disk I/O

Waits

Take a peek into our servers

About SQLServerCentral
Contact Us
Terms of Use
Privacy Policy
Contribute
Contributors
Authors
Newsletters