Hi Jonathan,

Before I ask a question I wanted to say that I really like your articles, especially in the events area.

Here is the question:

I have create a queue for auditing...

Jonathan,

Tested the routine, not that I had doubts but had to follow...

Hi Johnathan,

I have been using a method that once I found on internet if now here at sqlservercentral and has helped me identifying certain elements and information on one or...

Scott Coleman (10/2/2012)

---

I would take a different approach. Not necessarily better, but different.

I would avoid the cursor and the immediate EXEC(), instead just use a query to produce the...

Sean Lange (10/2/2012)

---

John Esraelo-498130 (10/2/2012)

---

Sean Lange (10/2/2012)

---

additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than...

Sean Lange (10/2/2012)

---

additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than one

table then it...

Sean Lange (10/2/2012)

---

additionally, when you have multiple tables having field names of the same, such as LName, FName, Address, etc. that may appear in more than one

table then it...

DavidL (10/2/2012)

---

The intro to this article in the daily newsletter said:

"This article talks about a few issues with using views too extensively in your design."

It doesn't say anything AT ALL...

DiverKas (10/2/2012)

---

There are so many WTF's here. First, the argument where you can only access through views has been thoroughly debated and debunked, it shouldn't be held to high...

Hello all,

I see some excellent questions, suggestions, concerns and advise.

here are some of the answers that might come handy and helpful and I hope that we are all learning...

This is just a training piece for those that are new in security of schema and role buildings. There is nothing wrong with the select * .. as...

Actually the * is going to be replaced and will published shortly with selective columns.

However, you can always modify the new views, add, remove calculated field or like I mentioned...

This is a very good question.

Just recently we have hired a company to create intelligent KPI (key performance indicators) set for us. In addition to the NDA (non-disclosure agreement),...

This is very true what just got mentioned.

I did not get to the detail but yes you will have to do all that and watch the angles.

And, once you...

I am not sure actually 2 "set" commands in one update work... but see my reply posted here.. one SET is sufficient..

I could be wrong but I do recall...