Newsletter Archive

Creating Aliases for Docker Commands in Linux (SQLServerCentral 2019-05-20)
BIML shortcuts;DMVs for beginners (Database Weekly 2019-05-18)
DBAs and the ITIL Framework, Part II: Asset Management (SQLServerCentral 2019-05-17)
A Self-Serve System to Refresh Databases (Part 3) (SQLServerCentral 2019-05-16)
Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups (SQLServerCentral 2019-05-15)
Using Azure Data Studio with Git (SQLServerCentral 2019-05-14)
The Basics - Level 1 of the Stairway to Query Store (SQLServerCentral 2019-05-13)
Database Weekly 2019-05-11
Database Cloning Tools in Lower Environments (SQLServerCentral 2019-05-10)
A Self-Serve System that Allows Developers to Refresh Databases (Part 2) (SQLServerCentral 2019-05-09)
Beyond The Basics Level 3: Building a Correlated Subquery - Stairway to T-SQL (SQLServerCentral 2019-05-08)
Using Azure Data Studio with TFVC (SQLServerCentral 2019-05-07)
Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services (SQLServerCentral 2019-05-06)
What is Data Maturity?, Data Breaches: All Your Fault, and The Blast Radius of a Database (Database Weekly 2019/05/04)
The Difference Between Rollup and Cube (SQLServerCentral 2019-05-03)
A Self-Serve System to Refresh Databases – Part 1 (SQLServerCentral 2019-05-02)
Stairway to SSAS Tabular Level 6: Creating Meaningful Measures (SQLServerCentral 2019-05-01)
Build an OLAP Cube in SSAS using an ADO.NET Data Provider (SQLServerCentral 2019-04-30)
Dos and Don’ts of Dynamic SQL (SQLServerCentral 2019-04-29)
SQL Server 2019 CTP 2.5 Is Out! (Database Weekly 2019-04-27)
Hidden Formatting Troubles with STR() (SQL Spackle) (SQLServerCentral - 2019-04-26)
Using Backup Encryption with an External Certificate (SQLServerCentral 2019-04-25)
Stairway to SQL Server Security Level 5: Schemas and Security (SQLServerCentral 2019-04-24)
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS (SQLServerCentral 2019-04-23)
Service Broker Part 2: Why Service Broker (SQLServerCentral 2019-04-22)
Implicit Conversions; Single Sign-On in Azure (Database Weekly 2019-04-20)
Group Islands of Contiguous Dates (SQL Spackle) (SQLServerCentral 2019-04-19)
A Quick Start to Running Python Code in SQL Server (SQLServerCentral 2019-04-18)
Stairway to AlwaysOn Level 6: Analyse and Deploy an AlwaysOn Availability Group (SQLServerCentral 2019-04-17)
Create Table DDL via TSQL (SQLServerCentral 2019-04-16)
The Canine Corgi Completion Contest (SQLServerCentral 2019-04-15)
How to Fix Databases with High VLF Count (Database Weekly 2019-04-13)
Sorting Months By Number (SQLServerCentral 2019-04-12)
Using Notebooks in Azure Data Studio (SQLServerCentral 2019-04-11)
Turning Data On Its Side Using PIVOT Operator (SQLServerCentral 2019-04-10)
More On Column Order Indexes – Part 2 (SQLServerCentral 2019-04-09)
A tour of the Execute Package Task (SQLserverCentral 2019-04-08)
Musings of a DevOps Data Pro, SQL for Cosmos DB, and Why should SQL Server 2019 excite developers? (Database Weekly 4/6/2019)
Calculating Elapsed Times (SQLServerCentral 2019-04-05)
Creating a comma-separated list (SQLServerCentral 2019-04-04)
Stairway to Database Design Level 6: Procedure Bodies (SQLServerCentral 3 Apr 2019)
Reaping the benefits of the Window functions in T-SQL (SQLServerCentral 04/02/2019)
SQL Server 2019 Adds CosmosDB Support (SQLServerCentral 04/01/2019)
Containers Are The Present, Not the Future, Get Back to Basics, and a Brief History of Machine Learning (Database Weekly 3/30/2019)