Newsletter Archive

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
Terms of Use
Privacy Policy
Contribute
Contributors
Authors
Newsletters