Take A Vote and Accept Your Loss
Learning to make decisions and then get work done is important to Steve. Read his thoughts today on many of the decisions software teams need to make.
Code Visibility: Browsing through Flyway Migration Files
If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you to scan through many files, moving from file to file with a single click. This article will demonstrate how to do this with a few PowerShell scripts.
Configuration of Azure SQL Database Auditing
This article shows how you can configure auditing on your Azure SQL Database.
Understanding the Importance of Data Lineage in Modern Data Management
Data lineage is a component of modern data management that helps organizations understand the origins, transformations, and movement of their data. It is like a road map that shows us where our data has been, how it has changed, and where it is going, just like tracking the journey of a package:
Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 2: Connections and Creating Server Inventories
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 3: The Database Class
Learn how to get started working with SMO and PowerShell.
Stairway to Server Management Objects (SMO) Level 4: Scripting and Copying Small Databases
In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
Stairway to Server Management Objects (SMO) Level 5: Moving to the SQLServer Module
In this level you will learn about the SQLServer PowerShell module that ships with modern versions of SSMS.
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Work out closing balance using opening balance of prior month
Hello, I think I need a recursive cte query but unsure of the logic....
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers