Newsletter Archive

Efficiently Polling Remote Data Sources (2020-10-30) (October 30, 2020)
Setting Rows to Odd and Even Values (2020-10-29) (October 29, 2020)
Stairway to SSAS Tabular Level 11: Partitioning (2020-10-28) (October 28, 2020)
Recovering Databases From a Master Backup (2020-10-27) (October 27, 2020)
Better SQL Server Agent Job Failure Monitoring (2020-10-26) (October 26, 2020)
Azure DevOps, Power BI, and more in Database Weekly (2020-10-24) (October 24, 2020)
Using pw-inspector in Brute Force attack on SQL Server (2020-10-23) (October 23, 2020)
Make SQL Server Agent Jobs HADR Aware (2020-10-22) (October 22, 2020)
Stairway to Advanced T-SQL Level 10: Using Scalar Functions (2020-10-21) (October 21, 2020)
Great Power(Shell)...Great Responsibility (2020-10-20) (October 20, 2020)
Connecting to SQL Server with MuleSoft AnyPoint 3.9 (2020-10-19) (October 19, 2020)
TempDB Bottlenecks, Expensive CTEs and other Reasons your Query is Slow Right Now (Database Weekly, 10/17/2020) (October 16, 2020)
Count the Number of Weekend Days between Two Dates (2020-10-16) (October 16, 2020)
Getting Started with Gremlin (2020-10-15) (October 15, 2020)
Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function (2020-10-14) (October 14, 2020)
Incremental Data loading through ADF using Change Tracking (2020-10-13) (October 13, 2020)
Random Thoughts (2020-10-12) (October 12, 2020)
ALTER Procedures When Using Query Store (DBW 2020-10-10) (October 10, 2020)
Create AT&T Network Hierarchy Diagrams using SQL Server Data (2020-10-09) (October 9, 2020)
PowerShell Day by Day: Filtering Objects (2020-10-08) (October 8, 2020)
The Basics - Level 1 of the Stairway to Query Store (2020-10-07) (October 7, 2020)
Experimenting with PostgreSQL in a Container (2020-10-06) (October 6, 2020)
Application down after SQL Service logon account change (2020-10-05) (October 5, 2020)
Azure SQL Database, SQL Server in Containers, and more in Database Weekly (2020-10-03) (October 3, 2020)
TRIM() in T-SQL (2020-10-02) (October 2, 2020)
Configure Replication Between an On-premises SQL Server and AWS RDS (2020-10-01) (October 1, 2020)
Editor Tips and Tricks for Azure Data Studio (2020-09-30) (September 30, 2020)
When one of your DBA colleagues leaves the company, what is your checklist? (2020-09-29) (September 29, 2020)
A Getting Started PostgreSQL Tutorial (2020-09-28) (September 28, 2020)
SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases. (DBW 2020-09-26) (September 26, 2020)
Creating Subtotals and Totals in Aggregated Queries (2020-09-25) (September 25, 2020)
Incremental Data Loading using Azure Data Factory (2020-09-24) (September 24, 2020)
Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function (2020-09-23) (September 23, 2020)
Dear Past Me on My First Day as a DBA (2020-09-22) (September 22, 2020)
Availability Groups with Docker Containers (2020-09-21) (September 21, 2020)
Join the SQL Merry-Go-Round with Database Weekly (09/19/2020) (September 19, 2020)
SQL Server on Amazon RDS vs SQL Server on Amazon EC2 (2020-09-18) (September 18, 2020)
Conditional Formatting with SSRS (2020-09-17) (September 17, 2020)
Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework (2020-09-16) (September 16, 2020)
Indexes: When Column Selectivity Is Not Always A Requirement (2020-09-15) (September 15, 2020)
SQL Server 2017 Installation Error with KB2919355 (2020-09-14) (September 14, 2020)
Why Your Query Can’t Go Parallel, Table Variables Edition (2020-09-12 DBW) (September 12, 2020)
When SQL Server Performance Goes Bad: Implicit Conversions (2020-09-11) (September 11, 2020)
SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos (2020-09-10) (September 10, 2020)
Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-09-09) (September 9, 2020)
Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication (2020-08-08) (September 8, 2020)
Downloading a CSV File from an API Using Azure Data Factory (2020-09-07) - Happy Labor Day (September 7, 2020)
Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05) (September 5, 2020)
Configuring SQL Server Always on Azure Servers(Iaas) (2020-08-04) (September 4, 2020)
Installing PostgreSQL 11 on Windows with Step-by-step instructions (2020-09-03) (September 3, 2020)
Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function (2020-09-02) (September 2, 2020)
Using Recommendations for MAXDOP and Max Memory During Installation (2020-09-01) (September 1, 2020)
Database Modeling - Relationships (2020-08-31) (August 31, 2020)
Learning Isn’t Easy, But It’s Vital (2020-08-29) (August 29, 2020)
Database Snapshot Use Case: Service Migration (2020-08-28) (August 28, 2020)
Basic Git for DBAs: Managing PowerShell Scripts (2020-08-27) (August 27, 2020)
Removing TDE from a Database: Level 4 of the Stairway to TDE (2020-08-26) (August 26, 2020)
Configuring Availability Groups in Ubuntu (2020-08-25) (August 25, 2020)
An Introduction to Azure Synapse Analytics Workspace (2020-08-24) (August 24, 2020)
Starting SQL, Sizing Up Columns, Singing Hedgehog Songs, in Database Weekly (08/22/20) (August 22, 2020)
Native SQL Backups for Amazon RDS Databases (2020-08-21) (August 21, 2020)
Calling Procs from PowerShell with Parameters (2020-08-20) (August 20, 2020)
Permissions and Security in Dynamic Data Masking (2020-08-19) (August 19, 2020)
Recover database encrypted modules code with dbatools (2020-08-18) (August 18, 2020)
How to override Date Filters in Power BI (2020-08-17) (August 17, 2020)
Why a 60GB Database Backup Grew to 1TB in Size (DBW 2020-08-15) (August 15, 2020)
TOP vs Max/Min: Is there a difference? (2020-08-14) (August 14, 2020)
The Basics of PowerShell Day By Day (2020-08-13) (August 13, 2020)
Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics (2020-08-12) (August 12, 2020)
Azure Data Factory : Your First Data Pipeline (2020-08-11) (August 11, 2020)
Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware (2020-08-10) (August 10, 2020)
Online certification exams, Historical dimensions, and more in Database Weekly (2020-08-08) (August 8, 2020)
Visualise SQL Server IO Stats (2020-08-07) (August 7, 2020)
Basic Git for DBAs: What's a Pull Request? (2020-08-06) (August 6, 2020)
Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3 (2020-08-05) (August 5, 2020)
Calling a Stored Procedure from PowerShell (2020-08-04) (August 4, 2020)
Change the Instance Collation by Rebuilding Databases in SQL Server 2017 (2020-08-03) (August 3, 2020)
Tracking use of Deprecated SQL Server Features (DBW 2020-08-01) (August 1, 2020)
Removing Extended Properties (2020-07-31) (July 31, 2020)
Honorifics in the 21st century (2020-07-30) (July 30, 2020)
Stairway to Biml Level 6 - Programming with Metadata (2020-07-29) (July 29, 2020)
Access external data from Azure Synapse Analytics using Polybase (2020-07-28) (July 28, 2020)
SQL Server 2012 does not come up after service pack upgrade SP4 (2020-07-27) (July 27, 2020)
The Ultimate Home Office (DBW 2020-07-25) (July 25, 2020)
Primary keys for an OLTP database (2020-07-24) (July 24, 2020)
Basic Git for DBAs: Merging Code Between Branches (2020-07-23) (July 23, 2020)
Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016 (2020-07-22) (July 22, 2020)
TDE BYOK and Geo-Replication in Azure SQL DB (2020-07-21) (July 21, 2020)
Loading data in Azure Synapse Analytics using Azure Data Factory (2020-07-20) (July 20, 2020)
Everything I Never Wanted to Know About Collation (DBW 2020-07-18) (July 18, 2020)
Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory) (2020-07-17) (July 17, 2020)
Unable to connect SSIS remotely (2020-07-16) (July 16, 2020)
An Introduction: Level 1 of the Stairway to Row-Level Security (2020-07-15) (July 15, 2020)
Basic Git for DBAs: Making Changes in GitHub (2020-07-14) (July 14, 2020)
Loading data in Azure Synapse using Copy (2020-07-13) (July 13, 2020)
NULLs, GitFlow, MAXDOP and more in Database Weekly (2020-07-11) (July 11, 2020)
The Basics of iTVFs (2020-07-10) (July 10, 2020)
Implementing Restart Ability For Shell Scripts (2020-07-09) (July 9, 2020)
Stairway to Data, Level 4: Temporal Data (2020-07-08) (July 8, 2020)
Business Reasons For Implementing Power BI (2020-07-07) (July 7, 2020)
Availability Groups with Docker Containers (2020-07-06) (July 6, 2020)
The Pros and Cons of Virtual Conferences: Just My Opinions (DBW 2020-07-04) (July 4, 2020)
Implementing Stretch Database (2020-07-03) (July 3, 2020)
How Bad are Bad Page Splits – The Rest of the Story (2020-07-02) (July 2, 2020)
Stairway to U-SQL Level 22: Creating a Custom Extractor (2020-07-01) (July 1, 2020)
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules (2020-06-30) (June 30, 2020)
Creating a Serverless Database in Azure (2020-06-29) (June 29, 2020)
SQL: the Traditional Way, the Quick Way and the "Wait, What? Why?!" Way, in Database Weekly (06/27/2020) (June 27, 2020)
Getting started with SQL 2019 Big Data Clusters in Azure (2020-06-26) (June 26, 2020)
Logshipping to SQL Server on Linux (2020-06-25) (June 25, 2020)
Stairway level 3 : Configure Extensible Key Management Using Azure Key Vault (2020-06-24) (June 24, 2020)
SSIS Variable and Parameter Analysis (2020-06-23) (June 23, 2020)
DAX for SQL Folks: Part III - DAX Calculations (2020-06-22) (June 22, 2020)
Azure SQL Database Migrating across Tiers (2020-06-20) (June 20, 2020)
Creating and using inline table-valued functions (2020-06-19) (June 19, 2020)
Provisioning Azure SQL Database with Failover groups using Terraform (2020-06-18) (June 18, 2020)
Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions (2020-06-17) (June 17, 2020)
Basic Git for DBAs: the Basics of Branches (2020-06-16) (June 16, 2020)
Banker’s Rounding. What is it good for? (2020-06-15) (June 15, 2020)
Suspect databases, Heaps, and more in Database Weekly (2020-06-13) (June 13, 2020)
Migrating SQL Server Reporting Services (2020-06-12) (June 12, 2020)
Lock Scenarios Using sys.dm_tran_locks (2020-06-11) (June 11, 2020)
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table (2020-06-10) (June 10, 2020)
Basic Git for DBAs: Sharing Files Through GitHub (2020-06-09) (June 9, 2020)
Basic Git for DBAs: Getting Started with Git (2020-06-08) (June 8, 2020)
The Social Impact of Data (DBW 2020-06-06) (June 6, 2020)
3 Things I Wish I Knew When I Started Using Entity Framework (2020-06-05) (June 5, 2020)
How to Download Stocks on Schedule Using R (2020-06-04) (June 4, 2020)
What is the Machine Learning Server? Level 2 of the Stairway to ML Services (2020-06-03) (June 3, 2020)
Microsoft SQL Server Utilities and Tools (2020-06-02) (June 2, 2020)
Installing SQL Server 2019 using the Azure Cloud Shell (2020-06-01) (June 1, 2020)
Troublesome parameter sniffing, misleading execution plans and more in Database Weekly, 05/30/20 (May 30, 2020)
Azure DWH part 19: Backup and Restore SSAS (2020-05-29) (May 29, 2020)
The Basics of Using a Sequence as a Table Default (2020-05-28) (May 28, 2020)
Monitoring - Level 6 of the Stairway to SQL Server on Linux (2020-05-27) (May 27, 2020)
Adding a Database with Polybase External Tables to Always On Availability Group (2020-05-26) (May 26, 2020)
How to Move System Databases to a New Physical Directory (2020-05-25) (May 25, 2020)
The Build Book of News (DBW 2020-05-23) (May 23, 2020)
Azure DWH part 18: Working with SQL Server Analysis Services (2020-05-22) (May 22, 2020)
The IDENTITY Column Property (2020-05-21) (May 21, 2020)
Stairway Level 2 : Restore a Backup of a TDE Database to Another Server (2020-05-20) (May 20, 2020)
The Products-Often-Purchased-Together Problem Solved in R (2020-05-19) (May 19, 2020)
Creating a Azure Cosmos DB Account (2020-05-18) (May 18, 2020)
Troubleshooting tempdb, Power BI Visuals and more in Database Weekly (2020-05-16) (May 16, 2020)
Bones of SQL - Practical Calendar Queries (2020-05-15) (May 15, 2020)
A Solution for the Bin Packing Problem (2020-05-14) (May 14, 2020)
Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-05-13) (May 13, 2020)
Concurrency Control in SQL Server (2020-05-12) (May 12, 2020)
Postgresql JDBC Tutorial on Linux (2020-05-11) (May 11, 2020)
Capturing DBCC CHECKDB Output (DBW 2020-05-09) (May 9, 2020)
Changing the Path for the Master Database (2020-05-08) (May 8, 2020)
Dynamic SQL Going Haywire (2020-04-07) (May 7, 2020)
Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2020-05-06) (May 6, 2020)
How to Resolve a Duplicate Key Error in SSAS (2020-05-05) (May 5, 2020)
Configuring Database Alerts for Azure SQL Database (2020-05-04) (May 4, 2020)
Troubleshoot Performance in Azure SQL Database, Build Power BI Reports, Tune Queries and more in Database Weekly (05/02/20) (May 2, 2020)
Export SQL Server Tables to Excel (2020-05-01) (May 1, 2020)
DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries (2020-04-30) (April 30, 2020)
Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE (2020-04-29) (April 29, 2020)
Your First Pipeline with Azure Data Factory (2020-04-28) (April 28, 2020)
A Pattern Based Approach to Masking Errors (2020-04-27) (April 27, 2020)
Vulnerability Finding Using Machine Learning (2020-04-25 DBW) (April 25, 2020)
Representing XML data in SQL Server (2020-04-24) (April 24, 2020)
A Set-based Solution for the Bin Packing Problem (2020-04-23) (April 23, 2020)
Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function (2020-04-22) (April 22, 2020)
Create Custom Functions in Power Query (2020-04-21) (April 21, 2020)
A Data Science Approach in Product Analytics (2020-04-20) (April 20, 2020)
Registered servers, moving database files and more (Database Weekly 2020-04-18) (April 18, 2020)
SQL Server Rounding Tips and Tricks (2020-04-17) (April 17, 2020)
Helpful Unix Commands/Debugging made easy (2020-04-16) (April 16, 2020)
Idempotent DDL Scripts That Always Achieve The Same Result (2020-04-15) (April 15, 2020)
How To Avoid MERGE in SQL Server (2020-04-14) (April 14, 2020)
Perform Data Filtering in Oracle Link to SQL Server (2020-04-13) (April 13, 2020)
SQL Server In Place Upgrades: Too Expensive? (DBW 2020-04-11) (April 11, 2020)
Why QUOTENAME is important (2020-04-10) (April 10, 2020)
Implementing Reporting Application Enhancements with No Downtime (2020-04-09) (April 9, 2020)
Stairway to U-SQL Level 16: The Azure Data Lake Catalog (2020-04-08) (April 8, 2020)
Iterating Over Calculated Tables using Power Query (2020-04-07) (April 7, 2020)
Automate your Morning Checklist (2020-04-06) (April 6, 2020)
Aggregate Data for the Last Day of the Month (2020-04-03) (April 3, 2020)
Check Your Backup Compliance Against a Data Management Provider (2020-04-02) (April 2, 2020)
SQL v.Next Gets Native Python in SQL Server (2020-04-01) (April 1, 2020)
Graphical analysis of SSRS report usage with Grafana (2020-03-31) (March 31, 2020)
Collections: Computed gaps for continuous numbers ( 2020-03-30) (March 30, 2020)
Now Is a Good Time for Choices (DBW 2020-03-28) (March 28, 2020)
Analyzing Formula 1 results in R (2020-03-27) (March 27, 2020)
DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz (2020-03-26) (March 26, 2020)
Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions (2020-03-25) (March 25, 2020)
Creating SQL containers on Azure Data Studio Notebooks with Python (2020-03-24) (March 24, 2020)
Collections: Crossing intervals computed gaps (2020-03-23) (2020-03-23) (March 23, 2020)
Working from home, containers, and more (Database Weekly 2020-03-21) (March 21, 2020)
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2 (2020-03-20) (March 20, 2020)
Restore SQL Server database using data management provider REST API (2020-03-19) (March 19, 2020)
SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7 (2020-03-18) (March 18, 2020)
Fetch Web Data in Power BI (2020-03-17) (March 17, 2020)
Combining many crossing intervals (2020-03-16) (March 16, 2020)
Window Shopping the Query Store with XEvents (DBW 2020-03-14) (March 14, 2020)
Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1 (2020-03-13) (March 13, 2020)
Using the RANKX function in Power BI (2020-03-12) (March 12, 2020)
Stairway to SSAS Tabular Level 9: Security and Roles (2020-03-11) (March 11, 2020)
Gap Analysis Using Algebra (2020-03-10) (March 10, 2020)
Implementing Drill Through Actions in SSAS (2020-03-09) (March 9, 2020)
Displaying Hierarchical Data (2020-03-06) (March 6, 2020)
Implementing Date Calculations in SQL (2020-03-05) (March 5, 2020)
Stairway to U-SQL Level 9: Views and C# Expressions (2020-03-04) (March 4, 2020)
How Bad are Bad Page Splits? (2020-03-03) (March 3, 2020)
Introduction to STRING_SPLIT function in SQL (2020-03-02) (March 2, 2020)
Automatic Redaction of PII (DBW 2020-02-28) (February 29, 2020)
Mean Median Mode using SQL and DAX (2020-02-28) (February 28, 2020)
Exploring the DATE Functions in SQL (2020-02-27) (February 27, 2020)
Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes (2020-02-26) (February 26, 2020)
UDTs, ORMs and Slow Garbage Collection in Database Weekly (02/25/20) (February 25, 2020)
Introduction to Indexed Views in SQL Server (2020-02-25) (February 25, 2020)
Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services (2020-02-24) (February 24, 2020)
Azure Data Factory Triggers (2020-02-21) (February 21, 2020)
DBA Team Mashup (2020-02-20) (February 20, 2020)
Stairway to SQL Server Agent: Level 1: Setup and Overview (2020-02-19) (February 19, 2020)
Database Normalization in SQL with Examples (2020-02-18) (February 18, 2020)
Handling Aggregations on a Poorly Designed Database (2020-02-17) (February 17, 2020)
Power BI Tips, Faster Scalar UDFs, and more in Database Weekly (2020-02-15) (February 15, 2020)
A quick search without an index (2020-02-14) (February 14, 2020)
Collections (2020-02-13) (February 13, 2020)
Installing Machine Learning Services – Level 1 of the Stairway to ML Services (2020-02-12) (February 12, 2020)
Shell Scripting Standards (2020-02-11) (February 11, 2020)
New: 2020 State of Database DevOps report (2020-02-10) (February 10, 2020)
Some Query Tuning, Technology Failures in Iowa, DevOps (February 8, 2020)
Incremental Package Deployment – A SSIS 2016 Feature (2020-02-07) (February 7, 2020)
Introduction to PIVOT operator in SQL (2020-02-06) (February 6, 2020)
Stairway to SSAS Tabular Level 2: Installing the Components (2020-02-05) (February 5, 2020)
Calculate Moving Averages using T-SQL in SQL Server (2020-02-04) (February 4, 2020)
Analysis Services : OLEDB Error while processing in SSAS (2020-02-03) (February 3, 2020)
Signs Your Execution Plan is Lying to You and more in Database Weekly (02/01/2020) (February 1, 2020)
The Connection to the Primary Replica is not Active (2020-01-31) (January 31, 2020)
Export/Import Data using BCP - SQL Server on Linux (2020-01-30) (January 30, 2020)
Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database (2020-01-29) (January 29, 2020)
Do Not Set Trustworthy On for the SSISDB Catalog (2020-01-28) (January 28, 2020)
Month-over-Month calculation using DAX in Power BI (2020-01-27) (January 27, 2020)
Where you should tune your queries, and how in Database Weekly (01/25/2020) (January 25, 2020)
Should I Type * or 1 With the EXISTS Logical Operator (2020-01-24) (January 24, 2020)
Stable Marriages Using SQL Server (2020-01-23) (January 23, 2020)
Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-01-22) (January 22, 2020)
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2 (2020-01-21) (January 21, 2020)
SSAS Error: Duplicate attribute key found when processing (2020-01-20) (January 20, 2020)
Reducing Imposter Syndrome and Unclogging SQL Server in Database Weekly (01/18/2020) (January 18, 2020)
SSRS Audit: All reports executed/not-executed during previous 30 days (2020-01-17) (January 17, 2020)
How to remove quote marks using SSIS and a little C# (2020-01-16) (January 16, 2020)
Provisioning ADF - Level 2 of the Stairway to Azure Data Factory (2020-01-15) (January 15, 2020)
Re-oiling the gears for the data dictionary or catalog (2020-01-14) (January 14, 2020)
Dynamically process SSAS Cube from SSIS package (2020-01-13) (January 13, 2020)
Execution Plans, Memory Optimized Tables, and more (Database Weekly 2020-01-01) (January 11, 2020)
Obsoleting Unused SSRS Reports (2020-01-10) (January 10, 2020)
Use Polybase to consume Oracle data from SQL Server on Linux 2019 (2020-01-09) (January 9, 2020)
Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster (2020-01-08) (January 8, 2020)
A tale of updating a legacy system bug (2020-01-07) (January 7, 2020)
Setting up Management Studio for remote SQL Server (2020-01-06) (January 6, 2020)
Predictions 2020: What's Going to Happen in Cloud Computing (2020-01-04) (January 4, 2020)
SQL Server Unit Testing in Visual Studio (2020-01-03) (January 3, 2020)
Exporting Data with PowerShell (2020-01-02) (January 2, 2020)
SSIS Catalog Environments– Step 20 of the Stairway to Integration Services (2020-01-01) (January 1, 2020)
Browsing SSAS Instance over the internet (2019-12-31) (December 31, 2019)
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1 (2019-12-30) (December 30, 2019)
SSIS Formatting, Parameter Sniffing and Data Virtualization in Database Weekly (2019-12-28) (December 28, 2019)
OUTPUT Clause Basics (For Inserts and Deletes) (2019-12-27) (December 27, 2019)
SSISDB Catalog Defaults Best Practices (2019-12-26) (December 26, 2019)
Merry Christmas 2019 (2019-12-25) (December 25, 2019)
Curious Case of SUM Function (2019-12-24) (December 24, 2019)
Querying database schema using graph tables (2019-12-23) (December 23, 2019)
Database Reliability Engineering (DBW 2019-12-21) (December 21, 2019)
Performance Tuning Using Extended Events: Part 3 (2019-12-20) (December 20, 2019)
Finding Non Current Cumulative Updates (2019-12-19) (December 19, 2019)
Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes (2019-12-18) (December 18, 2019)
Monitor Current Analysis Services Activity (2019-12-17) (December 17, 2019)
SQL Server performance issue after an upgrade (2019-12-16) (December 16, 2019)
BI Dashboards, Slow Index Rebuilds and Bitter Complaints in Database Weekly (12/14/19) (December 14, 2019)
Performance Tuning Using Extended Events: Part 2 (2019-12-13) (December 13, 2019)
Querying Master Database DMVs in Azure SQL Database (2019-12-12) (December 12, 2019)
Security Across Databases with Cross-Database Ownership Chaining (2019-12-11) (December 11, 2019)
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