Blogs Louis Davidson in Blogs Trigger Validations and Isolation Levels Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is... 18 August 2020 9 min read
Blogs Dennes Torres in Blogs Data Warehouse Concepts and the mix of names and technologies Once upon a time, we got the Data Warehouse concept. A concept as great as difficult to implement. The definition... 17 August 2020 6 min read
Blogs Dennes Torres in Blogs Start and stopping all Virtual Machines on a Resource Group Some tasks on azure are easier if we automate them. The Azure Portal provides us the cloud shell, which we... 10 August 2020 4 min read
Blogs Louis Davidson in Blogs How to modify a SQL Server Graph Edge with T-SQL As I have been writing a section on SQL Server graph tables in my Database Design book, (and prepping for... 10 August 2020 6 min read
Blogs Dennes Torres in Blogs How to not go mad with schema compare in SSDT SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT... 03 August 2020 2 min read
Ben Rees How Mature is Your Database Change Management Process? How do you get your database schema changes live on your production system? As your team of developers and DBAs... 01 August 2020 8 min read
Blogs Dennes Torres in Blogs Extracting DACPAC even When SQL Server refuses to There are many situations when you need to extract a DACPAC from an existing database in a SQL Server. These... 27 July 2020 3 min read
Blogs Premanand Dheenadayalan in Blogs Batch Framework In SDLC (software development life cycle) process, creating a batch job is the last step. As the application maintenance grows... 08 July 2020 11 min read
Blogs Phil Factor in Blogs SQL Server JSON Diff. Checking for differences between JSON documents. If you are working on any module or routine such as a procedure, function or batch that produces a result,... 06 July 2020 10 min read
Blogs Louis Davidson in Blogs The Pros and Cons of Virtual Conferences: Just My Opinions Before taking any time with the rest of my SQL Saturday Chattanooga, Home Edition teammates to discuss what went right and... 30 June 2020 12 min read
Blogs Kathi Kellenberger in Blogs Using Azure Data Studio with SQL Prompt One of the coolest and most useful features of Azure Data Studio (ADS) is SQL Notebooks. If you haven’t seen... 04 June 2020 4 min read
Blogs Phil Factor in Blogs Database Kill and Fill When testing database code in development, you usually have a lot of tests that aim to prove that the various... 13 May 2020 8 min read
Blogs Annette Allen in Blogs Isn’t the technical Community great?!! With everything that’s been going on in the world recently and all events being cancelled or postponed you might mistakenly... 07 May 2020 4 min read
Blogs Phil Factor in Blogs Tackling Imperial and US Customary Measurements in Databases The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are... 06 May 2020 10 min read
Blogs Louis Davidson in Blogs SQL Agent Job Generator: Scheduling A Job In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going... 17 April 2020 10 min read
Blogs Louis Davidson in Blogs SQL Agent Job Generator: Creating A Set Of Working Jobs In this entry in the SQL Agent Job Generator system series, we are going to turn the corner and actually... 09 April 2020 9 min read
Blogs Louis Davidson in Blogs SQL Agent Job Generator: Building the Base Rig and Managing Categories In the previous entry in this series, I implemented Environment Variables that will let me have one code base that... 05 April 2020 6 min read
Blogs Louis Davidson in Blogs Implementing Environmental Variable Values in PowerShell As a relative neophyte to PowerShell (something I will remind readers of every time I start a blog in this... 02 April 2020 7 min read
Blogs Louis Davidson in Blogs Using PowerShell to Control Visio Note: Please be kind on my PowerShell programming techniques. If I am doing something really horrible, let me know. I... 31 March 2020 8 min read
Blogs Dennes Torres in Blogs Microsoft Data Platform 2020 From last November 4 to 8 I have been at PASS Summit in Seattle, attending excellent technical sessions and having the... 29 March 2020 21 min read
