Common Mistakes in SQL Server – Part 2

The  Identity property creates an incremental value for the specified column automatically, which is why it is widely used by developers when they designed the table and a primary...

Enable PowerShell Remoting

Enable PowerShell Remoting

I use PowerShell quite a lot to manage servers, especially SQL Servers. So I need to be able to run PowerShell...

Get Configuration Change History From the SQL Server Error Logs

Get Configuration Change History From the SQL Server Error Logs

There are several options if and when you need to see if any configuration change was...

A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around

How To Gain Access To SQL Server When No DBA

When I showed a draft of this article to a friend of mine, to...

A Study in SQL Server Ad hoc Query Plans

A Study in SQL Server Ad hoc Query Plans

We, (or maybe it’s just my dismissive attitude towards it), often think of ad hoc...

Friday Flyway Tips–Flyway Parameters

Flyway is a command line tool with lots of options and parameters. Working with those is a pain, but we’ve made this easier in Flyway Desktop 6.5+. In this...

A New Word:Wildred

wildred –adj. feeling the haunting solitude of extremely remote places – a clearing in the forest, a windswept field of snow, a rest area in the middle of nowhere...

Creating an Empty Repo in GitHub–#SQLNewBlogger

I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...

Product Review: DataVeil

If you’re looking at data masking tools, I recently was able to review the DataVeil solution. Quite simply, getting production data out of non-production environments is still a big...

Are You Protected from Ransomware

There have been many organizations that have become victims of ransomware over the years. Occasionally we hear about some high-profile cases in the news. Most every case I’ve read...