The following website has a collection of 3,000+ visual studio themes for download, which also can be imported into SSMS. You can even create new themes here as well.

Unless my off-hours learning and hobby programming turns into a full fledged side business, I don't plan plan to ever spend $,$$$ for a personal on-premises (ie: setup in my...

SQL suffers from the same predicament as HTML and JavaScript; it's an accessible high-level language that's widely used by a lot of people, but only a few people actually know...

Yes, the service account used for the honeypot server should be local no admin minimal priv, the mssql account left open to the public should itself be nothing more than...

I'm no expert on tempdb, but I have a couple of thoughts, like what's your initial size and auto-growth setting on tempdb?

You can use the following query against...

A few years back there was a discussion about Honeypot servers. The basic concept is that you setup a marginally secure server for the sole purpose of baiting hackers who are randomly scanning...

When what should be a fast query becomes a long running query, the first thing to do is confirm if blocking is taking place on the request's SPID.
900,000 rows...

Don't care. There...

Security has to be baked into the infrastructure and development process rather than sprinkled on top of a deliverable like spice. For example, servers and databases in development should be...

The value of SQL Serer relative to other database platforms is the stack of services, features, and client tools that come bundled with it. To fully get Linux based organizations...

Firewalls are an essential first defense, but it's still kind of like the plate glass windows at the bank; a determined intruder can eventually find a way in.

Even...