DevOPs and Databases — the one thing you may be doing wrong.
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
The 2nd June 2017 will always be something of a special day for me.
It was the day I was awarded...
2017-06-06
649 reads
This blog post is part of T-SQL Tuesday #90 – Shipping Database Changes.
I have decided to write about a client’s SQL...
2017-05-09
384 reads
In my previous postI adhered to my O-OCD (Operational OCD) and standardised my App Service Plan name to fit in...
2017-05-18 (first published: 2017-05-07)
1,578 reads
Using the methodology listed in my previous blog post on creating an Azure SQL Database we now have a Continuous Integration...
2017-04-30
617 reads
In this post we will remove some databases located in Azure.
This related to my last post where I am cleaning...
2017-04-30
1,615 reads
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,359 reads
For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...
2017-04-24
377 reads
This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...
2017-04-22
1,055 reads
Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...
2017-04-22
244 reads
By Brian Kelley
I will be back in Seattle this year attending the 2025 PASS Data Community...
By Steve Jones
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...
By Steve Jones
Today is my last day of work for six weeks. I start my sabbatical...
Comments posted to this topic are about the item Three Times a Day
Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...
Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...
In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOI decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GOWhat happens with these statements? See possible answers