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

Tim Walker. (8/21/2015)

---

Eric M Russell (8/20/2015)

---

GilaMonster (8/20/2015)

---

The logical reads should be the same with identical plans....

GilaMonster (8/21/2015)

---

podmate (8/20/2015)

---

I have never worked for a tech employer that would pay you for training or encouraged you to train on company time (barring being sent offsite for training...

Eric M Russell (8/20/2015)

---

ZZartin (8/20/2015)

---

Eric M Russell (8/20/2015)

---

Jeff Moden (8/20/2015)

---

Iwas Bornready (8/20/2015)

---

I just worry about the programmers that want to "fix" something that isn't broken, just to make it more...