Articles tagged

10 September 2020
10 September 2020

Database Continuous Integration with SQL CI and Jenkins

6
Continuous integration (CI) is the process of ensuring that all code and related resources in a development project are integrated regularly and tested by an automated build system. Code changes are checked into source control, triggering an automated build with unit tests and providing early feedback in the form of errors returned. Potential problems with … Read more
25 July 2020
25 July 2020

Keeping up with SQL Server

I gave a session for the recent PASS Marathon entitled “Modern T-SQL for Better Performance.” During the session, I talked mostly about windowing functions. These functions introduced in 2005 and 2012 not only make writing T-SQL code easier, but often it’s better performing as well. In many cases, they can help you avoid self-joins and … Read more
26 June 2020
26 June 2020

Will We Still be Talking About DevOps in Two Years?

While individual buzzwords will come in and out of fashion, the ideas at the heart of DevOps aren’t going anywhere.  Like any good buzzword, DevOps may mean different things to different people. There are several good definitions of DevOps out there. My favorite definition comes from @IanColdwater, who defined DevOps in terms a teenager would understand: Devops … Read more
02 June 2020
02 June 2020

Too Much Stuff

We’ve lived in our current home for 30 years and have managed to accumulate a lot of possessions. We have closets, drawers, cabinets and a storage shed filled with things, many of which we don’t remember buying or receiving in the first place. I haven’t quite gotten into the Marie Kondo way of organizing yet, … Read more
16 April 2020
16 April 2020

How to Document SQL Server Tables

10
When you create a table, SQL Server doesn’t save your comments explaining the table as it does with stored procedures, for example. In this article, Phil Factor explains how you can merge the documentation from your build scripts into the database.… Read more