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...

Here is a little ditty I coded up yesterday to return a quick and dirty difference comparison between two tables having identical column definition and overlapping rowsets. It's new, but...

We already have the SSMS Template Browser to cover commonly used commands and DMV queries.

However, the MERGE statement is complicated enough that it could use a GUI helper, if that...

An hour long pre-recorded video covering generic IT security topics, something the employees watch alone from their desk during a lunch break, probably doesn't count for much, if they've seen...