Grant Fritchey (1/29/2016)

---

Yeah, I'd love...

Luis Cazares (1/22/2016)

---

You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

You're effectively not inserting any null values explicitly, but you were missing the column in...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

I've some interesting interview experiences recently both as the interviewer and the interviewee.

As an interviewer I've seen 2 resumes/CVs from one recruiter that had a specialized piece of...

Ed Wagner (1/11/2016)

---

Koen Verbeeck (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Grumpy DBA (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although Bauhaus...

Steve Jones - SSC Editor (1/8/2016)

---

BTW, apparently the quality of my writing has also gone down. Got this lovely note today

Your article today compels me to seek your “Unsubscribe”...

Ed Wagner (1/7/2016)

---

Thanks for the tip, Sean. I've not yet worked at a company that has an IM - I guess I've been sheltered. I'm hoping that using...

John1.5.nlt (12/29/2015)

---

I have 3 tables as part of a normalized database, I have a main records table that come from an ETL job Table1, I also have a set of...

Steve Jones - SSC Editor (12/16/2015)

---

Jack Corbett (12/16/2015)

---

How about Portland, ME the first or second weekend in June? It isn't up on the SQLSaturday site yet, but...

Steve Jones - SSC Editor (12/15/2015)

---

No, Cleveland is out....

2 things:

1. That joke fell short 😀

2. I'm not sure Rodders is tall enough to overlook...

rodjkidd (12/13/2015)

---

Hey Grant,

I have a ticket for Marillion in Boston Friday Nov 4th. 🙂

It's a early show - doors at 6.

I then have one for New York the week after....

I love it!

chuck.forbes (12/3/2015)

---

It just caught me off guard when I was searching for server-level privileges that there was a mix of 'db%' privilege names alongside pretty syntactically different names like 'DROP%'...

SQLRNNR (1/16/2012)

---

Gianluca Sartori (1/16/2012)

---

I did a similar thing some years ago.

Here's the code:

CREATE TRIGGER [TR_LOGON_APP]

ON ALL SERVER

FOR LOGON

AS

BEGIN

DECLARE @program_name nvarchar(128)

DECLARE @host_name nvarchar(128)

SELECT @program_name = program_name,

@host_name = host_name

FROM sys.dm_exec_sessions...