Jason Crease Database Continuous Integration with SQL CI and Jenkins Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated... 10 September 2020 3 min read
Blogs Louis Davidson in Blogs Weighted Randomization In T-SQL When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld... 02 September 2020 7 min read
Blogs Dennes Torres in Blogs Responsible AI news from Build Microsoft Build took place more than a month ago, but only now I’m writting about it. I’m facing the danger... 24 August 2020 4 min read
Blogs Mithun Gaur in Blogs Understanding digital transformation & how it transcends to driving organizational growth Introduction Digital transformation is the process of undergoing multiple internal and external changes by an organization leveraging digital technologies to... 21 August 2020 10 min read
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
