Database Continuous Integration with SQL Clone and SQL Change Automation
Uses SCA to build the database and SQL Clone to distribute the finished database to the various team-based servers who require the latest build.
SQL SERVER – Patch Failure – Unable to Retrieve the Cluster Service
Few of my clients are still running older versions of SQL Server and they have their own reasons to not to move to the new SQL version. In this blog, we would learn about the fix of an error for which my client contacted me. My client was trying to app …
10 Database Tasks That Sound Easy, But Aren’t
All of these are doable with scripts, tools, and/or elbow grease, mind you – they’re just not as easy as they sound at first glance until you know about the existence of those scripts, tools, and/or free people waiting around with …
Build and fill a database using JSON and SQL Change Automation
Storing your data for development work as JSON confers several advantages. You can exchange data with any application or service that can consume JSON data, you can edit the data easily in a JSON editor, use lightning fast data masking that doesn …
Cyber Insecurity in Pakistan
Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts.
SQL SERVER – Error 1051: A Stop Control Has Been Sent to a Service that Other Running Services are Dependent On
Sometimes there are some random unexpected errors and it’s always fun to find the cause of them. In this blog we would learn about an error 1051 (A stop control has been sent to a service that other running services are dependent on) which I rece …
Changing the SSH port for a RHEL Azure VM
I’m working with Red Hat Enterprise Linux (RHEL) VMs on Azure and one of the best practices that Microsoft recommends is to change the default SSH port from 22 to something else. I was looking for a consolidated set of instructions to do this and …
Improve the Performance of Your Azure SQL Database (and Save Money!) with Automatic Tuning
Azure can create sticker shock for some companies as they venture into the cloud. As a database administrator, it is your job to fine-tune your environment to mitigate those costs the best you can. Azure SQL Database Purchasing Models Microsoft gives y …
Announcing the Consultant Toolkit: Now Available in the European Union, too
Yesterday, I got a barrage of emails and LinkedIn messages that went like this: Hey Brent, about your new consultant toolkit: I really love that idea and would want to get my hands on it. Unfortunately i originate in the EU. I know about your reasoning …
An Introduction to RLS Security Policies: Level 3 of the Stairway to Row-Level Security
An introduction to how security policies work for RLS.
Cleanup SQL Server Query Store Data After Database Restore
In this tip we look at how to cleanup the SQL Server query store after a database has been restored to ensure that query store starts data collection starts fresh.
Database Continuous Integration with the Redgate SQL Toolbelt and Azure DevOps
This article explains how to set up a SQL Server source control and database continuous integration (CI) process from scratch, using Azure DevOps, Git, PowerShell and Redgate tools, in three steps
SQL SERVER – SQL Clustered Resource in Online Pending State for Long Time Before Coming Online
While doing Comprehensive Database Performance Health Check I always ask my client if there is any pain point which they have with the current state of the database/server. Once I got an interesting question which I am going to answer in this blog post …
Twenty years ago today…
… I emigrated to the United States. I boarded a plane in Glasgow with my (then) wife Sylvia, bounced in Amsterdam and then landed in Seattle, entering the US on an H1B visa after almost five years of working for DEC/Digital. We arrived in temp h …
What is the purpose of your organization? A lesson in DevOps
I’ve been speaking a lot on the topic of DevOps lately, and there’s a question I like to ask. What is the purpose of your organization? I get all kinds of answers. “We make software that delights our customers and makes their jobs eas …