Newsletter Archive

May 17, 2025 - Shadow AI, SQL Server Agent Jobs and PostgreSQL 18 is GA! (2025-05-17)
May 16, 2025 - ow to Safely Remove a SQL Server Data File Without Downtime (2025-05-16)
May 14, 2025 - Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture (2025-05-14)
May 10, 2025 - Are you right about databases? This newsletter will get you started!
May 9, 2025 - Date and Time Calculations Made Easy with EOMONTH, DATEDIFF, and DATEADD (2025-05-09)
May 7, 2025 - Level 6 of the Stairway to Synapse Analytics: Dedicated SQL Pool (2025-05-07)
May 5, 2025 - Understanding MERGE to Insert, Update, and Delete Data Simultaneously (2025-05-05)
May 3, 2025 - Security is Hot This Week
May 2, 2025 - Modern Streaming Architecture Serverless Pool with Spark Streaming
April 30, 2025 - Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview (2025-04-30)
April 28, 2025 - Is SQL Server Feature Complete? (2025-04-28)
April 26, 2025 - Very Interesting Professional Development Articles Plus Database Fundamentals
April 25, 2025 - Retrieving Data Using the REST API in Data API Builder (2025-04-25)
April 23, 2025 - Stairway to ColumnStore Indexes Level 7: Optimizing Nonclustered Columnstore Indexes (2025-04-23)
April 21, 2025 - Understanding CROSS APPLY and OUTER APPLY in SQL Server (2025-04-21)
April 18, 2025 - The Subtle Differences Between COALESCE and ISNULL (2025-04-18)
April 16, 2025 - Metadata Driven Pipelines (Full Load): The Fabric Modern Data Platform (2025-04-16)
April 14, 2025 - Creating a Date Dimension (Calendar Table) in SQL Server (2025-04-14)
April 12, 2025 - Two Events, Two Worlds and Tuning Triggers in Database Weekly (2025-04-12)
April 11, 2025 - Elements of the SQL Server Update Statement (2025-04-11)
April 9, 2025 - Level 5 of the Stairway to Synapse Analytics: create and use Delta Lake - Part 2 (2025-04-09)
April 7, 2025 - Understanding UNION and UNION ALL in SQL Server (2025-04-07)
April 5, 2025 - Whether you feel old or young, something for any database professional!
April 4, 2025 - Windows Clustered MSDTC and SQL Server 2019 mishap (2025-04-04)
April 2, 2025 - Create Raw Zone Tables using Generative AI: Data Engineering with Fabric (2025-04-02)
March 31, 2025 - DeepSeek: What is new with this AI technology? (2025-03-31)
March 30, 2025 - Fantasy baseball and old habits (DBW 2025-03-29)
March 28, 2025 - Implementing Fuzzy Search in SQL Server Using New Inbuilt Functions (2025-03-28)
March 26, 2025 - Improving the Performance of UPDATE Statements in SQL Server (2025-03-26)
March 24, 2025 - Dynamic T-SQL Script Parameterization Using Python (2025-03-24)
March 22, 2025 - Animated Film Fun
March 21, 2025 - Fabric Analytics for SQL folks: Part 1 - Fabric demystified (2025-03-21)
March 19, 2025 - Understanding SQL Server LEFT_SHIFT and RIGHT_SHIFT Functions (2025-03-19)
March 17, 2025 - Pitfalls to avoid while feeding events into CrowdStrike (2025-03-17)
March 15, 2025 - AI in SQL Server 2025: Embeddings (DBW 2025-03-15)
March 14, 2025 - Using SQL Server Stored Procedures with the Django ORM (2024-03-14)
March 12, 2025 - How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment (2025-03-12)
March 10, 2025 - Deploy DACPAC to Azure SQL Database using Visual Studio (2025-03-10)
March 8, 2025 - Shadow AI and Data Leak Risk, SQL Server Diagnostic Info Queries, DP-700 Exam and More in Database Weekly(2025-03-08)
March 7, 2025 - How to Download and Restore AdventureWorks 2019 Database (2025-03-07)
March 5, 2025 - Understanding the Logical Functions IIF and Choose in SQL Server 2022 (2025-03-05)
March 3, 2025 - Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions (2025-03-03)
March 1, 2025 - Time is our most valuable resource, reading this newsletter is worth every second.
February 28, 2025 - How to Download and Restore AdventureWorks 2022 Database (2024-02-28)
February 26, 2025 - Why use Tally Tables in the Fabric Warehouse? Data Engineering in Fabric (2024-02-26)
February 24, 2025 - How to use the Azure Emulator to create blob containers, queues and tables (2024-02-24)
February 22, 2025 - A Trigger... just not that kind
February 21, 2025 - Configuring Maintenance Plans in SQL Server (2024-02-21)
February 19, 2025 - How to Resolve SQL Server Database Stuck in Recovery Pending State (2025-02-19)
February 17, 2025 - Understanding Bit Manipulation Functions: BIT_COUNT, GET_BIT, and SET_BIT in SQL Server 2022 (2024-02-17)
February 15, 2025 - Lots Going on in Tech This Week
February 14, 2025 - Implementing Vector Datatype with Azure SQL Server (2024-02-14)
February 12, 2025 - How to Develop Solutions with Fabric Data Warehouse: Data Engineering with Fabric (2024-02-12)
February 10, 2025 - SQL Database Project in Azure Data Studio (2025-02-10)
February 8, 2025 - SQL Endpoint Secrets you need to know (DBW 2024-02-08)
February 7, 2025 - Understanding Data Type Conversion Functions in SQL Server with PARSE, TRY_PARSE, and TRY_CONVERT (2025-02-07)
February 5, 2025 - Why you should avoid Implicit Measures in your Power BI model (2025-02-05)
February 3, 2025 - An Effective Approach for High Volume Data in Azure Synapse (2024-02-03)
February 1, 2025 - Dynamic Executions of Fabric Pipelines and the Pain of SQL Cursors (2025-02-01)
January 31, 2025 - JSON in Microsoft SQL Server: A Comprehensive Guide (2025-01-31)
January 29, 2025 - Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide (2024-01-29)
January 27, 2025 - Attaching Multiple SQL Server Databases with DBCC CHECKPRIMARYFILE (2024-01-27)
January 25, 2025 - Pain behavior, followed by solutions to your technical pains
January 24, 2025 - Boosting Data Accuracy: Resolving Common Data Quality Issues Using SQL (2024-01-24)
January 22, 2025 - Why Standards are Important (2024-01-22)
January 20, 2025 - Influencing a Local AI (2024-01-20)
January 17, 2025 - Vector DB implementation using FAISS (2024-01-17)
January 15, 2025 - Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases (2024-01-15)
January 13, 2025 - How to Avoid Incorrect Results When Using T-SQL Trigonometric Functions in SQL Server (2024-01-13)
January 11, 2025 - Hardware News Kicks Off in the New Year
January 10, 2025 - Resolving Access Denied Errors During SQL Server Database Attachment (2024-01-10)
January 8, 2025 - How to Load a Fabric Warehouse: Data Engineering with Fabric (2025-01-08)
January 6, 2025 - Why you should avoid Implicit Measures in your Power BI model (2025-01-06)
January 4, 2025 - 11 Ways to Spot AI-Generated Text (2025-01-04 DBW)
January 3, 2025 - Leveraging the “STUFF” Function for Enhanced Data Representation and String Manipulation (2025-01-03)
January 1, 2025 - DAX For SQL Folks: Part I- Intro to DAX, Power BI and Data Viz (2025-01-01)
December 30, 2024 - How to Attach and Detach Databases in SQL Server (2024-12-30)
December 28, 2024 - Subscribing instead of resolving, plus enough articles to keep you going until next year!
December 27, 2024 - How to Repair Corrupt MySQL Tables (2024-12-27)
December 25, 2024 - Merry Christmas and Cleaning Up Dimensions (2024-12-25)
December 23, 2024 - Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio. (2024-12-23)
December 20, 2024 - Connecting Streamlit to Upload Data to Snowflake (2024-12-20)
December 18, 2024 - Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake (2024-12-18)
December 16, 2024 - Feed SQL Server logs into SIEM (2024-12-16)
December 14, 2024 - Starting Some of Those Year-End Roundups
December 13, 2024 - Getting Started with the Data API Builder (2024-12-13)
December 11, 2024 - Virtualizing GCP data by using Fabric Shortcuts: Data Engineering with Fabric (2024-12-11)
December 9, 2024 - The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner (2024-12-09)
December 7, 2024 - Your AI clone could target your family, but there’s a simple defense (2024-12-07 DBW)
December 6, 2024 - JSON in PostgreSQL (2024-12-06)
December 4, 2024 - Stairway to SSAS Tabular Level 4: Implementing Date Dimensions (2024-12-04)
December 2, 2024 - An introduction to Terraform (2024-12-02)
November 30, 2024 - Anything is possible, if you put your mind to it. Like reading all of these blogs!
November 29, 2024 - Improving Performance for Some LIKE “%string%” Searches (SQL Spackle) (2024-11-29)
November 27, 2024 - Simplify Data Loading with Fivetran (HVR): Data Engineering with Fabric (2024-11-27)
November 25, 2024 - A First Look at SSMS 21 (2024-11-25)
November 23, 2024 - Giving Thanks (DBW 2024-11-23)
November 22, 2024 - Announcing SQL Server 2025 (2024-11-22)
November 20, 2024 - Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code (20204-11-20)
November 18, 2024 - How to Develop Custom T-SQL Code Snippets in Azure Data Studio (2024-11-18)
November 16, 2024 - The One With All the Hardware
November 15, 2024 - The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle) (2024-11-18)
November 13, 2024 - Ingesting Data From REST API endpoints: Data Engineering with Fabric (2024-11-13)
November 11, 2024 - A Tidy Database is a Fast Database: Why Index Management Matters (2024-11-11)
November 8, 2024 - Step by step guide to setup PostgreSQL on Docker (2024-11-08)
November 6, 2024 - Stairway to SSAS Tabular Level 3: Creating a Tabular Project (2024-11-06)
November 4, 2024 - Your Personal ChatGPT Tutorial (2024-11-04)
November 2, 2024 - PASS Summit, AI, Admin, Fabric, Snicker Bars, and So Much More!
November 1, 2024 - A Guide to SQL Security in Django (2024-11-01)
October 30, 2024 - Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric (2024-10-30)
October 28, 2024 - Leveraging SQL Transaction Control in Python Applications (2024-10-28)
October 25, 2024 - Returning 0's in a SUM (SQL Spackle) (2024-10-25)
October 23, 2024 - Stairway to Snowflake Level 4 - Introducing Snowsight, Snowflake’s Web UI (2024-10-23)
October 21, 2024 - The GitHub Web Platform (2024-10-21)
October 19, 2024 - Are We Dinosaurs?
October 18, 2024 - Outer Join – What am I missing (SQL Spackle) (2024-10-18)
October 16, 2024 - Use Logic Apps To Save Money In Azure: Data Engineering in Fabric (2024-10-16)
October 14, 2024 - Enhancing SQL Server Searches with Elasticsearch and Python (2024-10-14)
October 12, 2024 - Are Tesla’s robot prototypes AI marvels or remote-controlled toys? (2024-10-12 DBW)
October 11, 2024 - Adding new files to a log-shipped database (SQL Spackle) (2024-10-11)
October 9, 2024 - Removing TDE from a Database: Level 4 of the Stairway to TDE (2024-10-09)
October 7, 2024 - How to Delete Large Amounts of Data in Microsoft SQL Server (2024-10-07)
October 5, 2024 - Technology news I'd probably be too shy to give you in person!
October 4, 2024 - Display More Than 8000 Characters (SQL Spackle) (2024-10-04)
October 2, 2024 - Exploring Time Travel and Row Level Concurrency: Data Engineering with Fabric (2024-10-02)
September 30, 2024 - Converting Old Running Total Code to Window Functions (2024-09-30)
September 28, 2024 - Unstuck (DBW 2024-09-28)
September 27, 2024 - Diving Deeper into the Import Extension in Azure Data Studio (2024-09-27)
September 21, 2024 - A Jumble of Letters With A Purpose
September 20, 2024 - Calculating Elapsed Times (SQL Spackle) (2024-09-20)
September 18, 2024 - Level 3 of the Stairway to Synapse Analytics: Analyze Data Using a Spark Pool (2024-09-18)
September 16, 2024 - How to Add a New Shared Disk to a WSFC as a SQL Resource (2024-09-16)
September 14, 2024 - In Memory Table Variables In SQL Server: Still Pretty Stupid (DBW 2024-09-14)
September 13, 2024 - The Mastering Azure Data Studio Series (2024-09-13)
September 11, 2024 - Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric (2024-09-11)
September 9, 2024 - GitHub Desktop Tutorial (2024-09-09)
September 7, 2024 - Helping you know what you don't know about data technology
September 6, 2024 - Using Containers to Avoid Installing SQL Server (2024-09-06)
September 4, 2024 - Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index (2024-09-04)
September 2, 2024 - How to Recover a Corrupted Azure Data Factory Integration Runtime (2024-09-02)
August 31, 2024 - It's Time to Play (DBW 2024-08-31)
August 30, 2024 - How to Delete Large Amounts of Data (2024-08-30)
August 28, 2024 - Stairway to Database Containers Level 4: Using a Docker Compose File (2024-08-28)
August 26, 2024 - Big Northwind with AI (2024-08-26)
August 24, 2024 - Tech For Certain, but a Lot of Professional Development Too
August 23, 2024 - Iteration and Conditional Activities in Azure Data Factory (2024-08-23)
August 21, 2024 - A New and Improved Data Warehouse: Data Engineering with Fabric (2024-08-21)
August 19, 2024 - Data Prediction with SQL Server Machine Learning Services, Python, and Linear Regression (2024-08-19)
August 17, 2024 - PowerShell and AI: Create a Microsoft Word Copilot (2024-08-17 DBW)
August 16, 2024 - Recover a Database from Suspect Mode Step by Step (2024-08-16)
August 14, 2024 - Level 2 of the Stairway to Synapse Analytics: Analyze Data in Storage Account using the Serverless SQL pool (2024-08-12)
August 12, 2024 - Hiring in IT and Relevance of Domain Experience (2024-08-12)
August 10, 2024 - Links to help you keep your systems fit, personal fitness is up to you.
August 9, 2024 - Creating a Comma-Separated List (2024-08-09)
August 7, 2024 - Choosing a File Format - Data Engineering with Fabric (2024-08-07)
August 5, 2024 - Git, GitHub and Visual Studio Code for SQL Server (2024-08-05)
August 4, 2024 - What Sport Would You Play? (DBW 2024-08-04)
August 2, 2024 - Displaying Sorted Hierarchies (SQL Spackle) (2024-08-02)
July 31, 2024 - Using Registered Servers in SSMS (2024-07-31)
July 29, 2024 - Getting Started With Azure Cosmos DB for PostgreSQL (2024-07-29)
July 27, 2024 - You Know We're Going to Talk About Crowdstrike
July 26, 2024 - An Alternative (Better?) Method to UNPIVOT (SQL Spackle) (2024-07-26
July 24, 2024 - Stairway to Always On Level 1: What is "SQL Server Always On"?
July 22, 2024 - How to use Jupyter Notebook in VSCode (2024-07-22)
July 20, 2024 - Planes, Trains, and Automobiles (DBW 2024-07-20)
July 19, 2024 - Notebook Jobs in Azure Data Studio (2024-07-19)
July 17, 2024 - Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE (2024-07-17)
July 15, 2024 - Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation (2024-07-15)
July 13, 2024 - Does safety make you too comfortable? That and lots of advice from past people to future others!
July 12, 2024 - Streaming Event Data through RabbitMQ to a Microsoft Fabric Eventstream (2024-07-12)
July 10, 2024 - Manage OneLake Storage With PowerShell - Data Engineering with Fabric (2024-07-10)
July 8, 2024 - Meet the new Google AI Assistant Gemini (2024-06-08)
July 6, 2024 - Query Store Keeps Switching Itself Off, Getting it Moving Again (2024-07-06 DBW)
July 5, 2024 - How much Space can I expect to recover from a rebuild after dropping a column? (2024-07-05)
July 1, 2024 - Getting Your DBA Teams Scripts into Git (2024-07-01)
June 29, 2024 - Sprinkling Powershell On It
June 28, 2024 - Set up a Windows Server Fail-over Clusters (2024-06-28)
June 26, 2024 - Control OneLake with Storage Explorer – Data Engineering with Fabric (2024-06-26)
June 24, 2024 - How to Rename a Column in SQL Server (2024-06-24)
June 21, 2024 - How I Used PostgreSQL RLS To Avoid Code Changes During a Migration (2024-06-21)
June 19, 2024 - Unzipping Word Documents in T-SQL (2024-06-19)
June 17, 2024 - Working with SQL Server in Visual Studio Code (2024-06-17)
June 15, 2024 - Baseball Everywhere (DBW 2024-06-15)
June 14, 2024 - Fine-grained Access Control for Stored Procedures (2024-06-14)
June 12, 2024 - Memory Grant Feedback Persistence in SQL Server 2022 (2024-06-12)
June 10, 2024 - How to Set Up Microsoft Fabric Database Mirroring for Azure Cosmos DB (2024-06-10)
June 8, 2024 - This week's advice for attaining perfect software (and what to do when you can't!)
June 7, 2024 - Identify Tables With Dropped Columns (2024-06-07)
June 5, 2024 - Basic Always On Availability Groups in SQL Server Standard (2024-06-05)
June 3, 2024 - Bridging Snowflake and Azure Data Stack: A Step-by-Step Guide (2024-06-03)
June 1, 2024 - Let's Talk Expertise
May 31, 2024 - PostgreSQL UNION, INTERCEPT & EXCEPT Operator (2024-05-31)
May 29, 2024 - Enhancing Web Application Performance through Database Optimization (2024-05-29)
May 27, 2024 - What is new in Copilot, the new features available (2024-05-27)
May 24, 2024 - Manage Elastic jobs in Azure using Azure Elastic Jobs Manager (2024-05-24)
May 22, 2024 - Empowering Lakehouse Users – Data Engineering with Fabric (2024-05-22)
May 20, 2024 - How Big Data Supports Gen AI (2024-05-20)
May 18, 2024 - My Predictive Analysis Says You Will Love This Newsletter
May 17, 2024 - Managing SQL Agent in Azure Data Studio (2024-05-17)
May 15, 2024 - Combining Silver Tables into a Model – Data Engineering with Fabric (2024-05-15)
May 13, 2024 - Using Machine Learning Pipeline Execution Activity in Azure Data Factory (2024-05-13)
May 12, 2024 - Honeybee Swarms (DBW 2024-05-11)
May 10, 2024 - Identifying Customer Buying Pattern in Power BI - Part 2 (2024-05-10)
May 8, 2024 - Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining (2024-05-08)
May 6, 2024 - Ingest and Retrieve data from an ADX Cluster Using Python (2024-05-06)
May 4, 2024 - A Lot of Interesting Theory This Week
May 3, 2024 - Database Dashboards in Azure Data Studio (2024-05-03)
May 1, 2024 - Metadata Driven Pipelines – Data Engineering with Fabric (2024-05-01)
April 29, 2024 - Exporting and Importing Registered Servers in SSMS (2024-04-29)
April 27, 2024 - Plenty of Performance, Power, and Foreign Keys
April 26, 2024 - What happens when we drop a column on a SQL Server table? Where's my space? (2024-04-26)
April 24, 2024 - Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator (2024-04-24)
April 22, 2024 - Unlocking Power with Updatable Views in SQL Server (2024-04-22)
April 20, 2024 - What are you listening to as you are reading this week’s Database Weekly newsletter?
April 19, 2024 - Identifying Customer Buying Pattern in Power BI - Part 1 (2024-04-19)
April 17, 2024 - Full vs. Incremental Loads – Data Engineering with Fabric (2024-04-17)
April 15, 2024 - Disaster Recovery and High Availability Solutions in SQL Server (2024-04-15)
April 13, 2024 - There's No Free Lunch - Even with Open-source Software
April 12, 2024 - Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts (2024-04-12)
April 10, 2024 - Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors (2024-04-10)
April 8, 2024 - Joining Queries in Azure Data Factory on Cosmos DB Sources (2024-04-08)
April 6, 2024 - Nuclear Energy is Back!
April 5, 2024 - SQL Server Patching Using PowerShell DSC (2024-04-05)
April 3, 2024 - Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs) (2024-04-03)
April 1, 2024 - Custom Statistics Distributions in SQL Server 2022 (2024-04-01)
March 31, 2024 - Database Mirroring is Back in Azure SQL Database (2024-03-31 DBW)
March 29, 2024 - Check Azure SQL DB Space Used (2024-03-29)
March 27, 2024 - Managing Files and Folders with Python – Data Engineering with Fabric (2024-03-27)
March 25, 2024 - Quick and Effective Migration Between CosmosDB Collections Using ADF (2024-03-25)
March 23, 2024 - Auto Renew Subscriptions (2024-03-23 DBW)
March 22, 2024 - How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer (2024-03-22)
March 20, 2024 - Managed Vs Unmanaged Tables – Data Engineering with Fabric (2024-03-20)
March 18, 2024 - Find Unused or Backup Tables (2024-03-18)
March 18, 2024 - Give it Away (DBW 2024-03-17)
March 15, 2024 - The difference between BIN2 and Case-Sensitive collations in SQL (2024-03-15)
March 13, 2024 - Stairway to Advanced T-SQL Level 2: Using the APPLY Operator (2024-03-13)
March 11, 2024 - A Little Late, But We're Here
March 11, 2024 - Will AI end with SQL, Is this the end of SQL? (2024-03-11)
March 8, 2024 - Power BI Auto Detect Relationship Failure (2024-03-08)
March 6, 2024 - Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN (2024-03-06)
March 4, 2024 - Evolving Role of Data Professionals in Artificial Intelligence Era (2024-03-04)
March 2, 2024 - Faster Database Recovery with Piecemeal Restores (2024-03-02 DBW)
March 1, 2024 - A Few Best Practices for Strong SQL Server Security (2024-03-01)
February 28, 2024 - Moving Dynamic Data Masked Data to New Locations - Step 5 of the Stairway to Dynamic Data Masking (2024-02-28)
February 26, 2024 - Meet Claude, the new AI (2024-02-26)
February 24, 2024 - Software Updates, Outages, Processes, and Protocols (DBW 2024-02-24)
February 23, 2024 - What Every DBA Should Know about Always On Readable Secondaries (2024-02-23)
February 21, 2024 - Forget the Models, Your Data is the Secret Sauce for Generative AI (2024-02-21)
February 19, 2024 - An Introduction to Flowlets in Azure Data Factory (2024-02-19)
February 17, 2024 - Learning Never Gets Old (DBW 2024-02-17)
February 16, 2024 - JQ - Tool for Querying JSON documents using the CLI (2024-02-16)
February 14, 2024 - Attention SQLBits 2024 Attendees! (2024-02-14)
February 12, 2024 - Writing SQL Server code with AI using GitHub Copilot (2024-02-12)
February 10, 2024 - Testing, Testing, Testing. Is This Thing On?
February 9, 2024 - Use a Table Variable for Logging Entries that Need to Survive Rollbacks (2024-02-09)
February 7, 2024 - Dimensional Modeling Case Study Part 2 - Days Dimension (2024-02-07)
February 5, 2024 - Announcing the first Microsoft Fabric Community Conference! (2024-02-05)
February 3, 2024 - Troubleshooting SQL Server Queries using Actual Execution Plans (2024-02-03 DBW)
February 2, 2024 - Deploying Azure SQL Database Using an ARM Template (2024-02-02)
January 31, 2024 - Install SSMS using Powershell DSC (2024-01-31)
January 29, 2024 - Server Dashboards in Azure Data Studio (2024-01-29)
January 27, 2024 - Sharing, Tuning, Pivoting, and Fabric; All In One Handy Newsletter
January 26, 2024 - Django's ORM vs. Raw SQL: When to Use Which (2024-01-26)
January 24, 2024 - Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions (2024-01-24)
January 22, 2024 - Configuration of Azure SQL Database Auditing (2024-01-22)
January 20, 2024 - The Voice of the Customer (2024-01-20 DBW)
January 19, 2024 - Leveraging AI Tools for SQL Queries (2024-01-19)
January 17, 2024 - Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module (2024-01-17)
January 15, 2024 - A Simple Method to Load Excel Data (2024-01-15)
January 13, 2024 - Development: Professional, Software and Database
January 12, 2024 - Dimensional Modelling Case Study Part 1 - Age Group (2024-01-12)
January 10, 2024 - An In-Depth Look at MIXED_PAGE_ALLOCATION and Changes in Page Allocation (2024-01-10)
January 8, 2024 - Machine learning K-Means applied to SQL Server data (2024-01-08)
January 6, 2024 - Has AI Changed Software Development? (2024-01-06 DBW)
January 5, 2024 - Dijkstra's Algorithm (2024-01-05)
January 3, 2024 - SQL Window Functions Series: NTILE() (2024-01-03)
January 1, 2024 - Minimal Downtime Storage Migration of Large Databases (2024-01-01)
December 30, 2023 - Resolutions and a big helping of T-SQL
December 29, 2023 - The Profiler Extension in Azure Data Studio (ADS) (2023-12-29)
December 27, 2023 - Understanding Maximum Server Memory in SQL SERVER (2023-12-27)
December 25, 2023 - Monitor SQL Server Error Logs with PowerShell (2023-12-25)
December 23, 2023 - A Thrill of Hope (DBW 2023-12-23)
December 22, 2023 - Creating a Hyperscale Database in Azure Using the Azure Portal (2023-12-22)
December 20, 2023 - Why Don't You Upgrade in Place? (2023-12-20)
December 18, 2023 - Configuring an SSIS ForEach Loop for Multiple File Types (2023-12-18)
December 16, 2023 - Community, Community, Community
December 15, 2023 - Searching an Encrypted Column (2023-12-15)
December 13, 2023 - Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases (2023-12-13)
December 11, 2023 - SQL Window Functions Series: LAG() and LEAD() (2023-12-11)
December 9, 2023 - Community and T-SQL Coding Love Abounds
December 8, 2023 - Window Function Basics - PARTITION BY (2023-12-08)
December 6, 2023 - Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (2023-12-6)
December 4, 2023 - GitHub Copilot - Our Best Ally to for T-SQL (2023-12-04)
December 2, 2023 - Generative AI in the Enterprise (2023-12-02 DBW)
December 1, 2023 - Getting Started with DDL statements of Cassandra Query Language (2023-12-01)
November 29, 2023 - Using the Import Extension in Azure Data Studio (2023-11-29)
November 27, 2023 - Ensuring a Single Row Table (2023-11-27)
November 25, 2023 - Inspiration, memories, and a big helping of T-SQL
November 24, 2023 - Comparing Two Execution Plans (2023-11-24)
November 22, 2023 - Advanced SQL Server installation using PowerShell DSC (2023-11-22)
November 20, 2023 - Sentiment Analysis with AI (2023-11-20)
November 18, 2023 - You Never Know
November 17, 2023 - Scheduling SQL Agent Jobs on Alternating Weeks (2023-11-17)
November 15, 2023 - How to join the free PASS Data Community Summit Livestream from around the world (2023-11-15)
November 13, 2023 - Azure Data Studio - A First Look (2023-11-13)
November 11, 2023 - How SQL Server Indexes Store Data (2023-11-11 DBW)
November 10, 2023 - The PASS Data Community Summit First Timer Guide (2023-11-10)
November 8, 2023 - The Basics of Dynamic Data Masking - Step 1 of the Stairway to Dynamic Data Masking (2023-11-08)
November 6, 2023 - SQL Server and Python Tutorial (2023-11-06)
November 4, 2023 - A newsletter by any other name, zielschmerz, and more
November 3, 2023 - Efficient Table Migration to a New Schema in T-SQL (2023-11-03)
November 1, 2023 - Using Pipeline Return Value in Azure Data Factory and Azure Synapse Analytics (2023-11-01)
October 30, 2023 - Batch Execution Mode on a Rowstore in SQL Server 2022 (2023-10-30)
October 28, 2023 - Learning with Sample Data (DBW 2023-10-23)
October 27, 2023 - Trigger the Execution of an ADF Pipeline from an Email (2023-10-27)
October 25, 2023 - Stairway to Database DevOps Level 3: Managing Code as a Team in Git (2023-10-25)
October 23, 2023 - Transform your Winning team into a Champion Team (2023-10-23)
October 21, 2023 - Heap Praise On Others
October 20, 2023 - What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples (2023-10-20)
October 20, 2023 - What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples (2023-10-20)
October 18, 2023 - Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control (2023-10-18)
October 16, 2023 - GIT Configuration and Automated Release for Azure Data Factory (2023-10-16)
October 14, 2023 - SQL Server Patch Week (2023-10-14 DBW)
October 13, 2023 - The SQL Developer Experience: Beyond RDBMS (2023-10-13)
October 11, 2023 - Parsing a Pairs of Values in a String While Preserving Order (2023-10-11)
October 9, 2023 - The Basics of Using GENERATE_SERIES() (2023-10-09)
October 7, 2023 - Confidently verified for you, Bad Data, First Normal Form, Fabric, and so much more
October 6, 2023 - Using SQLite with Flutter (2023-10-06)
October 4, 2023 - Idempotent DDL Scripts That Always Achieve The Same Result - Making Changes Only Once: Stairway to Exploring Database Metadata Level 6 (2023-10-04)
October 2, 2023 - Sentiment Analysis with IA (2023-10-02)
September 30, 2023 - Community at PASS Summit (DBW 2023-09-30)
September 29, 2023 - Sending Multiple Attachments in Email from Azure Data Factory Pipeline (2023-09-29)
September 27, 2023 - Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions (2023-09-27)
September 25, 2023 - Restore With Standby; A Review and A Lesson Learned (2023-09-25)
September 23, 2023 - A Whole Lot of Professional Development Going On
September 22, 2023 - How Would You Design This: Scheduling Classes (2023-09-22)
September 20, 2023 - How Effective Is Your Data Load Monitoring in SQL and Python? (2023-09-20)
September 18, 2023 - GENERATE_SERIES() Breaks Minimal Logging (2023-09-18)
September 18, 2023 - GENERATE_SERIES() Breaks Minimal Logging (2023-09-18)
September 16, 2023 - “Oops, I Lost My Indexes in Azure SQL DB.” (2023-09-16 DBW)
September 15, 2023 - Backup and Restore SQL Database to Azure Blob Storage (2023-09-15)
September 13, 2023 - Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps (2023-09-13)
September 11, 2023 - How to create a SQL Server presentation in 5 minutes using AI (2023-09-11)
September 9, 2023 - The Impact of Small Changes (2023-09-09 DBW)
September 8, 2023 - How to Use SQL to Analyze the Bitcoin Blockchain (2023-09-08)
September 6, 2023 - A Brief Introduction to PowerShellAI, an Intelligent Command-line (2023-09-06)
September 4, 2023 - Optimized Plan Forcing with Query Store in SQL Server 2022 (2023-09-04)
September 2, 2023 - A Season of Reflection (2023-09-02 DBW)
September 1, 2023 - Export and Import SSISDB in just a few clicks (2023-09-01)
August 30, 2023 - Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions (2023-08-30)
August 28, 2023 - How to export data to SQL Server using Bard (Google chatbot) (2023-08-23)
August 26, 2023 - An Eclectic Mix of Topics And Some Prepping
August 25, 2023 - Spot the Five Differences and Win a Summit Ticket (2023-08-25)
August 23, 2023 - Level 24: Time Intelligence – Dates Functions: The DAX OPENINGBALANCE*() Functions (2023-08-23)
August 21, 2023 - Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization (2023-08-21)
August 19, 2023 - Unleashing SQL Sorcery: Increasing Performance and Complexity with GitHub Copilot (2023-08-19 DBW)
August 18, 2023 - A LEFT OUTER JOIN in SQL: What Is It? (2023-08-18)
August 16, 2023 - Managing Change (2023-08-16)
August 14, 2023 - Bing vs Bard (Chatbot wars) (2023-08-14)
August 12, 2023 - Minding your manners, Database Job Titles, and so much more
August 11, 2023 - How Would You Design This: Tracking Travels (2023-08-11)
August 9, 2023 - Upserts in Amazon Redshift (2023-08-09)
August 7, 2023 - Combine DATE and TIME to DATETIME2 in SQL Server (2023-08-07)
August 5, 2023 - Small Changes, Big Results (DBW 2023-08-05)
August 4, 2023 - AutomatedLab - A Quickstart for Deploying SQL Server Labs on Windows (2023-08-04)
August 2, 2023 - Create Your First Pipeline in Microsoft Fabric (2023-08-02)
July 31, 2023 - How to Change the SQL Server Database Owner (2023-07-31)
July 29, 2023 - A Whole Lot of Data Analysis To Talk About
July 28, 2023 - The Hidden Impact of Microsoft Defender for Azure SQL (2023-07-28)
July 26, 2023 - What is OneLake in Microsoft Fabric? (2023-07-26)
July 24, 2023 - A Overview of Amazon Redshift (2023-07-24)
July 22, 2023 - 7 Essential Factors for a Successful Cloud Migration (2023-07-22)
July 21, 2023 - Exploring Parameter Sensitive Plan Optimization in SQL Server 2022 (2023-07-21)
July 19, 2023 - Stairway to DAX and Power BI - Level 23: Time Intelligence – Dates Functions: The DAX PREVIOUS() Functions (2023-07-19)
July 17, 2023 - Building a Database Dashboard with SSRS (2023-07-17)
July 15, 2023 - Reaonable Resumes, Code that gives you the feels, T-SQL, Fabric and More
July 14, 2023 - Using Power BI to Analyze My Travels (2023-07-14)
July 12, 2023 - Let Your Data Do the Talking with PowerPoint Plus Power BI (2023-07-12)
July 10, 2023 - Get the Most Current Row From a Detail Table (2023-07-10)
July 8, 2023 - The Data Professional Social Graph (DBW 2023-07-08)
July 7, 2023 - Creating an Azure SQL Database Using Azure Cloud Shell (2023-07-07)
July 5, 2023 - Stairway to DAX and Power BI - Level 22: Time Intelligence – Dates Functions: The DAX NEXT() Functions (2023-07-05)
July 3, 2023 - Bard, Google’s ChatGPT Competitor (2023-07-03)
July 1, 2023 - A Pottpouri Of Tech News
June 30, 2023 - Unpivot Data Using Python (2023-06-30)
June 28, 2023 - How to Reduce the Need for Bookmarks Using Parameters in Power BI (2023-06-28)
June 26, 2023 - SQL Server Resumable Index Operations (2023-06-26)
June 24, 2023 - The Best Career Advice (2023-06-24 DBW)
June 23, 2023 - How to Find the SQL Server Version (2023-06-23)
June 21, 2023 - How to Avoid N+1 Queries: Comprehensive Guide and Python Code Examples (2023-06-21)
June 19, 2023 - Advantages of Kappa architecture in the Modern Data Stack (2023-06-19)
June 17, 2023 - Same Language, Different Words (DBW 2023-07-17)
June 16, 2023 - Horizontal Trees and Free Tools (2023-06-16)
June 14, 2023 - Calculating Prime Numbers With One Query (2023-06-14)
June 12, 2023 - T-SQL Scripts to generate the HTML-formatted database storage report (2023-06-12)
June 10, 2023 - Software Flexibility, Lots of Fabric, and much more!
June 9, 2023 - PostgreSQL Copy (2023-06-09)
June 7, 2023 - Analyze Data with a Serverless SQL pool in Azure Synapse Analytics (2023-06-07)
June 5, 2023 - Bing Chatbot vs ChatGPT (2023-06-05)
June 3, 2023 - The Word of the Week is Fabric
June 2, 2023 - MuleSoft Integration with Azure Key Vault (2023-06-02)
May 31, 2023 - Database Sequence Objects with dbatools (2023-05-31)
May 29, 2023 - Install SQL Server using Powershell Desired State Configuration (DSC) (2023-05-29)
May 27, 2023 - How Lakehouse Architecture is Revolutionizing Business Intelligence (2023-05-27 DBW)
May 26, 2023 - Microsoft Build Announcements for Data Professionals (2023-05-26)
May 24, 2023 - Using Azure Data Studio to Deploy a SQL Server VM on Azure (2023-05-24)
May 22, 2023 - How to Generate Images with AI and Store them in SQL Server using Python and DALL·E (2023-05-22)
May 20, 2023 - Empathetic Design, Decoding SQL Server Wait Resources, SQL Server 2022 Log Growth Strategy, and Much More
May 19, 2023 - Common Table Expression Basics (2023-05-19)
May 17, 2023 - Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty (2023-05-17)
May 15, 2023 - How to Improve Database Design to Speed Up SQL Queries (2023-05-15)
May 12, 2023 - How to Find the SQL Server Instance Startup Time (2023-05-12)
May 10, 2023 - How to Create a SQL Database on a New Drive in Ubuntu (2023-05-10)
May 8, 2023 - Add a Second NIC for an Availability Group to Separate Network Traffic (2023-05-08)
May 6, 2023 - Hardware Heavy
May 3, 2023 - Create an HTML Report on the Status of SQL Server Agent Jobs (2023-05-03)
May 1, 2023 - ChatGPT in Visual Studio tutorial (2023-05-01)
April 29, 2023 - How to Go Live on SQL Server 2022 (2023-04-29 DBW)
April 28, 2023 - Using the New Open Source SQLCMD to Create Containers (2023-04-28)
April 26, 2023 - Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica (2023-04-26)
April 24, 2023 - A Brief Introduction to PowerShellAI, an Intelligent Command-line (2023-04-24)
April 22, 2023 - ChatGPT vs. Watson Assistant (2023-04-22 DBW)
April 21, 2023 - Experimenting with Go-SQLCMD (2023-04-21)
April 19, 2023 - SQL Server 2012 AlwaysOn Groups and FCIs Part 4 (2023-04-19)
April 17, 2023 - Create an Empty Database Using SQL Server Integration Services (2023-04-17)
April 15, 2023 - Moore's Law: Navigating the Pace of Technological Change (DBW 2023-04-15)
April 14, 2023 - Data Oriented Cloud Security Mechanisms (2023-04-14)
April 12, 2023 - SQL Server 2012 AlwaysOn Groups and FCIs Part 3 (2023-04-12)
April 10, 2023 - How to work with ChatGPT in Visual Studio Code (2023-04-10)
April 8, 2023 - Good Career Advice
April 7, 2023 - Performance Tuning with SQLFacts Tools (2023-04-07)
April 5, 2023 - SQL Server 2012 AlwaysOn Groups and FCIs Part 2 (2023-04-05)
April 3, 2023 - Improving SQL Server Performance and Availability with Accelerated Database Recovery (2023-04-03)
April 1, 2023 - Has SQL Server Performance Improved? (2023-04-01 DBW)
March 31, 2023 - Shrink Database Log Files One by One (2023-03-31)
March 29, 2023 - SQL Server 2012 AlwaysOn Groups and FCIs Part 1 (2023-03-29)
March 27, 2023 - Passing parameters to query without TVFs (2023-03-27)
March 25, 2023 - Reviewing Early And Often, Monitoring, Branching, Junk Dims and so much more
March 24, 2023 - How to Connect SQL Server and Create C# Objects for Data Management (2023-03-24)
March 22, 2023 - Stairway to SQL PowerShell Level 9: Objects For Everyone (2023-03-22)
March 20, 2023 - ChatGPT and PowerShell – Some practical examples (2023-03-20)
March 18, 2023 - The Human Factor (03-18-2023 DBW)
March 17, 2023 - The Basics of PostgreSQL Views (2023-03-17)
March 15, 2023 - Stairway to SQL Server Security Level 9: Transparent Data Encryption (2023-03-15)
March 13, 2023 - Find Invalid Objects in SQL Server (2023-03-13)
March 11, 2023 - Where Does Your Inspiration Come From
March 10, 2023 - How to Implement CI/CD in Azure Data Factory (ADF) (2023-03-10)
March 8, 2023 - Stairway to SQL Server Security Level 11: Auditing (2023-03-08)
March 6, 2023 - ChatGPT in SQL Server - Practical examples (2023-03-06)
March 4, 2023 - The Top SQL Server Engine Errors (2023-03-04 DBW)
March 3, 2023 - Understanding Azure Synapse Analytics Pricing (2023-03-03)
March 1, 2023 - Stairway to DAX and Power BI - Level 21: Time Intelligence – Dates Functions: FIRSTDATE() and LASTDATE() (2023-03-01)
February 27, 2023 - How to Forecast Data in Power BI (2023-02-27)
February 25, 2023 - Sharing your Knowledge, SQL Server updates, and more (DBW 2023-02-24)
February 24, 2023 - An Overview of PostgreSQL Window Functions (2023-02-24)
February 22, 2023 - Azure Automation With Visual Studio Code (2023-02-22)
February 20, 2023 - How To Avoid MERGE in SQL Server (2023-02-20)
February 18, 2023 - With the Rise of AI Chat, Are Experts Still Needed? (DBW 2023-02-18)
February 17, 2023 - PostgreSQL Temporary Table (2023-02-17)
February 15, 2023 - A Simple Tutorial for DML Triggers (2023-02-15)
February 13, 2023 - What is ChatGPT – Is it the rise of the Skynet era? (2023-02-13)
February 11, 2023 - Mary Queen of Scotts and Security
February 8, 2023 - A Version Control Strategy for Branch-based Database Development (2023-02-08)
February 6, 2023 - Schedule Jobs on a Clustered SQL Server (2023-02-06)
February 4, 2023 - Coding Magic Values (2023-02-04 DBW)
February 3, 2023 - Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL (2023-02-03)
February 1, 2023 - The Data Fabric – Future of Data Management (2023-02-01)
January 30, 2023 - Backup Directly to a GCS Bucket in SQL Server 2022 (2023-01-30)
January 28, 2023 - New SQL Server Management Studio Released, Security Challenges, Fear, and much more (2023-01-28 DBW)
January 27, 2023 - Publishing a Public Power BI Report from Google Sheets (2023-01-27)
January 25, 2023 - Dynamic ELT with Azure Data Factory - Part 3 of 3 (2023-01-25)
January 23, 2023 - How to Import Data in Power BI Using R (2023-01-23)
January 21, 2023 - The Power of Community in Times of Uncertainty (01-21-2023 DBW)
January 20, 2023 - Verifying Trees (2023-01-20)
January 18, 2023 - Technical Considerations for Data Ingestion - Part 2 (2023-01-18)
January 16, 2023 - How to work with web information, maps, and images in Power BI (2023-01-16)
January 14, 2023 - Fun Stuff Around Hardware This Week
January 13, 2023 - Using pre-commit to prevent simple mistakes (2023-01-13)
January 11, 2023 - Translate Text Data using Azure Cognitive Services (2023-01-11)
January 9, 2023 - How to Create a Power BI report using MySQL data (2023-01-09)
January 7, 2023 - Considerations for Updated Statistics (2023-01-07 DBW)
January 6, 2023 - Ethical Hacking Tutorial (2022-01-06)
January 4, 2023 - Stairway to SQL Server Replication: Level 3 - Transactional Replication – The Publisher (2023-01-04)
January 2, 2023 - Indexes: When Column Selectivity Is Not Always A Requirement (2023-01-02)
December 31, 2022 - Happy New Year!
December 30, 2022 - T-SQL Language Changes in SQL Server 2022 Part 3 (2022-12-30)
December 28, 2022 - Stairway to SQL Server Replication: Level 2 - The Role of the Distributor (2022-12-28)
December 26, 2022 - Change the Instance Collation by Rebuilding Databases in SQL Server 2017 (2022-12-26)
December 24, 2022 - Merry Christmas and Killing IE (2022-12-24 DBW)
December 23, 2022 - Calling Procs from PowerShell with Parameters (2022-12-23)
December 21, 2022 - Stairway to DAX and Power BI - Level 20: Time Intelligence – Date Functions: ENDOFMONTH(), ENDOFQUARTER(), ENDOFYEAR() (2022-12-21)
December 19, 2022 - Artificial Intelligence with Power BI (2022-12-19)
December 17, 2022 - Improving Skills at Work (2022-12-17 DBW)
December 16, 2022 - How to create a Power BI report using REST API data (2022-12-16)
December 14, 2022 - Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD (2022-12-14)
December 12, 2022 - Automate Power BI desktop data model with a PowerShell script (2022-12-12)
December 10, 2022 - Interesting & Different Tech News This Week
December 9, 2022 - Data Activity Tracking Using SQL Triggers (2022-12-09)
December 7, 2022 - Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns (2022-12-07)
December 5, 2022 - Amazon EC2 | Creating a Connection to an Amazon RDS Instance (2022-12-05)
December 3, 2022 - Cardinality Estimation Feedback in SQL Server 2022 (2022-12-03 DBW)
December 2, 2022 - Getting started with ROUND() and Its Use Cases (2022-12-02)
November 30, 2022 - Basic Checks on a New AWS RDS SQL Server (2022-11-30)
November 28, 2022 - Being Agile - A Success Story (2022-11-28)
November 25, 2022 - Conditional Formatting with SSRS (2022-11-25)
November 23, 2022 - Stairway to SQL Server Virtualization Level 3 - Building the Ideal VMware-based SQL Server Virtual Machine (2022-11-23)
November 21, 2022 - Amazon RDS - Configuring a Connection to a SQL Server Instance (2022-11-21)
November 18, 2022 - How to get IO statistics of SQL Server database files (2022-11-18)
November 16, 2022 - Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2 (2022-11-16)
November 14, 2022 - Tutorial to Create a Power BI Report Using PostgreSQL (2022-11-14)
November 12, 2022 - Explaining Explainable AI (2022-11-12 DBW)
November 11, 2022 - The Art of Data Ingestion - Part 1 (2022-11-11)
November 9, 2022 - Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR() (2022-11-09)
November 7, 2022 - MDX in Power BI tutorial (2022-11-07)
November 4, 2022 - Cassandra Springboot Integration (2022-11-04)
November 2, 2022 - Stairway to DAX and Power BI - Level 18: Time Intelligence Dates Functions (2022-11-02)
October 31, 2022 - SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling (2022-10-31)
October 29, 2022 - Friendship Influences Your Career
October 28, 2022 - SQL Server Engineering Using Free Tools (2022-10-28)
October 26, 2022 - 10 Considerations for a Database Migration to AWS RDS (2022-10-26)
October 24, 2022 - Assert Transformations in Azure Data Factory (2022-10-24)
October 22, 2022 - The Home Password Cracker
October 21, 2022 - How to Use PowerShell to Track a Network Latency Issue in an Always On Availability Group (2022-10-21)
October 19, 2022 - Data Lineage Scripts for Microsoft SQL Server and Azure SQL (2022-10-19)
October 17, 2022 - Database Deployment with Terraform - The Basics (2022-10-17)
October 14, 2022 - PostgreSQL User Defined Functions (2022-10-14)
October 12, 2022 - Copy SSIS Environment variables to another server (2022-10-12)
October 10, 2022 - Database Deployment with Terraform - Modules (2022-10-10)
October 8, 2022 - Learning New Tech and Lots of AI
October 7, 2022 - Data Masking: Static vs Dynamic (2022-10-07)
October 5, 2022 - Stairway to AlwaysOn Level 2: Storage 101 (2022-10-05)
October 3, 2022 - How to work with Python in Azure Data Studio (2022-10-03)
October 1, 2022 - Improving SQL Server Database Backup Performance (2022-10-01 DBW)
September 30, 2022 - T-SQL Language Changes in SQL Server 2022 Part 2 (2022-09-30)
September 28, 2022 - Stairway to SQL Server Security Level 4: Permissions (2022-09-28)
September 26, 2022 - How to Visualize Python Charts in Power BI Part 4 (2022-09-26)
September 23, 2022 - PostgreSQL Triggers Part 2 (2022-09-23)
September 21, 2022 - Stairway to SQL Server Security Level 5: Schemas and Security (2022-09-21)
September 19, 2022 - How to visualize Python charts in Power BI part 3 (2022-09-19)
September 17, 2022 - A Lot of T-SQL, a Little Babylon 5
September 16, 2022 - How to Use PowerShell to Set Secure SA Passwords in Bulk (2022-09-16)
September 14, 2022 - Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1 (2022-09-14)
September 12, 2022 - How to visualize Python charts in Power BI Part 2 (2022-09-12)
September 10, 2022 - Condolences and the Speed of Change
September 9, 2022 - Understanding the System Function FILEPROPERTY() (2022-09-09)
September 7, 2022 - SQL Ledger: Protecting Data in Azure SQL (2022-09-07)
September 5, 2022 - The "Numbers" or "Tally" Table: What it is and how it replaces a loop (2022-09-05)
September 3, 2022 - New Cloud Licensing Limits (2022-09-03 DBW)
September 2, 2022 - Manage Your Business Rules in T-SQL Query (2022-09-02)
August 31, 2022 - T-SQL Language Changes in SQL Server 2022 (2022-08-31)
August 29, 2022 - Understanding the Metadata Function DATABASEPROPERTYEX() (2022-08-29)
August 27, 2022 - Easy-to-read execution plans, an end to parameter sniffing pain, other impossible dreams (Database Weekly, 08/27/22)
August 26, 2022 - Database Deployment with Terraform - The Basics (2022-08-26)
August 24, 2022 - PostgreSQL Triggers Part 1 (2022-08-24)
August 22, 2022 - Tips to improve Power BI report appeal (2022-08-22)
August 20, 2022 - The Case for Patching (2022-08-20 DBW)
August 19, 2022 - INSERT EXEC statement cannot be nested, the Simple Solution (2022-08-19)
August 17, 2022 - Getting More Information From the String or Binary Data Truncated Error (2022-08-17)
August 15, 2022 - How to Visualize Python Charts in Power BI (2022-08-15)
August 13, 2022 - SQL Standard Confusion, the Cost of Complexity in SQL Server and more in Database Weekly (08/13/22)
August 12, 2022 - Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory (2022-08-12)
August 10, 2022 - Stairway to Columnstore Indexes Level 3: Building The Columnstore (2022-08-10)
August 8, 2022 - Business Analytics from Application Logs and SQL Server Database using Splunk (2022-08-08)
August 6, 2022 - Tuning High-Cost Queries, T-SQL Improvements in SQL Server 2022 and more in Database Weekly (08/06/2022)
August 5, 2022 - How to Format Dates in SQL Server (Hint: Don’t Use FORMAT!) (2022-08-05)
August 3, 2022 - Tracking Configuration Changes Against a Baseline (2022-08-03)
August 1, 2022 - How to Get Data Using Python in Power BI (2022-08-01)
July 30, 2022 - GitHub vs. Azure DevOps (2022-07-30 DBW)
July 29, 2022 - How to Backup Redshift Log Views (2022-07-29)
July 27, 2022 - Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions (2022-07-27)
July 25, 2022 - Infographic Designer Visuals in Power BI (2022-07-25)
July 23, 2022 - Optimizing Azure SQL Database, DevOps Collaboration, Invisible Indexes and more in Database Weekly (07/22/22)
July 22, 2022 - Establishing a Connection to PostgreSQL with GoLang (2022-07-22)
July 20, 2022 - PerfMon: Using SQL Server Performance Counters (2022-07-20)
July 18, 2022 - How to Connect to an Analysis Services Database in Power BI (2022-07-18)
July 16, 2022 - Lots of Interesting Tech News
July 15, 2022 - Linked Servers: a Peek Behind the Curtain (2022-07-15)
July 13, 2022 - How to Find the Start and End Dates for the Current Week (and more) (2022-07-13)
July 11, 2022 - Power BI Report Builder Parameters Tutorial (2022-07-11)
July 9, 2022 - SQL Insider Series: Azure SQL DB – Automating scale up and down (2022-07-09)
July 8, 2022 - Monitoring Azure Blob Storage (2022-07-08)
July 6, 2022 - Stairway to Advanced T-SQL Level 7: Ordering Your Data Using Ranking Functions (2022-07-06)
July 4, 2022 - Using Graph Theory To Group Records (2022-07-04)
July 2, 2022 - Christmas in July (2022-07-02 DBW)
July 1, 2022 - Working with T-SQL function AVG () (2022-07-01)
June 29, 2022 - Stairway to Columnstore Indexes Level 2: Columnstore Storage (2022-06-29)
June 27, 2022 - SQL Server Sample Databases (2022-06-27)
June 25, 2022 - Shared Work Spaces
June 24, 2022 - Randomizing the Day Inside a Month Using T-SQL (2022-06-24)
June 22, 2022 - Stairway to SSAS Tabular Level 9: Security and Roles (2022-06-22)
June 20, 2022 - Power BI Report Builder Expressions - Build In Fields and Functions (2022-06-20)
June 18, 2022 - A New SQL Server Vulnerability (2022-06-18 DBW)
June 17, 2022 - Fixing "The Distributor has not been installed correctly" Error with AWS (2022-06-17)
June 15, 2022 - Understanding Shared Access Signature and Access Policy in Azure Storage (2022-06-15)
June 13, 2022 - Power BI Report Builder Expressions - Date Functions (2022-06-13)
June 10, 2022 - Dealing with Transaction Log Growth (2022-06-10)
June 8, 2022 - Stairway to ScriptDOM Level 3 - Finding Patterns in the Abstract Syntax Tree (2022-06-08)
June 6, 2022 - How to grant PowerBI Service Workspace access using PowerShell (2022-06-06)
June 3, 2022 - PostgreSQL Springboot Integration Using JDBC Template (2022-06-03)
June 1, 2022 - Stairway to SQLCLR Level 8: Using Visual Studio to Work around SSDT (2022-06-01)
May 30, 2022 - Using tsqlt Tests to Practice Queries (2022-05-30)
May 28, 2022 - The SQL Server 2022 Preview (2022-05-28 DBW)
May 27, 2022 - Loading Data using R and PowerBI (2022-05-27)
May 25, 2022 - Permissions and Security in Dynamic Data Masking - Step 4 of the Stairway to Dynamic Data Masking (2022-05-25)
May 23, 2022 - How to use Images in Power BI Report Builder (2022-05-23)
May 21, 2022 - Virtualization, T-SQL, and more in Database Weekly (2022-05-21)
May 20, 2022 - A Tiny Trauma (2022-05-20)
May 18, 2022 - Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE (2022-05-18)
May 16, 2022 - Power BI Report Builder Introduction (2022-05-16)
May 14, 2022 - The Community's First Technical Job
May 13, 2022 - The Script Activity in Azure Data Factory (2022-05-13)
May 11, 2022 - Your First Repo in Azure Data Studio or VS Code (2022-05-11)
May 9, 2022 - Who is the Best Batman in Power BI (2022-05-09)
May 7, 2022 - Finding New Employment (2022-05-07 DBW)
May 6, 2022 - Standards Matter (2022-05-06)
May 4, 2022 - The Configured Data Masks for Dynamic Data Masking - Step 3 of the Stairway to Dynamic Data Masking (2022-05-04)
May 2, 2022 - Creating Tables in Power BI (2022-05-02)
April 30, 2022 - Migrate from RDS to Managed Instance, Power BI refresh, and more in Database Weekly (2022-04-30)
April 29, 2022 - Azure Data Studio and Version Control (2022-04-29)
April 27, 2022 - 7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours (2022-04-27)
April 25, 2022 - Understanding the Mapping Data Flow Activity in Azure Data Factory (2022-04-25)
April 22, 2022 - DAX in Power BI Tutorial (2022-04-22)
April 20, 2022 - Basic Git for DBAs: Getting Started with Git (2022-04-20)
April 18, 2022 - Incremental Data loading through ADF using Change Tracking (2022-04-18)
April 16, 2022 - Azure SQL DB Backup History - View backups of your Azure SQL Database (2022-04-16 DBW)
April 15, 2022 - An Introduction to Flowlets in Azure Data Factory (2022-04-15)
April 13, 2022 - Stairway to ScriptDOM Level 2 - Parsing, Tokens, and the Abstract Syntax Tree (2022-04-13)
April 11, 2022 - Power BI vs SSRS (2022-04-11)
April 9, 2022 - SQL Server Agent, Paginated Reports, and more in Database Weekly (2022-04-09)
April 8, 2022 - SSIS Environment Design Patterns (2022-04-08)
April 6, 2022 - SSRS in Visual Studio (2022-04-06)
April 4, 2022 - Understanding Azure Data Factory Pricing (2022-04-04)
April 2, 2022 - Virtual Events
April 1, 2022 - Power BI in Grafana (2022-04-01)
March 30, 2022 - How do you secure sensitive data in a modern Data Warehouse? (2022-03-30)
March 28, 2022 - Cloud Computing Basics - Achieving High Availability (2022-03-28)
March 26, 2022 - The Missing SQL Server Agent Job Owner (DBW 2022-03-26)
March 25, 2022 - Create a Free Azure Account (2022-03-25)
March 23, 2022 - Data and database management in everchanging technology landscape (2022-03-23)
March 21, 2022 - Import Web pages with Power BI (2022-03-21)
March 19, 2022 - DAX, Backups, and more in Database Weekly (2022-03-19)
March 18, 2022 - Monitoring Azure SQL Databases (2022-03-18)
March 16, 2022 - Prevent Accidental Resource Deletion Using Locks in Azure Data Factory (2022-03-16)
March 14, 2022 - Query History and Server Reports in Azure Data Studio (2022-03-14)
March 11, 2022 - Exploring Knowledge Center in Azure Synapse Analytics (2022-03-11)
March 9, 2022 - Stairway to ScriptDOM Level 1 - An Introduction to ScriptDOM (2022-03-09)
March 7, 2022 - The Central Management Servers Extension in Azure Data Studio (2022-03-07)
March 5, 2022 - Using Technology for Health (2022-03-05 DBW)
March 4, 2022 - Oracle ASM: Migrating from UDEV devices to the ASM Filter Driver (2022-03-04)
March 2, 2022 - Can We Please Stop Sending Passwords Over the Wire? (2022-03-02)
February 28, 2022 - Creating an SSRS Report from an Azure SQL Database (2022-02-28)
February 26, 2022 - SQL Server corruption, boxplots, and more in Database Weekly (2022-02-26)
February 25, 2022 - Chaos Engineering in Azure (2022-02-25)
February 23, 2022 - Using Azure File and Blob Storage with Azure VMs – Step by Step (2022-02-23)
February 21, 2022 - How to Compare Tables in Azure Data Studio (2022-02-21)
February 19, 2022 - SQL Server 2022 Storage Engine Capabilities (2022-02-19 DBW)
February 18, 2022 - Running SQL Server on Oracle and Google Cloud (2022-02-18)
February 16, 2022 - SQL Log File Too Big (2022-02-16)
February 14, 2022 - PowerShell in Azure Data Studio (2022-02-14)
February 12, 2022 - Community is Everywhere
February 11, 2022 - SQL Server Development Using Free Tools (2022-02-11)
February 9, 2022 - Stairway to Advanced T-SQL Level 1: Intro to Advanced T-SQL Using a CROSS JOIN (2022-02-09)
February 7, 2022 - PostgreSQL in Azure using the Azure Data Studio Extension (2022-02-07)
February 5, 2022 - Backup strategy, Azure SQL Edge, and more in Database Weekly (2022-02-05)
February 4, 2022 - Using Logging with the Delete Activity in Azure Data Factory (2022-02-04)
February 2, 2022 - A Custom Execution Method – Level 19 of the Stairway to Integration Services (2022-02-02)
January 31, 2022 - PostgreSQL in Azure Data Studio (2022-01-31)
January 29, 2022 - Time for SQL Server Administration
January 28, 2022 - Is Your SSIS Catalog Migration Ready (2022-01-28)
January 26, 2022 - How to Integrate Azure DevOps with Azure Synapse Studio (2022-01-26)
January 24, 2022 - Working with Fail Activity in Azure Data Factory (2022-01-24)
January 22, 2022 - Getting locked out of SQL Server: Cannot open user default database. Login Failed. (2022-01-22 DBW)
January 21, 2022 - Prevent Accidental Data Deletion in Azure Storage Container with Soft Delete Features (2022-01-21)
January 19, 2022 - Playing popular game of Wordle using T-SQL (2022-01-19)
January 17, 2022 - SQL Server Dacpac in Azure Data Studio (2022-01-17)
January 15, 2022 - Database corruption, Azure SQL, and more in Database Weekly (2022-01-15)
January 14, 2022 - Performance Tuning Using Free Tools, Part 2 (2022-01-14)
January 12, 2022 - Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator (2022-01-12)
January 10, 2022 - The Changing Landscape of Information Management (2022-01-10)
January 8, 2022 - An Eclectic Mix To Start the New Year
January 7, 2022 - Query control made easy (2022-01-07)
January 5, 2022 - Stairway to Advanced T-SQL Level 6: Creating Rows Of Data Using The UNPIVOT Operator (2022-01-05)
December 31, 2021 - TempDB, PowerShell, and more in Database Weekly (2022-01-01)
December 31, 2021 - Migrating Column Level Encryption from 2008R2 to Azure SQL Database (2021-12-31)
December 29, 2021 - Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values (2021-12-29)
December 27, 2021 - Views in SQL Server 2019 with SSMS (2021-12-27)
December 25, 2021 - Merry Christmas, Happy Holidays, and Happy New Year (2021-12-25 DBW)
December 24, 2021 - Query Performance Diagnostics with sp_PerfSQ (2021-12-24)
December 22, 2021 - Stairway to SQL Server Extended Events Level 1: From SQL Trace to Extended Events (2021-12-22)
December 20, 2021 - Is SQL Server Profiler in Azure Data Studio? (2021-12-20)
December 18, 2021 - Deaths in the Family
December 17, 2021 - Performance Tuning Using Free Tools (2021-12-17)
December 15, 2021 - Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn (2021-12-15)
December 13, 2021 - Introduction to SQL Jobs in Azure Data Studio (2021-12-13)
December 11, 2021 - Filtered indexes, Azure AD authentication, and more in Database Weekly (2021-12-11)
December 10, 2021 - SQL Server Data Classification Comes Alive (2021-12-10)
December 8, 2021 - Stairway to SQL PowerShell Level 10: Getting data in and out of SQL Server using PowerShell (2021-12-08)
December 6, 2021 - Azure Data Studio - A SandDance demo (2021-12-6)
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)
January 3, 2000 - How to (Somewhat) Increase SQL Server Security (2022-01-03)

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

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