What you need is a covering index. Read up on that topic. Basically, it's called covering, because it contains all the key and projected columns referenced by the query which...

I remember hearing a surgeon talk about his surgical memoir. It really struck me. He said, the first 10 years, you learn how to cut. The next 10 years,...

SQL and HTML/JavaScript are two sides of the same coin. Both languages are easily accessible but broadly misused. Most complaints about "limitations" are actually founded on misconceptions about how the...

Thanks, Steve, for all the effort you put into this article. This is also a good tutorial on using Git to effectively collaborate with a large team on a project.

"..It is somewhat odd that so many of the opinion-formers on the technology of the IT industry have so little experience working in the industry as technologists. Few other professions...

Most phishing scams are automated and impersonal, while other scams hit closer to home. For example, last year my grandmother got a call from a guy pretending to...

This is just based on my personal perspective, but today in 2019, I wouldn't invest in an on-prem home lab. For my personal PC, I prefer a smaller notebook, and...

Most phishing scams are automated and impersonal, while other scams hit closer to home. For example, last year my grandmother got a call from a guy pretending to be me....

Sadly, there are some crooks directing folks to fake Equifax settlement websites.

https://www.consumer.ftc.gov/blog/2019/07/equifax-data-breach-beware-fake-settlement-websites

I'm guessing you're talking about a database modeling or entity relationship diagram (ERD) tool. I don't know of an extension for SSMS or Visual Studio, but there is a tool...

When it comes to hacks against corporate or government targets, it is entirely plausible that in many cases the public disclosure itself is of more importance to the hacker than...

.. The downside of chaining to slack and then Pagerduty is that is Slack is down, what happens? It's not often Slack goes down, but with my prior luck,...

I believe you have two issues:

(1) Your SSIS package(s) are probaly logging a tremendous amount of event detail.

(2) The above has caused your SSISDB database to swell and then the...

Synonyms can be useful for whomever created them, but confusing for others who stumble across them by accident. It depends on the purpose, but I prefer views instead.

Yes, setting up an event monitoring solution is phase 1. The next phase is setting a solution for alerting, collaboration, triage, and incident workflow. Historically, we had error and threshold...

• This reply was modified 6 years, 2 months ago by Eric M Russell.