The firewall on database server should only be accepting connections from the web application server and a limited range supporting your IT department, right?

Regardless of whether you have an AOG listener, you can connect directly to either the primary or secondary using a connection string similar to that below. If connecting to the...

Yes, IoT monitoring is a good application for industrial, healthcare, and the environment. I have a Ring security system and love it. I guess drones fall under the category of...

When designing the initial model for a database, I'd rather err on the side of tight constraints (ie: default to not-null if the business can't think of a good reason...

DevOps is a collection of tools and processes for deploying code. It's a means to an end - but not the end goal.

There needs to be an abstraction layer between the application and the physical implementation of the database (tables and columns). Some will call for using web services or a microservices...

When evaluating various cloud database platforms, it's not just about SQL features or who can offer the best deal on hosting. Some of these platforms offer amazing scalability.

I was evaluating...

When creating DML scripts for deployment, I sometimes implement assertion based logic like in the two examples below.

The use of RAISERROR with severity level 20 causes SQL Server to terminate...

Just yesterday, I had to troubleshoot an issue where CPU was pegged at 99%, and I determined the bottleneck to be a high volume query executed by the eCommerce application...

I watched all iterations of the Star Trek through the one in early 2000s where Scott Bakula is captain. I even watched the more obscure stuff like Lexx and Farscape....

One Youtube channel is the CMU Database Group from Carnegie Mellon University.  My brother went to CMU and one of his sons goes there now.  Their earlier series...

I'll listen to a vendor specific tech talk, so long as it's one of their engineers or solutions architects doing the talking. It's interesting when they present a tool in...

A specific legacy version of SQL Server (ie: 2012) is good enough, if it supports that legacy application for which you havn't changed since 2014. But if you work in...

Of course, if the SQL Server team actually implemented any of these suggestions, they would be making T-SQL even more proprietary. Maybe we should be directing to these requests to...

It's true that Microsoft's T-SQL and Oracle's PL-SQL are very different, but those are procedural languages extensions that wrap around the SQL language which is fairly consistent.