Newsletter Archive

December 4, 2021 - Holiday Fun with the Advent of Code (2021-12-04 DBW)
December 3, 2021 - SQL Server Data Masking: a comparison with Gallium Data (2021-12-3)
December 1, 2021 - Stairway to Snowflake Level 3 – Configure Snowflake with Your Cloud Account (2021-12-01)
November 29, 2021 - Creating Markdown Formatted Text for Results from T-SQL (2021-11-29)
November 27, 2021 - Security Heading Into The Holidays
November 26, 2021 - How to filter non-existing records in SQL (2021-11-26)
November 24, 2021 - Stairway to SQL Server Extended Events Level 2: Creating Basic Event Sessions in the UI (2021-11-24)
November 22, 2021 - Working with an Azure Data Factory Meta-data Driven Pipeline (2021-11-22)
November 20, 2021 - Backups, DAX, and more in Database Weekly (2021-11-20)
November 19, 2021 - SQLFacts - A Free Toolkit for SQL Server Database Engineers (2021-11-19)
November 17, 2021 - Azure Data Factory Pipeline Variables (2021-11-17)
November 15, 2021 - SQL Server Row-Level Security: A Comparison with Gallium Data (2021-11-15)
November 13, 2021 - “Serverless” Lessons Learned (2021-11-13 DBW)
November 12, 2021 - A brief history of SSIS evolution (2021-11-12)
November 10, 2021 - A Summit Rebirth in 2022 - Who is the winner? (2021-11-10)
November 8, 2021 - An Introduction to Azure Databricks (2021-11-08)
November 6, 2021 - Next Release of SQL Server Announced
November 5, 2021 - How to Recover a Corrupted Azure Data Factory Integration Runtime (2021-11-05)
November 3, 2021 - Azure Cosmos DB – HTAP using Azure Synapse Link (2021-11-03)
November 1, 2021 - dbatools - new functions for Database Mail (2021-11-01)
October 30, 2021 - Azure Synapse, Microsoft Exam DP-900 and more in Database Weekly (2021-10-30)
October 29, 2021 - Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events (2021-10-29)
October 27, 2021 - Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered? (2021-10-27)
October 25, 2021 - Design your systems and processes for auditability (2021-10-25)
October 23, 2021 - Maybe It Is DNS (2021-10-23 DBW)
October 22, 2021 - Iteration and Conditional Activities in Azure Data Factory (2021-10-22)
October 20, 2021 - Migrate the SSIS Catalog in Just a Few Clicks (2021-10-20)
October 18, 2021 - Connect to PostgreSQL as an External Data Source using PolyBase (2021-10-18)
October 16, 2021 - Captain Kirk Goes To Space
October 15, 2021 - How to Delete Large Amounts of Data (2021-10-15)
October 13, 2021 - Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2021-10-13)
October 11, 2021 - Using Azure Data Studio and the SQL Migration Extension to Perform Offline Migrations (2021-10-11)
October 9, 2021 - Backup history, Managed Instance and more in Database Weekly (2021-10-09)
October 8, 2021 - Data Retention Policies, Often Forgotten (2021-10-08)
October 6, 2021 - Stairway to SSAS Tabular Level 1: Why use Analysis Services (2021-10-06)
October 4, 2021 - Incremental Data Loading Using ADF and Change Tracking (2021-10-04)
October 2, 2021 - What Do You Want to Know Before Negotiating Salary? (2021-10-02 DBW)
October 1, 2021 - The Record That Never Existed (as a committed row) (2021-10-01)
September 29, 2021 - Powershell Day by Day: Adding Help to Scripts (2021-09-29)
September 27, 2021 - Working with the Delete Activity in Azure Data Factory (2021-09-27)
September 25, 2021 - Time to Volunteer
September 24, 2021 - Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function (2021-09-24)
September 22, 2021 - PostgreSQL Date And Time Part 2 (2021-09-22)
September 20, 2021 - Azure SQL Migrations using Azure Data Studio (2021-09-20)
September 18, 2021 - Azure DevOps, Managed Instances, and more in Database Weekly (2021-09-18)
September 17, 2021 - How to Flatten JSON in Azure Data Factory? (2021-09-17)
September 15, 2021 - Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function (2021-09-15)
September 13, 2021 - Be aware of the risk that you are taking when using AWS EC2 I3 instance type (2021-09-13)
September 11, 2021 - The State of Data Growth (2021-09-11 DBW)
September 10, 2021 - Array and Custom Data Types in PostgreSQL (2021-09-10)
September 8, 2021 - Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics (2021-09-08)
September 6, 2021 - How To Find A Perfect Match (2021-09-06)
September 4, 2021 - Exploding Rocks and SQL Server Admin
September 3, 2021 - Use SQL Server Integration Services to Add HubSpot Contacts to MailChimp Lists (2021-09-03)
September 1, 2021 - Stairway to DAX and Power BI - Level 13: Introducing the DAX All() Function (2021-09-01)
August 30, 2021 - Tracking Failed Job Steps (2021-08-30)
August 28, 2021 - The SUM function, statistics, and more in Database Weekly (2021-08-28)
August 27, 2021 - Formatting T-SQL Scripts using ScriptDOM and PowerShell (2021-08-27)
August 25, 2021 - Stairway to DAX and Power BI - Level 12: The DAX CountA() and CountAX() Functions (2021-08-25)
August 23, 2021 - Sending streaming data from Azure IoT Central to Azure SQL Database (2021-08-23)
August 21, 2021 - Azure Data Lake ACL Introduction (2021-08-21 DBW)
August 20, 2021 - Working with Get Metadata Activity in Azure Data Factory (2021-08-20)
August 18, 2021 - Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions (2021-08-18)
August 16, 2021 - Using Coalesce to Clean Up Reports (2021-08-16)
August 14, 2021 - Work/Life Balance, CASE and more in Database Weekly (2021-08-14)
August 13, 2021 - Docker Desktop on Windows 10 for SQL Server : Step by Step (2021-08-13)
August 11, 2021 - Docker Desktop on Windows 10 for SQL Server : Step by Step (2021-08-11)
August 9, 2021 - PostgreSQL Date And Time Part 1 (2021-08-09)
August 6, 2021 - SQL Features Explorer (2021-08-06)
August 4, 2021 - Merge Multiple Files in Azure Data Factory (2021-08-04)
August 2, 2021 - Working with Azure IoT Central (2021-08-02)
July 31, 2021 - How to put a SQL Server Database into Recovery Pending (2021-07-31 DBW)
July 30, 2021 - PostGres and SQL Server - Divided by a common language (2021-07-30)
July 28, 2021 - High Precision Multiplication (2021-07-28)
July 26, 2021 - Why Power Query as an Activity in Azure Data Factory and SSIS? (2021-07-26)
July 24, 2021 - Blue Origin Flies
July 23, 2021 - Upsert Operation in Cosmos DB using Azure Data Factory (2021-07-23)
July 21, 2021 - Powershell Day by Day: Customizing Scripts with Parameters (2021-07-21)
July 19, 2021 - GoTo Looping (2021-07-19)
July 17, 2021 - Containers, T-SQL, and more in Database Weekly (2021-07-17)
July 16, 2021 - PostgreSQL Hibernate Integration (2021-07-16)
July 14, 2021 - Importing a CSV into SQL Server Shouldn't Be This Hard (2021-07-14)
July 12, 2021 - An Introduction to Power BI (2021-07-12)
July 10, 2021 - Do We Need to Learn Linux? (2021-07-10 DBW)
July 9, 2021 - How to Restore a Snapshot in AWS RDS with the Same Name? (2021-07-09)
July 7, 2021 - More on Column Choice and Order for Multi-column Non-Clustered Indexes (2021-07-07)
July 5, 2021 - Mapping Data Flows in Azure Data Factory (2021-07-05)
July 3, 2021 - Tools for Databases
July 2, 2021 - Real Time data streams from SQL Server using Kafka Connect in the Cloud (2021-07-02)
June 30, 2021 - Top SQL Queries to Safeguard JIRA (2021-06-30)
June 28, 2021 - Reading and Writing your Database's Documentation using JSON (2021-06-28)
June 26, 2021 - Corrupting a database, Azure DevOps, and more in Database Weekly (2021-06-26)
June 25, 2021 - PostgreSQL HAVING,LIMIT and FETCH Clauses (2021-06-25)
June 23, 2021 - PolyBase scale-out group in Azure for free (2021-06-23)
June 21, 2021 - Implement Azure SQL Elastic Jobs with PowerShell (2021-06-21)
June 19, 2021 - Deceptive Visualizations (2021-06-19 DBW)
June 18, 2021 - Conditional DELETE and INSERT in PostgreSQL (2021-06-18)
June 16, 2021 - Handling Row-level Errors in ADF Data Flows (2021-06-16)
June 14, 2021 - Azure Storage: Blob and Data Lake Storage Gen2 (2021-06-14)
June 11, 2021 - Lt. Uhura, Ways to Prevent Ransomware and More
June 11, 2021 - Creating a Robust SSIS Development Environment using the SSIS Catalog (2021-06-11)
June 9, 2021 - Stairway to Snowflake Level 2 – Create a Snowflake Account (2021-06-09)
June 7, 2021 - Finding the Optimal Value of Hyperparameters through Grid Search (2021-06-07)
June 5, 2021 - Tempdb Configuration for People in a Hurry (2021-06-05 DBW)
June 4, 2021 - The NoSQL Misdirections (2021-06-04)
June 2, 2021 - An Introduction To Kusto Query Language (2021-06-02)
May 31, 2021 - Model Selection and Performance Boosting with k-Fold Cross Validation and XGBoost (2021-05-31)
May 29, 2021 - Living Life (2021-05-29 DBW)
May 28, 2021 - How much will it cost or save to rebuild that index? (2021-05-28)
May 26, 2021 - List Azure SQL Database Read and Write Permissions (2021-05-26)
May 24, 2021 - Dimensionality Reduction Techniques - PCA, Kernel-PCA and LDA Using Python (2021-05-24)
May 22, 2021 - Storytelling with simple text (2021-05-22 DBW)
May 21, 2021 - SQL Server 2016 - Always Encrypted (2021-05-21)
May 19, 2021 - Hidden Pitfalls with INNER JOIN and NOT IN Operators (2021-05-19)
May 17, 2021 - Step by Step Guide to Install Jupyter Notebook (2021-05-17)
May 15, 2021 - Indexes, NoSQL, and more in Database Weekly (2021-05-15)
May 14, 2021 - SQL Server Integrates Hadoop and Spark out-of-the box: The Why? (2021-05-14)
May 12, 2021 - Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2 (2021-05-12)
May 10, 2021 - Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation (2021-05-10)
May 8, 2021 - Learning and an Eclectic Mix of Articles to Help
May 7, 2021 - Optimize Your SQL by Reformulating the Spec (2021-05-07)
May 5, 2021 - Stairway to Advanced T-SQL Level 2: Using the APPLY Operator (2021-05-05)
May 3, 2021 - Understanding CRUD Operations Against Heaps and Forwarding Pointers (2021-05-03)
May 1, 2021 - No-code Software Engineering (DBW 2021-05-01)
April 30, 2021 - “Included columns” for non-clustered indexes explained (2021-04-30)
April 29, 2021 - DIY Database Clones (2021-04-29)
April 28, 2021 - Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining (2021-04-28)
April 27, 2021 - Identify Profiles Actually In-use to Make Database Mail Migration Efficient (2021-04-27)
April 26, 2021 - An Introduction to Azure Data Explorer (2021-04-26)
April 23, 2021 - Columnstore indexes, PowerShell secrets, and more in Database Weekly (2020-04-24)
April 23, 2021 - Soft Skills: Controlling your career (2021-04-23)
April 22, 2021 - Dynamically Add a Timestamp To Files in Azure Data Factory (2021-04-22)
April 21, 2021 - Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services (2021-04-21)
April 20, 2021 - Installing Docker Desktop on Mac (2021-04-20)
April 19, 2021 - Navigating Trees With CTE (2021-04-19)
April 17, 2021 - Let's Talk SQL Server Administration
April 16, 2021 - An Efficient Set-based Solution for Islands and Gaps (2021-04-16)
April 15, 2021 - Load Multiple Excel Files and Worksheets with SSIS (2021-04-15)
April 14, 2021 - Using Data Science And Machine Learning In Identifying Fraudulent Activities (2021-04-14)
April 13, 2021 - Understanding the Internals of a Data Page (2021-04-13)
April 12, 2021 - Missing Data (2020-04-12)
April 10, 2021 - Patching Quickly (2021-04-09 DBW)
April 9, 2021 - Converting Binary Numbers To Hex (2021-04-09)
April 8, 2021 - Restoring Master on a Windows 2019 / SQL Server 2019 Cluster (2021-04-08)
April 7, 2021 - Stairway to SQL Server Virtualization Level 2 - The Ideal SQL Server Virtual Machine Architecture (2021-04-07)
April 6, 2021 - Reading Stored Procedure Output Parameters in Azure Data Factory (2021-04-06)
April 5, 2021 - Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory (2021-03-05)
April 3, 2021 - SQL Agent jobs, the Bit data type, and more in Database Weekly (2021-04-03)
April 2, 2021 - Solving FIFO Queues Using Windowed Functions (2021-04-02)
April 1, 2021 - Power BI Reports in SSMS (2021-04-01)
March 31, 2021 - Datatypes and the Default Mask with Dynamic Data Masking - Step 2 of the Stairway to Dynamic Data Masking (2021-03-31)
March 30, 2021 - Comparing Two Execution Plans (2021-03-30)
March 29, 2021 - System-Versioned Temporal Tables - A Case Study (2021-03-29)
March 26, 2021 - An Overview of STRING_SPLIT() (2021-03-26)
March 25, 2021 - Hacking the DTSX (SSIS XML file) to Change Defaults (2021-03-25)
March 22, 2021 - Migrating SSIS packages to Azure - Lift and Shift using Azure Data Factory (2021-03-22)
March 20, 2021 - Why Doesn't Database Software Help Us? (Database Weekly 2021-03-20)
March 19, 2021 - How to deploy and execute an SSIS package from the SSISDB catalog (2021-03-19)
March 18, 2021 - Getting a Query Execution Plan in PostgreSQL (2021-03-18)
March 17, 2021 - Stairway to SQL Server Security Level 2: Authentication (2021-03-17)
March 16, 2021 - Using Non-SQL Languages in Azure Data Studio (2021-03-16)
March 15, 2021 - Google Cloud Certification for Microsoft Database Engineer (2021-03-15)
March 13, 2021 - Favorite data types, parameterized notebooks and more in Database Weekly (2021-03-13)
March 12, 2021 - Keep Column Headers Visible in SSRS (2021-03-12)
March 11, 2021 - PostgreSQL WHERE, ORDER BY, and GROUP BY Clauses (2021-03-11)
March 10, 2021 - Stairway to SQLCLR Level 6: Development Tools Intro (2021-03-10)
March 9, 2021 - Reading a Specific File from an S3 bucket Using Python (2021-03-09)
March 8, 2021 - Creating a Simple DynamoDB NoSQL Table in AWS (2021-03-08)
March 6, 2021 - Focusing on SQL Server Administration
March 5, 2021 - A Sudoku Solver for Ordinary folk (2021-03-05)
March 4, 2021 - Using ADF to Upload Disparate CSV Files into Azure MySQL (2020-03-04)
March 3, 2021 - Stairway to U-SQL Level 2: Breakdown of a U-SQL Statement (2020-03-03)
March 2, 2021 - Monitor SQL Server Error Logs with PowerShell (2021-03-02)
March 1, 2021 - Microsoft Azure ADF - Dynamic Pipelines (2021-03-01)
February 27, 2021 - How to become a data scientist and more in Database Weekly (2021-02-27)
February 26, 2021 - Monitoring the Number of Connections (2021-02-26)
February 25, 2021 - Query Optimizer Suggests Wrong Index and Query Plan -- Why? (2021-02-25)
February 24, 2021 - Stairway to SQL Server Extended Events Level 3: Working with the Extended Events UI (2021-02-24)
February 23, 2021 - Minimal Downtime Storage Migration of Large Databases (2021-02-23)
February 22, 2021 - Implementation of Normalization in SQL Server (2021-02-22)
February 20, 2021 - Community Updates
February 19, 2021 - Redistributing Data Across Files (2021-02-19)
February 18, 2021 - Getting Started with Azure Purview (2021-02-18)
February 17, 2021 - Stairway to Snowflake Level 1 - An Introduction to Snowflake (2021-02-17)
February 16, 2021 - The Dilemma of DBAs (2021-02-16)
February 15, 2021 - Getting Comfortable Writing Code in Azure Data Studio (2021-02-15)
February 13, 2021 - Looking to Role Models - Data Platform WIT Day (2021-02-13 DBW)
February 12, 2021 - Offline R Services installation and patching (2021-02-12)
February 11, 2021 - Syncing your SQL Server database backups to an AWS S3 bucket (2021-02-11)
February 10, 2021 - Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator (2021-02-10)
February 9, 2021 - Upgrade PostgreSQL 9.X to 12.X in Windows (2021-02-09)
February 8, 2021 - Discussion on Normalization and Database Design Concepts (2021-02-08)
February 6, 2021 - Statistics, data warehouse mistakes and more in Database Weekly (2021-02-06)
February 5, 2021 - Guide to Quickly Creating an Azure Data Lake Storage (2021-02-05)
February 4, 2021 - sp_who4 (2021-02-04)
February 3, 2021 - Compare, Modify, Derive and Validate Date and Time Values (2021-02-03)
February 2, 2021 - How to Restore an Agent Job that was Dropped (2021-02-02)
February 1, 2021 - PostgreSQL Python Integration (2021-02-01)
January 30, 2021 - A Little Performance Tuning, A Lot of Security
January 29, 2021 - Your SQL Servers Are Misconfigured... (2021-01-29)
January 28, 2021 - Building SQL Memorial - Automating Updates (2021-01-28)
January 27, 2021 - Remembering the Past with SQLMemorial (2021-01-27)
January 26, 2021 - Getting started with the SQL MERGE statement (2021-01-26)
January 25, 2021 - Power Query or SQL Server? Which, when and why (2021-01-25)
January 23, 2021 - Data Privacy Grows in California (DBW 2020-01-23)
January 22, 2021 - Import flat files to SQL Server on Linux using Azure Data Studio (2021-01-22)
January 21, 2021 - The CAST operator in PostgreSQL (2021-01-21)
January 20, 2021 - Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values (2021-01-20)
January 19, 2021 - Mathematicians and SQL (2021-01-19)
January 18, 2021 - Using an RDL File Locally in .NET to Print Reports (2021-01-18)
January 16, 2021 - Saying goodbye to a friend, number series generator, and more in Database Weekly (2021-01-16)
January 15, 2021 - ASCII Text Dump (2021-01-15)
January 14, 2021 - Working with NULL Values in an ADF Data Flow? (2021-01-14)
January 13, 2021 - Exploring Facts About SQL Server Tables: Stairway to Exploring Database Metadata Level 5 (2021-01-13)
January 12, 2021 - Analyze Azure Cosmos DB data using Synapse Link and Power BI (2021-01-12)
January 11, 2021 - Data Element Names and Scoping Rules in SQL (2021-01-11)
January 9, 2021 - Inner Joins, Post Mortems, and a Little Governance
January 8, 2021 - How to Decipher @@Options (2021-01-08)
January 7, 2021 - PostgreSQL DML Statements (2021-01-07)
January 6, 2021 - Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell (2021-01-06)
January 5, 2021 - Spoofing Data Convincingly: Text Data (2021-01-05)
January 4, 2021 - Do *not* place TEMPDB on a local disk in a SQL failover cluster (2021-01-04)
January 2, 2021 - Building a Better Community (DBW 2021-01-02)
January 1, 2021 - Happy New Year (2021-01-01)
December 31, 2020 - PowerShell Day By Day: The Pipeline (2020-12-31)
December 30, 2020 - Stairway to Server Management Objects (SMO) Level 3: The Database Class (2020-12-30)
December 29, 2020 - Save costs with Azure Data Factory (2020-12-29)
December 28, 2020 - Migrate the SSIS Catalog in Just a Few Clicks (2020-12-28)
December 26, 2020 - Azure Data Factory, CTEs, and more (Database Weekly 2020-12-26)
December 25, 2020 - Merry Christmas 2020 (2020-12-25)
December 24, 2020 - Download SQL Patch Info (2020-12-24)
December 23, 2020 - Moving Dynamic Data Masked Data to New Locations - Step 5 of the Stairway to Dynamic Data Masking (2020-12-23)
December 22, 2020 - Scheduling SQL Scripts Using Jenkins (2020-12-22)
December 21, 2020 - The case for SQL Server Agent 2.0 (2020-12-21)
December 19, 2020 - It’s Time for Public Sector Standards On AI (2020-12-19)
December 18, 2020 - Load Extended Events via Powershell (2020-12-18)
December 17, 2020 - Using Azure Synapse Link for Azure Cosmos DB (2020-12-17)
December 16, 2020 - Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages (2020-12-16)
December 15, 2020 - Introduction to PostgreSQL Database on Amazon RDS (2020-12-15)
December 14, 2020 - Basic Git for DBAs: Ignoring Files and Customizing Your Environment (2020-12-14)
December 12, 2020 - Knowing your server’s limits, Tuning your Windowing Functions and more in Database Weekly (12/12/20)
December 11, 2020 - More On Column Order Indexes – Part 2 (2020-12-11)
December 10, 2020 - Scheduling PowerShell Using Jenkins (2020-12-10)
December 9, 2020 - Stairway to AlwaysOn Level 2: Storage 101 (2020-12-09)
December 8, 2020 - A Technology Collapse (2020-12-05 DBW)
December 8, 2020 - Boost the performance of your SQL Server tables with a TURBO button (2020-12-08)
December 7, 2020 - Steps for Installing AlwaysOn Availability Groups - SQL 2019 (2020-12-07)
December 4, 2020 - Index Column Order – Be Happy! (2020-12-04)
December 3, 2020 - Rules in PostgreSQL (2020-12-03)
December 2, 2020 - Stairway to SQL Server Security Level 4: Permissions (2020-12-02)
December 1, 2020 - Simple Credential Management for DevOps Database Release to Azure SQL Database (2020-12-01)
November 30, 2020 - Creating SQL Agent Jobs to Run PowerShell (2020-11-30)
November 28, 2020 - Virtual log files, DAX formatter, and more (Database Weekly 2020-11-28)
November 27, 2020 - Using Notebooks in Azure Data Studio (2020-11-27)
November 26, 2020 - Happy Thanksgiving (2020-11-26)
November 25, 2020 - Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD (2020-11-25)
November 24, 2020 - Fixing "Login failed for user" error in SQL Server (2020-11-24)
November 23, 2020 - Getting Informative SQL Agent Notifications from Failed SSIS Packages (2020-11-23)
November 21, 2020 - The way we train AI is fundamentally flawed (2020-11-21 DBW)
November 20, 2020 - Generate QR Code® barcodes in an SSRS report with the QRCoder library (2020-11-20)
November 19, 2020 - Getting started with PostgreSQL on MacOS (2020-11-19)
November 18, 2020 - Stairway to Database Design Level 8: Cursors (2020-11-18)
November 17, 2020 - Ensure that SSRS is Working while Using Availability Groups (2020-11-17)
November 16, 2020 - An Introduction to Azure Cosmos DB (2020-11-16)
November 14, 2020 - Missing Agents, Undercover Hints and More SQL Mysteries in Database Weekly (11/14/2020)
November 13, 2020 - A Quick Start to Running Python Code in SQL Server (2020-11-13)
November 12, 2020 - How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS? (2020-11-12)
November 11, 2020 - Stairway to XML: Level 3 - Working with Typed XML (2020-11-11)
November 10, 2020 - Block user objects from being created in a master database (2020-11-10)
November 9, 2020 - Finding the Free Space Difference Between Availability Groups Replicas (2020-11-09)
November 7, 2020 - Multi-server admin, storytelling, and more (Database Weekly 2020-11-07)
November 6, 2020 - Service Broker Part 1: Service Broker Basics (2020-11-06)
November 5, 2020 - Automate MSBI deployments Using PowerShell (2020-11-05)
November 4, 2020 - Stairway to Advanced T-SQL Level 11: Using Logical Operators (2020-11-04)
November 3, 2020 - Handling the Duplication of Records (2020-11-03)
November 2, 2020 - NoSqlOnSql (2020-11-02)
October 31, 2020 - Always On Availability Groups, Virtualization, and more (Database Weekly 2020-10-31)
October 30, 2020 - Efficiently Polling Remote Data Sources (2020-10-30)
October 29, 2020 - Setting Rows to Odd and Even Values (2020-10-29)
October 28, 2020 - Stairway to SSAS Tabular Level 11: Partitioning (2020-10-28)
October 27, 2020 - Recovering Databases From a Master Backup (2020-10-27)
October 26, 2020 - Better SQL Server Agent Job Failure Monitoring (2020-10-26)
October 24, 2020 - Azure DevOps, Power BI, and more in Database Weekly (2020-10-24)
October 23, 2020 - Using pw-inspector in Brute Force attack on SQL Server (2020-10-23)
October 22, 2020 - Make SQL Server Agent Jobs HADR Aware (2020-10-22)
October 21, 2020 - Stairway to Advanced T-SQL Level 10: Using Scalar Functions (2020-10-21)
October 20, 2020 - Great Power(Shell)...Great Responsibility (2020-10-20)
October 19, 2020 - Connecting to SQL Server with MuleSoft AnyPoint 3.9 (2020-10-19)
October 16, 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 15, 2020 - Getting Started with Gremlin (2020-10-15)
October 14, 2020 - Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function (2020-10-14)
October 13, 2020 - Incremental Data loading through ADF using Change Tracking (2020-10-13)
October 12, 2020 - Random Thoughts (2020-10-12)
October 10, 2020 - ALTER Procedures When Using Query Store (DBW 2020-10-10)
October 9, 2020 - Create AT&T Network Hierarchy Diagrams using SQL Server Data (2020-10-09)
October 8, 2020 - PowerShell Day by Day: Filtering Objects (2020-10-08)
October 7, 2020 - The Basics - Level 1 of the Stairway to Query Store (2020-10-07)
October 6, 2020 - Experimenting with PostgreSQL in a Container (2020-10-06)
October 5, 2020 - Application down after SQL Service logon account change (2020-10-05)
October 3, 2020 - Azure SQL Database, SQL Server in Containers, and more in Database Weekly (2020-10-03)
October 2, 2020 - TRIM() in T-SQL (2020-10-02)
October 1, 2020 - Configure Replication Between an On-premises SQL Server and AWS RDS (2020-10-01)
September 30, 2020 - Editor Tips and Tricks for Azure Data Studio (2020-09-30)
September 29, 2020 - When one of your DBA colleagues leaves the company, what is your checklist? (2020-09-29)
September 28, 2020 - A Getting Started PostgreSQL Tutorial (2020-09-28)
September 26, 2020 - SQL Server Suddenly Frozen? You Might Be Snapshotting Too Many Databases. (DBW 2020-09-26)
September 25, 2020 - Creating Subtotals and Totals in Aggregated Queries (2020-09-25)
September 24, 2020 - Incremental Data Loading using Azure Data Factory (2020-09-24)
September 23, 2020 - Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function (2020-09-23)
September 22, 2020 - Dear Past Me on My First Day as a DBA (2020-09-22)
September 21, 2020 - Availability Groups with Docker Containers (2020-09-21)
September 19, 2020 - Join the SQL Merry-Go-Round with Database Weekly (09/19/2020)
September 18, 2020 - SQL Server on Amazon RDS vs SQL Server on Amazon EC2 (2020-09-18)
September 17, 2020 - Conditional Formatting with SSRS (2020-09-17)
September 16, 2020 - Stairway to Biml Level 7 – Populating the Database for a Custom Biml Framework (2020-09-16)
September 15, 2020 - Indexes: When Column Selectivity Is Not Always A Requirement (2020-09-15)
September 14, 2020 - SQL Server 2017 Installation Error with KB2919355 (2020-09-14)
September 12, 2020 - Why Your Query Can’t Go Parallel, Table Variables Edition (2020-09-12 DBW)
September 11, 2020 - When SQL Server Performance Goes Bad: Implicit Conversions (2020-09-11)
September 10, 2020 - SCOM Alert: MSSQL 2014: SQL Server cannot authenticate using Kerberos (2020-09-10)
September 9, 2020 - Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-09-09)
September 8, 2020 - Configure SQL Server on Ubuntu 16.04 to use Active Directory Authentication (2020-08-08)
September 7, 2020 - Downloading a CSV File from an API Using Azure Data Factory (2020-09-07) - Happy Labor Day
September 5, 2020 - Docker 101, Adaptive Joins, and more (Database Weekly 2020-09-05)
September 4, 2020 - Configuring SQL Server Always on Azure Servers(Iaas) (2020-08-04)
September 3, 2020 - Installing PostgreSQL 11 on Windows with Step-by-step instructions (2020-09-03)
September 2, 2020 - Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function (2020-09-02)
September 1, 2020 - Using Recommendations for MAXDOP and Max Memory During Installation (2020-09-01)
August 31, 2020 - Database Modeling - Relationships (2020-08-31)
August 29, 2020 - Learning Isn’t Easy, But It’s Vital (2020-08-29)
August 28, 2020 - Database Snapshot Use Case: Service Migration (2020-08-28)
August 27, 2020 - Basic Git for DBAs: Managing PowerShell Scripts (2020-08-27)
August 26, 2020 - Removing TDE from a Database: Level 4 of the Stairway to TDE (2020-08-26)
August 25, 2020 - Configuring Availability Groups in Ubuntu (2020-08-25)
August 24, 2020 - An Introduction to Azure Synapse Analytics Workspace (2020-08-24)
August 22, 2020 - Starting SQL, Sizing Up Columns, Singing Hedgehog Songs, in Database Weekly (08/22/20)
August 21, 2020 - Native SQL Backups for Amazon RDS Databases (2020-08-21)
August 20, 2020 - Calling Procs from PowerShell with Parameters (2020-08-20)
August 19, 2020 - Permissions and Security in Dynamic Data Masking (2020-08-19)
August 18, 2020 - Recover database encrypted modules code with dbatools (2020-08-18)
August 17, 2020 - How to override Date Filters in Power BI (2020-08-17)
August 15, 2020 - Why a 60GB Database Backup Grew to 1TB in Size (DBW 2020-08-15)
August 14, 2020 - TOP vs Max/Min: Is there a difference? (2020-08-14)
August 13, 2020 - The Basics of PowerShell Day By Day (2020-08-13)
August 12, 2020 - Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics (2020-08-12)
August 11, 2020 - Azure Data Factory : Your First Data Pipeline (2020-08-11)
August 10, 2020 - Protect SQL Databases with Dell EMC PowerProtect and DataDomain Under VMware (2020-08-10)
August 8, 2020 - Online certification exams, Historical dimensions, and more in Database Weekly (2020-08-08)
August 7, 2020 - Visualise SQL Server IO Stats (2020-08-07)
August 6, 2020 - Basic Git for DBAs: What's a Pull Request? (2020-08-06)
August 5, 2020 - Exploring SQL Server Indexes: Stairway to Exploring Database Metadata Level 3 (2020-08-05)
August 4, 2020 - Calling a Stored Procedure from PowerShell (2020-08-04)
August 3, 2020 - Change the Instance Collation by Rebuilding Databases in SQL Server 2017 (2020-08-03)
August 1, 2020 - Tracking use of Deprecated SQL Server Features (DBW 2020-08-01)
July 31, 2020 - Removing Extended Properties (2020-07-31)
July 30, 2020 - Honorifics in the 21st century (2020-07-30)
July 29, 2020 - Stairway to Biml Level 6 - Programming with Metadata (2020-07-29)
July 28, 2020 - Access external data from Azure Synapse Analytics using Polybase (2020-07-28)
July 27, 2020 - SQL Server 2012 does not come up after service pack upgrade SP4 (2020-07-27)
July 25, 2020 - The Ultimate Home Office (DBW 2020-07-25)
July 24, 2020 - Primary keys for an OLTP database (2020-07-24)
July 23, 2020 - Basic Git for DBAs: Merging Code Between Branches (2020-07-23)
July 22, 2020 - Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016 (2020-07-22)
July 21, 2020 - TDE BYOK and Geo-Replication in Azure SQL DB (2020-07-21)
July 20, 2020 - Loading data in Azure Synapse Analytics using Azure Data Factory (2020-07-20)
July 18, 2020 - Everything I Never Wanted to Know About Collation (DBW 2020-07-18)
July 17, 2020 - Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory) (2020-07-17)
July 16, 2020 - Unable to connect SSIS remotely (2020-07-16)
July 15, 2020 - An Introduction: Level 1 of the Stairway to Row-Level Security (2020-07-15)
July 14, 2020 - Basic Git for DBAs: Making Changes in GitHub (2020-07-14)
July 13, 2020 - Loading data in Azure Synapse using Copy (2020-07-13)
July 11, 2020 - NULLs, GitFlow, MAXDOP and more in Database Weekly (2020-07-11)
July 10, 2020 - The Basics of iTVFs (2020-07-10)
July 9, 2020 - Implementing Restart Ability For Shell Scripts (2020-07-09)
July 8, 2020 - Stairway to Data, Level 4: Temporal Data (2020-07-08)
July 7, 2020 - Business Reasons For Implementing Power BI (2020-07-07)
July 6, 2020 - Availability Groups with Docker Containers (2020-07-06)
July 4, 2020 - The Pros and Cons of Virtual Conferences: Just My Opinions (DBW 2020-07-04)
July 3, 2020 - Implementing Stretch Database (2020-07-03)
July 2, 2020 - How Bad are Bad Page Splits – The Rest of the Story (2020-07-02)
July 1, 2020 - Stairway to U-SQL Level 22: Creating a Custom Extractor (2020-07-01)
June 30, 2020 - Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules (2020-06-30)
June 29, 2020 - Creating a Serverless Database in Azure (2020-06-29)
June 27, 2020 - SQL: the Traditional Way, the Quick Way and the "Wait, What? Why?!" Way, in Database Weekly (06/27/2020)
June 26, 2020 - Getting started with SQL 2019 Big Data Clusters in Azure (2020-06-26)
June 25, 2020 - Logshipping to SQL Server on Linux (2020-06-25)
June 24, 2020 - Stairway level 3 : Configure Extensible Key Management Using Azure Key Vault (2020-06-24)
June 23, 2020 - SSIS Variable and Parameter Analysis (2020-06-23)
June 22, 2020 - DAX for SQL Folks: Part III - DAX Calculations (2020-06-22)
June 20, 2020 - Azure SQL Database Migrating across Tiers (2020-06-20)
June 19, 2020 - Creating and using inline table-valued functions (2020-06-19)
June 18, 2020 - Provisioning Azure SQL Database with Failover groups using Terraform (2020-06-18)
June 17, 2020 - Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions (2020-06-17)
June 16, 2020 - Basic Git for DBAs: the Basics of Branches (2020-06-16)
June 15, 2020 - Banker’s Rounding. What is it good for? (2020-06-15)
June 13, 2020 - Suspect databases, Heaps, and more in Database Weekly (2020-06-13)
June 12, 2020 - Migrating SQL Server Reporting Services (2020-06-12)
June 11, 2020 - Lock Scenarios Using sys.dm_tran_locks (2020-06-11)
June 10, 2020 - Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table (2020-06-10)
June 9, 2020 - Basic Git for DBAs: Sharing Files Through GitHub (2020-06-09)
June 8, 2020 - Basic Git for DBAs: Getting Started with Git (2020-06-08)
June 6, 2020 - The Social Impact of Data (DBW 2020-06-06)
June 5, 2020 - 3 Things I Wish I Knew When I Started Using Entity Framework (2020-06-05)
June 4, 2020 - How to Download Stocks on Schedule Using R (2020-06-04)
June 3, 2020 - What is the Machine Learning Server? Level 2 of the Stairway to ML Services (2020-06-03)
June 2, 2020 - Microsoft SQL Server Utilities and Tools (2020-06-02)
June 1, 2020 - Installing SQL Server 2019 using the Azure Cloud Shell (2020-06-01)
May 30, 2020 - Troublesome parameter sniffing, misleading execution plans and more in Database Weekly, 05/30/20
May 29, 2020 - Azure DWH part 19: Backup and Restore SSAS (2020-05-29)
May 28, 2020 - The Basics of Using a Sequence as a Table Default (2020-05-28)
May 27, 2020 - Monitoring - Level 6 of the Stairway to SQL Server on Linux (2020-05-27)
May 26, 2020 - Adding a Database with Polybase External Tables to Always On Availability Group (2020-05-26)
May 25, 2020 - How to Move System Databases to a New Physical Directory (2020-05-25)
May 23, 2020 - The Build Book of News (DBW 2020-05-23)
May 22, 2020 - Azure DWH part 18: Working with SQL Server Analysis Services (2020-05-22)
May 21, 2020 - The IDENTITY Column Property (2020-05-21)
May 20, 2020 - Stairway Level 2 : Restore a Backup of a TDE Database to Another Server (2020-05-20)
May 19, 2020 - The Products-Often-Purchased-Together Problem Solved in R (2020-05-19)
May 18, 2020 - Creating a Azure Cosmos DB Account (2020-05-18)
May 16, 2020 - Troubleshooting tempdb, Power BI Visuals and more in Database Weekly (2020-05-16)
May 15, 2020 - Bones of SQL - Practical Calendar Queries (2020-05-15)
May 14, 2020 - A Solution for the Bin Packing Problem (2020-05-14)
May 13, 2020 - Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-05-13)
May 12, 2020 - Concurrency Control in SQL Server (2020-05-12)
May 11, 2020 - Postgresql JDBC Tutorial on Linux (2020-05-11)
May 9, 2020 - Capturing DBCC CHECKDB Output (DBW 2020-05-09)
May 8, 2020 - Changing the Path for the Master Database (2020-05-08)
May 7, 2020 - Dynamic SQL Going Haywire (2020-04-07)
May 6, 2020 - Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2020-05-06)
May 5, 2020 - How to Resolve a Duplicate Key Error in SSAS (2020-05-05)
May 4, 2020 - Configuring Database Alerts for Azure SQL Database (2020-05-04)
May 2, 2020 - Troubleshoot Performance in Azure SQL Database, Build Power BI Reports, Tune Queries and more in Database Weekly (05/02/20)
May 1, 2020 - Export SQL Server Tables to Excel (2020-05-01)
April 30, 2020 - DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries (2020-04-30)
April 29, 2020 - Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE (2020-04-29)
April 28, 2020 - Your First Pipeline with Azure Data Factory (2020-04-28)
April 27, 2020 - A Pattern Based Approach to Masking Errors (2020-04-27)
April 25, 2020 - Vulnerability Finding Using Machine Learning (2020-04-25 DBW)
April 24, 2020 - Representing XML data in SQL Server (2020-04-24)
April 23, 2020 - A Set-based Solution for the Bin Packing Problem (2020-04-23)
April 22, 2020 - Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function (2020-04-22)
April 21, 2020 - Create Custom Functions in Power Query (2020-04-21)
April 20, 2020 - A Data Science Approach in Product Analytics (2020-04-20)
April 18, 2020 - Registered servers, moving database files and more (Database Weekly 2020-04-18)
April 17, 2020 - SQL Server Rounding Tips and Tricks (2020-04-17)
April 16, 2020 - Helpful Unix Commands/Debugging made easy (2020-04-16)
April 15, 2020 - Idempotent DDL Scripts That Always Achieve The Same Result (2020-04-15)
April 14, 2020 - How To Avoid MERGE in SQL Server (2020-04-14)
April 13, 2020 - Perform Data Filtering in Oracle Link to SQL Server (2020-04-13)
April 11, 2020 - SQL Server In Place Upgrades: Too Expensive? (DBW 2020-04-11)
April 10, 2020 - Why QUOTENAME is important (2020-04-10)
April 9, 2020 - Implementing Reporting Application Enhancements with No Downtime (2020-04-09)
April 8, 2020 - Stairway to U-SQL Level 16: The Azure Data Lake Catalog (2020-04-08)
April 7, 2020 - Iterating Over Calculated Tables using Power Query (2020-04-07)
April 6, 2020 - Automate your Morning Checklist (2020-04-06)
April 3, 2020 - Aggregate Data for the Last Day of the Month (2020-04-03)
April 2, 2020 - Check Your Backup Compliance Against a Data Management Provider (2020-04-02)
April 1, 2020 - SQL v.Next Gets Native Python in SQL Server (2020-04-01)
March 31, 2020 - Graphical analysis of SSRS report usage with Grafana (2020-03-31)
March 30, 2020 - Collections: Computed gaps for continuous numbers ( 2020-03-30)
March 28, 2020 - Now Is a Good Time for Choices (DBW 2020-03-28)
March 27, 2020 - Analyzing Formula 1 results in R (2020-03-27)
March 26, 2020 - DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz (2020-03-26)
March 25, 2020 - Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions (2020-03-25)
March 24, 2020 - Creating SQL containers on Azure Data Studio Notebooks with Python (2020-03-24)
March 23, 2020 - Collections: Crossing intervals computed gaps (2020-03-23) (2020-03-23)
March 21, 2020 - Working from home, containers, and more (Database Weekly 2020-03-21)
March 20, 2020 - Approaches to Import JSON in SSIS (SQL Server 2016+) Part 2 (2020-03-20)
March 19, 2020 - Restore SQL Server database using data management provider REST API (2020-03-19)
March 18, 2020 - SQL Server Extended Properties: Stairway to Exploring Database Metadata Level 7 (2020-03-18)
March 17, 2020 - Fetch Web Data in Power BI (2020-03-17)
March 16, 2020 - Combining many crossing intervals (2020-03-16)
March 14, 2020 - Window Shopping the Query Store with XEvents (DBW 2020-03-14)
March 13, 2020 - Approaches to Import JSON in SSIS (SQL Server 2016+) Part 1 (2020-03-13)
March 12, 2020 - Using the RANKX function in Power BI (2020-03-12)
March 11, 2020 - Stairway to SSAS Tabular Level 9: Security and Roles (2020-03-11)
March 10, 2020 - Gap Analysis Using Algebra (2020-03-10)
March 9, 2020 - Implementing Drill Through Actions in SSAS (2020-03-09)
March 6, 2020 - Displaying Hierarchical Data (2020-03-06)
March 5, 2020 - Implementing Date Calculations in SQL (2020-03-05)
March 4, 2020 - Stairway to U-SQL Level 9: Views and C# Expressions (2020-03-04)
March 3, 2020 - How Bad are Bad Page Splits? (2020-03-03)
March 2, 2020 - Introduction to STRING_SPLIT function in SQL (2020-03-02)
February 29, 2020 - Automatic Redaction of PII (DBW 2020-02-28)
February 28, 2020 - Mean Median Mode using SQL and DAX (2020-02-28)
February 27, 2020 - Exploring the DATE Functions in SQL (2020-02-27)
February 26, 2020 - Stairway to U-SQL Level 1: Introduction to U-SQL and Azure Data Lakes (2020-02-26)
February 25, 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 24, 2020 - Monitor for errors in your SSAS, SSRS, SSIS, Agent and Full-Text services (2020-02-24)
February 21, 2020 - Azure Data Factory Triggers (2020-02-21)
February 20, 2020 - DBA Team Mashup (2020-02-20)
February 19, 2020 - Stairway to SQL Server Agent: Level 1: Setup and Overview (2020-02-19)
February 18, 2020 - Database Normalization in SQL with Examples (2020-02-18)
February 17, 2020 - Handling Aggregations on a Poorly Designed Database (2020-02-17)
February 15, 2020 - Power BI Tips, Faster Scalar UDFs, and more in Database Weekly (2020-02-15)
February 14, 2020 - A quick search without an index (2020-02-14)
February 13, 2020 - Collections (2020-02-13)
February 12, 2020 - Installing Machine Learning Services – Level 1 of the Stairway to ML Services (2020-02-12)
February 11, 2020 - Shell Scripting Standards (2020-02-11)
February 10, 2020 - New: 2020 State of Database DevOps report (2020-02-10)
February 8, 2020 - Some Query Tuning, Technology Failures in Iowa, DevOps
February 7, 2020 - Incremental Package Deployment – A SSIS 2016 Feature (2020-02-07)
February 6, 2020 - Introduction to PIVOT operator in SQL (2020-02-06)
February 5, 2020 - Stairway to SSAS Tabular Level 2: Installing the Components (2020-02-05)
February 4, 2020 - Calculate Moving Averages using T-SQL in SQL Server (2020-02-04)
February 3, 2020 - Analysis Services : OLEDB Error while processing in SSAS (2020-02-03)
February 1, 2020 - Signs Your Execution Plan is Lying to You and more in Database Weekly (02/01/2020)
January 31, 2020 - The Connection to the Primary Replica is not Active (2020-01-31)
January 30, 2020 - Export/Import Data using BCP - SQL Server on Linux (2020-01-30)
January 29, 2020 - Creating a Logical SQL Server: Level 2 of the Stairway to Azure SQL Database (2020-01-29)
January 28, 2020 - Do Not Set Trustworthy On for the SSISDB Catalog (2020-01-28)
January 27, 2020 - Month-over-Month calculation using DAX in Power BI (2020-01-27)
January 25, 2020 - Where you should tune your queries, and how in Database Weekly (01/25/2020)
January 24, 2020 - Should I Type * or 1 With the EXISTS Logical Operator (2020-01-24)
January 23, 2020 - Stable Marriages Using SQL Server (2020-01-23)
January 22, 2020 - Stairway to SSAS Tabular Level 1: Why use Analysis Services (2020-01-22)
January 21, 2020 - Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2 (2020-01-21)
January 20, 2020 - SSAS Error: Duplicate attribute key found when processing (2020-01-20)
January 18, 2020 - Reducing Imposter Syndrome and Unclogging SQL Server in Database Weekly (01/18/2020)
January 17, 2020 - SSRS Audit: All reports executed/not-executed during previous 30 days (2020-01-17)
January 16, 2020 - How to remove quote marks using SSIS and a little C# (2020-01-16)
January 15, 2020 - Provisioning ADF - Level 2 of the Stairway to Azure Data Factory (2020-01-15)
January 14, 2020 - Re-oiling the gears for the data dictionary or catalog (2020-01-14)
January 13, 2020 - Dynamically process SSAS Cube from SSIS package (2020-01-13)
January 11, 2020 - Execution Plans, Memory Optimized Tables, and more (Database Weekly 2020-01-01)
January 10, 2020 - Obsoleting Unused SSRS Reports (2020-01-10)
January 9, 2020 - Use Polybase to consume Oracle data from SQL Server on Linux 2019 (2020-01-09)
January 8, 2020 - Stairway to AlwaysOn Level 4: Analyse and Deploy a Windows Server Failover Cluster (2020-01-08)
January 7, 2020 - A tale of updating a legacy system bug (2020-01-07)
January 6, 2020 - Setting up Management Studio for remote SQL Server (2020-01-06)
January 4, 2020 - Predictions 2020: What's Going to Happen in Cloud Computing (2020-01-04)
January 3, 2020 - SQL Server Unit Testing in Visual Studio (2020-01-03)
January 2, 2020 - Exporting Data with PowerShell (2020-01-02)
January 1, 2020 - SSIS Catalog Environments– Step 20 of the Stairway to Integration Services (2020-01-01)
December 31, 2019 - Browsing SSAS Instance over the internet (2019-12-31)
December 30, 2019 - Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1 (2019-12-30)
December 28, 2019 - SSIS Formatting, Parameter Sniffing and Data Virtualization in Database Weekly (2019-12-28)
December 27, 2019 - OUTPUT Clause Basics (For Inserts and Deletes) (2019-12-27)
December 26, 2019 - SSISDB Catalog Defaults Best Practices (2019-12-26)
December 25, 2019 - Merry Christmas 2019 (2019-12-25)
December 24, 2019 - Curious Case of SUM Function (2019-12-24)
December 23, 2019 - Querying database schema using graph tables (2019-12-23)
December 21, 2019 - Database Reliability Engineering (DBW 2019-12-21)
December 20, 2019 - Performance Tuning Using Extended Events: Part 3 (2019-12-20)
December 19, 2019 - Finding Non Current Cumulative Updates (2019-12-19)
December 18, 2019 - Stairway to Columnstore Indexes Level 1: A First Look At Columnstore Indexes (2019-12-18)
December 17, 2019 - Monitor Current Analysis Services Activity (2019-12-17)
December 16, 2019 - SQL Server performance issue after an upgrade (2019-12-16)
December 14, 2019 - BI Dashboards, Slow Index Rebuilds and Bitter Complaints in Database Weekly (12/14/19)
December 13, 2019 - Performance Tuning Using Extended Events: Part 2 (2019-12-13)
December 12, 2019 - Querying Master Database DMVs in Azure SQL Database (2019-12-12)
December 11, 2019 - Security Across Databases with Cross-Database Ownership Chaining (2019-12-11)
December 10, 2019 - SQL Server Name Convention and T-SQL Programming Style (2019-12-10)
December 9, 2019 - Increase Query Speed with Covering Indexes (2019-12-09)
December 7, 2019 - Azure DevOps - New Microsoft SSIS Deploy task (DBW 2019-12-07)
December 6, 2019 - Performance Tuning Using Extended Events: Part 1 (2019-12-06)
December 5, 2019 - Migrating Column Level Encryption from 2008R2 to Azure SQL Database (2019-12-05)
December 4, 2019 - Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework (2019-12-04)
December 3, 2019 - It's More Than What You Know (2019-12-03)
December 2, 2019 - Query Performance Diagnostics with sp_PerfSQ (2019-12-02)
November 30, 2019 - Azure Arc-Servers, Accelerated Database Recovery, and more in Database Weekly (11/30/2019)
November 29, 2019 - View R Plots from within SQL Server Management Studio (2019-11-29)
November 28, 2019 - The Road to Database CI (2019-11-28)
November 27, 2019 - Stairway to Biml Level 2: Biml Basics (2019-11-27)
November 26, 2019 - Moving Encrypted Data to Azure SQL Database (2019-11-26)
November 25, 2019 - How Bad are Bad Page Splits? (2019-11-25)
November 23, 2019 - When Select * Doesn’t Matter (Database Weekly 2019-11-23)
November 22, 2019 - Best Option for Working with Files in SSIS (2019-11-22)
November 21, 2019 - Verify your SQL Server database backups (2019-11-21)
November 20, 2019 - Stairway to Biml Level 1: What is Biml? (2019-11-20 )
November 19, 2019 - Understanding Outer Joins in SQL (2019-11-19)
November 18, 2019 - Collections (2019-11-18)
November 16, 2019 - Expensive Indexes, Low Cost Power BI Reports, PowerShell Puzzles, and more in Database Weekly (11/16/19)
November 15, 2019 - Scripting Tables and Procedures from SSMS (2019-11-15)
November 14, 2019 - How to Decipher @@Options (2019-11-14)
November 13, 2019 - Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages (2019-11-13)
November 12, 2019 - ASCII Text Dump (2019-11-12)
November 11, 2019 - Parameter Pain (2019-11-11)
November 9, 2019 - A Big Week for the Data Platform (DBW 2019-11-09)
November 8, 2019 - Displaying Execution Plans (2019-11-08)
November 7, 2019 - Redistributing Data Across Files (2019-11-07)
November 6, 2019 - Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once (2019-11-06)
November 5, 2019 - Managing a Recursive Group on SSRS Reporting Services Reports (2019-11-05)
November 4, 2019 - How to filter non-existing records in SQL (2019-11-04)
November 2, 2019 - SQL Server 2019 Editions and Features Announced - Database Weekly (2019-11-02)
November 1, 2019 - Challenge Your Code Design (2019-11-01)
October 31, 2019 - Using OFFSET for Paging (2019-10-31)
October 30, 2019 - Stairway to U-SQL Level 3: Processing Multiple Files With U-SQL (2019-10-30)
October 29, 2019 - Oops, I deleted that data (2019-10-29)
October 28, 2019 - Transaction Isolation Levels (2019-10-28)
October 26, 2019 - Make the most of your PASS Summit Evenings (Database Weekly 2019-10-26)
October 25, 2019 - Pattern Recognition via Principal Components Analysis (2019-10-25)
October 24, 2019 - Fixing MLS Python Services to Load the Runtime (2019-10-24)
October 23, 2019 - Databases in Azure… Where to begin? Create a Database and log in! (2019-10-23)
October 22, 2019 - Digging into Azure SQL Database Hyperscale Edition (2019-10-22)
October 21, 2019 - Modular ETL Architecture Design in SSIS (2019-10-21)
October 19, 2019 - Protecting Data from the Inside, with Database Weekly (10/19/2019)
October 18, 2019 - Automate MSBI deployments Using PowerShell (2019-10-18)
October 17, 2019 - Using Graph Theory To Group Records (2019-10-17)
October 16, 2019 - Exploring Facts About SQL Server Tables (2019-10-16)
October 15, 2019 - Using a Surrogate vs Natural Key (2019-10-15)
October 14, 2019 - A User-Defined Function returns more rows (2019-10-14)
October 12, 2019 - Where SQL Server monitoring fits into your tech stack (2019-10-12)
October 11, 2019 - Moving beyond principal components analysis (2019-10-11)
October 10, 2019 - The Basics of INCLUDE (2019-10-10)
October 9, 2019 - Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives (2019-10-9)
October 8, 2019 - A Spectacular Case of 100% CPU Caused by Online Reindexing (2019-10-08)
October 7, 2019 - 6 steps to a more secure SQL database (2019-10-07)
October 5, 2019 - Which Service in Azure Should You Use for SQL? (DBW 2019-10-05)
October 4, 2019 - Real-time moving averages for IoT with R (2019-10-04)
October 3, 2019 - Getting a List of the Striped Backup Files (2019-10-03)
October 2, 2019 - Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn (2019-10-02)
October 1, 2019 - Adding a dynamic ColumnId to a DAX Calculated Table (2019-10-01)
September 30, 2019 - Transparent Data Encryption and Extensible Key Management – Better Together (2019-09-30)
September 28, 2019 - Job Start Whenever the CPUs Become Idle
September 27, 2019 - WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits (2019-09-27)
September 26, 2019 - Getting Started with SQL Server on Google Cloud Platform (2019-09-26)
September 25, 2019 - Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors
September 24, 2019 - Using tsqlt Tests to Practice Queries (2019-09-24)
September 23, 2019 - Best WordPress Security Practices for 2020 (2019-09-23)
September 21, 2019 - SQL Server Containers, Power BI Dashboards, Big Data and more in Database Weekly (09/21/19)
September 20, 2019 - Loading Data using R and PowerBI (2019-09-20)
September 19, 2019 - Soft Skills: Controlling your career (2019-09-19)
September 18, 2019 - Stairway to SQLCLR Level 2: Sample Stored Procedure and Function (2019-09-18)
September 17, 2019 - “Included columns” for non-clustered indexes explained (2019-09-17)
September 16, 2019 - Managing SQL Server containers using Docker SDK for Python - Part 2 (2019-09-16)
September 14, 2019 - Fantasy SQL Server (Database Weekly 2019-09-14)
September 13, 2019 - Azure DWH part 19: Backup and Restore SSAS (2019-09-13)
September 12, 2019 - Optimize Your SQL by Reformulating the Spec (2019-09-12)
September 11, 2019 - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions
September 9, 2019 - SQL Server Integrates Hadoop and Spark out-of-the box: The Why? (2019-09-09)
September 7, 2019 - Azure SQL DB Serverless; dbatools book (Database Weekly 2019-09-07)
September 6, 2019 - Distributed Computing Principles and SQL-on-Hadoop Systems (2019-09-06)
September 5, 2019 - SQL Server 2016 Always Encrypted (2019-09-05)
September 4, 2019 - Provisioning ADS - Level 2 of the Stairway to Azure Data Factory (2019-09-04)
September 3, 2019 - How much will it cost or save to rebuild that index? (2019-09-03)
September 2, 2019 - The NoSQL misdirections (2019-09-02)
August 31, 2019 - Are My SQL Server Indexes Being Used? (DBW 2019-08-31)
August 30, 2019 - Loading partitioned table incrementally using SSIS (2019-08-30)
August 29, 2019 - Key Rotation in TDE (2019-08-29)
August 28, 2019 - Stairway to Database Source Control Level 1: Setting Up For Database Source Control (2019-08-28)
August 27, 2019 - A Self-Tuning Fill Factor Technique for SQL Server – Part 2 (2019-08-27)
August 26, 2019 - Azure Stretch Database, Part I: Getting Going (2019-08-26)
August 23, 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 22, 2019 - Let’s Start with Architecture (2019-08-22)
August 21, 2019 - Stairway to SQL Server Security Level 3: Principals and Securables (2019-08-21)
August 20, 2019 - A Self-Tuning Fill Factor Technique for SQL Server – Part 1 (2019-09-20)
August 19, 2019 - Memories of DR testing (2019-08-19)
August 17, 2019 - My personal impact of AI (2019-08-17)
August 16, 2019 - Vagrant and SQL Server 2017 on Linux (2019-08-16)
August 15, 2019 - How Often Do You Give Your Server a Physical? (2019-08-15)
August 14, 2019 - Stairway to SQL Server Replication: Level 1 - Introduction to SQL Server Replication (2019-08-14)
August 13, 2019 - Redgate Takes over the SQLCop Project (2019-08-13)
August 12, 2019 - Dynamic SQL for beginners in 33 minutes (2019-08-12)
August 10, 2019 - Improve your indexes, unblock your database builds in Database Weekly
August 9, 2019 - Track Sensitive Data with SQL Server Extended Properties (2019-08-09)
August 8, 2019 - Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie) (2019-08-08)
August 7, 2019 - Stairway to SQL Server Security Level 1: Overview of SQL Server Security (2019-08-07)
August 6, 2019 - SQL Agent in Level 5 of the Stairway of SQL Server on Linux (2019-08-06)
August 5, 2019 - Making Good Use of SQL Server Auditing
August 3, 2019 - Best Practices and Band Plans (Database Weekly 2019-08-03)
August 2, 2019 - Keeping tables online during loading with schema swapping using SSIS (2019-08-02)
August 1, 2019 - How to Unclog SQL Server (2019-08-01)
July 31, 2019 - Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory (2019-07-31)
July 30, 2019 - Scaling SSRS Support for SQL Azure with Containers (2019-07-30)
July 29, 2019 - Querying Temporal Tables (2019-07-29)
July 27, 2019 - Shortest Path with T-SQL Graph; FILTER() Function and more in Database Weekly (July 27, 2019)
July 26, 2019 - SQL-On-Hadoop: Hive - Part II (2019-07-26)
July 25, 2019 - Cross Database Queries in Azure SQL Database (2019-07-25)
July 24, 2019 - Installing Ubuntu in Level 1 of the Stairway to SQL Server on Linux (2019-07-24)
July 23, 2019 - Azure Elastic jobs (2019-07-23)
July 22, 2019 - Scaling SSRS Support for SQL Azure with Containers (2019-07-22)
July 20, 2019 - Microsoft Official Support End Dates for Different Versions (DBW 2019-07-20)
July 19, 2019 - SQL-On-Hadoop: Hive - Part I (2019-07-19)
July 18, 2019 - Building Custom Container Images by Hand (2019-07-18)
July 17, 2019 - Connecting - Level 4 of the Stairway to Azure SQL Database (2017-07-17)
July 16, 2019 - SQL and T-SQL for Beginners in 229 minutes (2019-07-16)
July 15, 2019 - Politics makes for bad databases - plus calculate British holidays (2019-07-15)
July 13, 2019 - Max Memory and MAXDOP configuration during install and more in Database Weekly (July 13, 2019)
July 12, 2019 - Create External and Internal tables As Select (2019-07-12)
July 11, 2019 - A DBA's Look at the Data Catalog (2019-07-11)
July 10, 2019 - Stairway to SSAS Tabular Level 7: Time Intelligence (2019-07-10)
July 9, 2019 - The Dangers When Changing Database File Names (2019-07-09)
July 8, 2019 - COLUMNS_UPDATED() and Triggers (2019-07-08)
July 6, 2019 - More Linux than Windows in Azure (2019-07-06)
July 5, 2019 - Some of my greatest mistakes (2019-07-05)
July 4, 2019 - Happy Fourth of July (2019-07-04)
July 3, 2019 - Stairway to Advanced T-SQL Level 8: Functions to Generate Date and Time values (2019-07-03)
July 2, 2019 - A Step by Step Guide to the Availability Group (AG) Listener (2019-07-02)
July 1, 2019 - Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens (2019-07-01)
June 29, 2019 - Database Horror Stories, Query Store Best Practices and more in Database Weekly (June 29, 2019)
June 28, 2019 - Introduction to Statistics (2019-06-28)
June 27, 2019 - What’s the Difference Between PERCENT_RANK and CUME_DIST? (2019-06-27)
June 26, 2019 - Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions (2019-06-26)
June 25, 2019 - All flash vs adaptive flash storage (SSC 2019-06-25)
June 24, 2019 - Exporting Stored Procedure Results to a Table (2019-06-24)
June 22, 2019 - Microsoft, Think DevOps First (2019-06-22)
June 21, 2019 - Group Managed Service Accounts (gMSAs) in SQL2016 (2019-06-21)
June 20, 2019 - Using VMware VMDKs for SQL Server Database Cloning (2019-06-20)
June 19, 2019 - Building the Ideal VMware-based SQL Server Virtual Machine (2019-06-19)
June 18, 2019 - SQL Server Agent for SQL Express on Linux (2019-06-18)
June 17, 2019 - Watching Out for Deferred Name Resolution (SQLServerCentral 2019-06-17)
June 15, 2019 - INTERSECT and EXCEPT (Database Weekly 2019-06-15)
June 14, 2019 - SQL Server Performance Benchmarking with Patterns (SQLServerCentral 2019-06-14)
June 13, 2019 - Managing SQL Server containers using Docker SDK for Python (SQLServerCentral 2019-06-13)
June 12, 2019 - Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs (SQLServerCentral (2019-06-12)
June 11, 2019 - Slower is Faster (SQLServerCentral 2019-06-11)
June 10, 2019 - Managing Always Encrypted Locally Stored Certificates in PowerShell (SQLServerCentral 2019-06-10)
June 8, 2019 - SQL Server and Antivirus (Database Weekly 2019-06-08)
June 7, 2019 - Parse Data from a Field Containing Multiple Values using CROSS APPLY (SQLServerCentral 2019-06-07)
June 6, 2019 - A Brief History of Data Analysis (SQLServerCentral 2019-06-06)
June 5, 2019 - Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs (SQLServerCentral 2019-06-05)
June 4, 2019 - A Plunge Into TOP (SQLServerCentral 2019-06-04)
June 3, 2019 - Create and deploy Azure Resource Manager templates by using the Azure portal (SQLServerCentral 2019-06-03)
June 1, 2019 - Databases made for Ops, not 'Oops!' (Database Weekly, 2019-06-01)
May 31, 2019 - Create SSRS Data Driven Subscriptions on Standard Edition (SQLServerCentral 2019-05-31)
May 30, 2019 - Connect to Sybase with a Linked Server (SQLServerCentral 2019-05-30)
May 29, 2019 - Stairway to T-SQL DML Level 5: The Mathematics of SQL: Part 2 (SQLServerCentral 2019-05-29)
May 28, 2019 - Ordering T-SQL Scripts with Git and PowerShell (SQLServerCentral 2019-05-28)
May 27, 2019 - Understanding Machine Learning (SQLServerCentral 2019-05-27)
May 25, 2019 - SQL Server 2019 CTP 3.0 (Database Weekly 2019-05-25)
May 24, 2019 - Exporting Custom Messages from Sys.Messages (SQLServerCentral 2019-05-24)
May 23, 2019 - Setup SSIS Catalog Retention Policy and Partial Cleanup Strategy (SQLServerCentral 2019-05-23)
May 22, 2019 - Stairway to T-SQL DML Level 4: The Mathematics of SQL: Part 1 (SQLServerCentral 2019-05-22)
May 21, 2019 - DBA Walkthrough – Adding space on IBM AIX Power Machines (SQLServerCentral 2019-05-21)
May 20, 2019 - Creating Aliases for Docker Commands in Linux (SQLServerCentral 2019-05-20)
May 18, 2019 - BIML shortcuts;DMVs for beginners (Database Weekly 2019-05-18)
May 17, 2019 - DBAs and the ITIL Framework, Part II: Asset Management (SQLServerCentral 2019-05-17)
May 16, 2019 - A Self-Serve System to Refresh Databases (Part 3) (SQLServerCentral 2019-05-16)
May 15, 2019 - Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups (SQLServerCentral 2019-05-15)
May 14, 2019 - Using Azure Data Studio with Git (SQLServerCentral 2019-05-14)
May 13, 2019 - The Basics - Level 1 of the Stairway to Query Store (SQLServerCentral 2019-05-13)
May 12, 2019 - Database Weekly 2019-05-11
May 10, 2019 - Database Cloning Tools in Lower Environments (SQLServerCentral 2019-05-10)
May 9, 2019 - A Self-Serve System that Allows Developers to Refresh Databases (Part 2) (SQLServerCentral 2019-05-09)
May 8, 2019 - Beyond The Basics Level 3: Building a Correlated Subquery - Stairway to T-SQL (SQLServerCentral 2019-05-08)
May 7, 2019 - Using Azure Data Studio with TFVC (SQLServerCentral 2019-05-07)
May 6, 2019 - Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services (SQLServerCentral 2019-05-06)
May 4, 2019 - What is Data Maturity?, Data Breaches: All Your Fault, and The Blast Radius of a Database (Database Weekly 2019/05/04)
May 3, 2019 - The Difference Between Rollup and Cube (SQLServerCentral 2019-05-03)
May 2, 2019 - A Self-Serve System to Refresh Databases – Part 1 (SQLServerCentral 2019-05-02)
May 1, 2019 - Stairway to SSAS Tabular Level 6: Creating Meaningful Measures (SQLServerCentral 2019-05-01)
April 30, 2019 - Build an OLAP Cube in SSAS using an ADO.NET Data Provider (SQLServerCentral 2019-04-30)
April 29, 2019 - Dos and Don’ts of Dynamic SQL (SQLServerCentral 2019-04-29)
April 27, 2019 - SQL Server 2019 CTP 2.5 Is Out! (Database Weekly 2019-04-27)
April 26, 2019 - Hidden Formatting Troubles with STR() (SQL Spackle) (SQLServerCentral - 2019-04-26)
April 25, 2019 - Using Backup Encryption with an External Certificate (SQLServerCentral 2019-04-25)
April 24, 2019 - Stairway to SQL Server Security Level 5: Schemas and Security (SQLServerCentral 2019-04-24)
April 23, 2019 - Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS (SQLServerCentral 2019-04-23)
April 22, 2019 - Service Broker Part 2: Why Service Broker (SQLServerCentral 2019-04-22)
April 20, 2019 - Implicit Conversions; Single Sign-On in Azure (Database Weekly 2019-04-20)
April 19, 2019 - Group Islands of Contiguous Dates (SQL Spackle) (SQLServerCentral 2019-04-19)
April 18, 2019 - A Quick Start to Running Python Code in SQL Server (SQLServerCentral 2019-04-18)
April 17, 2019 - Stairway to AlwaysOn Level 6: Analyse and Deploy an AlwaysOn Availability Group (SQLServerCentral 2019-04-17)
April 16, 2019 - Create Table DDL via TSQL (SQLServerCentral 2019-04-16)
April 15, 2019 - The Canine Corgi Completion Contest (SQLServerCentral 2019-04-15)
April 13, 2019 - How to Fix Databases with High VLF Count (Database Weekly 2019-04-13)
April 12, 2019 - Sorting Months By Number (SQLServerCentral 2019-04-12)
April 11, 2019 - Using Notebooks in Azure Data Studio (SQLServerCentral 2019-04-11)
April 10, 2019 - Turning Data On Its Side Using PIVOT Operator (SQLServerCentral 2019-04-10)
April 9, 2019 - More On Column Order Indexes – Part 2 (SQLServerCentral 2019-04-09)
April 8, 2019 - A tour of the Execute Package Task (SQLserverCentral 2019-04-08)
April 6, 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 5, 2019 - Calculating Elapsed Times (SQLServerCentral 2019-04-05)
April 4, 2019 - Creating a comma-separated list (SQLServerCentral 2019-04-04)
April 3, 2019 - Stairway to Database Design Level 6: Procedure Bodies (SQLServerCentral 3 Apr 2019)
April 2, 2019 - Reaping the benefits of the Window functions in T-SQL (SQLServerCentral 04/02/2019)
April 1, 2019 - SQL Server 2019 Adds CosmosDB Support (SQLServerCentral 04/01/2019)
March 30, 2019 - Containers Are The Present, Not the Future, Get Back to Basics, and a Brief History of Machine Learning (Database Weekly 3/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