It has always struck me that Microsoft really needs a brain adjustment. SQL Server is a business tool, yet it seems that they treat it like a consumer product....

Gary Varga (4/27/2015)

---

Which is quite ridiculous as an English Gentleman knows that the 13^th floor is the 14^th floor as there must be a ground...

Law enforcement has a honeypot car that...

bdenning (4/22/2015)

---

I in no way stated "don't read this article" but instead it was a soft plea to SQL Server Central to not reference such articles. Doing so increases...

dwain.c (4/21/2015)

---

Wayne West (4/21/2015)

---

Dwain, that first code worked perfect, the second one only has D/N/P/Y appearing for district 000, which may or may not work live. Since the first...

Eric M Russell (4/21/2015)

---

Wayne West (4/21/2015)

---

Eric M Russell (4/21/2015)

---

So did we learn anything today, or was this mostly an offbeat topic?

What do you guys think about the honeypot database...

Eric M Russell (4/21/2015)

---

So did we learn anything today, or was this mostly an offbeat topic?

What do you guys think about the honeypot database server to attract hackers or...

Moneypenny was a crack shot, so I definitely wouldn't try to sneak past her! There was a line in one of the books where M says that she shoots...

I like the honeypot idea, but wouldn't you pretty much need a full-time sysadmin to maintain it and keep it looking current and monitor it? I guess the honeypot...

Dwain, that first code worked perfect, the second one only has D/N/P/Y appearing for district 000, which may or may not work live. Since the first one does work...

I think part of this is two-fold. 1: Every situation...

ScottPletcher (4/16/2015)

---

For example:

--USE [<your_db_name_here>] --naturally make sure you are in the right db

SET DEADLOCK_PRIORITY LOW --probably irrelevant, but just in case

DECLARE @list_missing_indexes bit

DECLARE @table_name_pattern sysname

--NOTE: showing missing indexes can take...

Eric M Russell (4/17/2015)

---

Below is a script I use to quickly zip through every database, looking for objects that have been created or modified in the past 24 hours. In...

Eric M Russell (4/17/2015)

---

I was thinking along the lines of intermittent failure, something that causes a disruption of a few hours or maybe a full day (which might have more...

It's in Alpha testing right now and will release next year on April 1....