Matt Miller (#4) (8/24/2015)

---

Eric M Russell (8/24/2015)

---

When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific...

When I write unit tests, it gets run in both development and QA. Each unit test is a script that maps to a specific functional requirement. A test plan lists...

All of the functionality you just mentioned (logging record counts, event handling, scheduling, email alerts, etc.) are basic functionality of SSIS and SQL Server Agent.

Jeff Moden (8/24/2015)

---

Eric M Russell (8/24/2015)

---

It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an...

It seems to me that, even in the event of a catastrophic computer system failure, an airplane should still be functional enough to make an emergency landing under manual control.

maxlezious (8/24/2015)

---

Eric M Russell (8/24/2015)

---

maxlezious (8/24/2015)

---

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All...

maxlezious (8/24/2015)

---

Thanks for your reply!

I currently have a job setup which runs the stored procedure every week and inserts the usage figures in a table. All i am looking for...

Hopefully you are converting all your "CharDate" columns to Date and never looking back. However, if there will still be some tables or databases containing formatted date values in Char...

Grant Fritchey (7/30/2015)

---

You might be facing a bit of an issue here. I'm assuming you're planning to do log shipping after a restore to get the 2000 database to 2014?...

You can find plenty of articles on SQLServerCentral or YouTube videos explaining how to write secure code. It would be easy for an organization to provide their developers with relevent...

The training is probably more about legal procedure, having each employee acknowledge that they've been informed of specific security policies. For example, there is no reason for someone to plead...

I can understand GenY application developers right out of university wanting to bypass the grumpy DBA middleman and code directly against an object database that they control themselves. The presenters...

You'd think that folks would know better, but having dealt with a large number of development, UAT, and production servers; this script actually returns some surprises on occasion. It may...

Here is a script I use to grant (or request for myself) "power user" permissions without the need for full sysadmin membership.

-- server level permissions:

use master

-- grant user permission to...

djackson 22568 (8/21/2015)

---

ZZartin (8/21/2015)

---

/shrug it's a compliance issues, it's not supposed to be useful and the vast majority of it can be summarized as use common sense.

We have to go...