(Arun Sirpal) I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it can get quite confusing within the portal if for example you have close to 100 databases.

(Jason Brimhall) Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

(Greg Larsen) Have you ever had a need to place some simple row level security on a SQL Server table? Meaning you only want certain people to select or update a row. Well now you can do that in SQL Server 2016 by using row level security.

(Pinal Dave) While I was playing with SQL Cluster in my lab, I restarted the VMs and found that I was not able to bring SQL Server online. As always I was looking for error message, but there was nothing interesting. Let us see in this blog post how to fix Clustered Instance Online Error.

(Stephanie Herr) The easiest way of explaining how a DevOps approach to database deployment can dramatically speed up the process is to use the term ‘shift-left’. By performing, or at least preparing for, all the processes and tasks that are necessary for deployment as soon as possible in the develo

(Michael Otey) Flash storage adoption, cloud computing’s growth, Linux’s increased importance and broader big data integration are a few trends that stand to affect SQL Server users this year.

(Eli Leiba) You need a simple tool to detect any SQL Server configuration values that have been changed from their default value. This task is common when investigating SQL Server performance problems.

(Manoj Pandey) I was trying to export a SQL table to Excel and I got below error:

(Thomas LaRock) Last week at SQL Live I gave a talk “Configuring SQL Server like a Microsoft Certified Master”. It’s a session Tim Chapman (blog | @chapmandew) and I built previously and I’ve made an effort to keep updated.

(Pinal Dave) One of my clients reported a usual behavior of the AlwaysOn availability group. He informed me that he is trying to add a login on the secondary replica in the AlwaysOn AG environment but it is failing with below error: