Kyrilluk (5/26/2015)

---

It would be nice to have this scientific method to all the blab about security as well. Like "I shouldn't give the sysadmin password to the developers because of...

robin.pryor (5/26/2015)

---

The company I work for insists on being really liberal with db_owner. For the most part, that's not a problem, but security is an issue. Is there a way...

Wayne West (5/25/2015)

---

Ross McMicken (5/25/2015)

---

GPO (5/23/2015)

---

Of course all of this assumes your DBA or sysadmin is beyond reproach. I worked as a bank clerk many years before I'd ever heard...

Gary Varga (5/22/2015)

---

Eric M Russell (5/22/2015)

---

Gary Varga (5/22/2015)

---

Eric M Russell (5/22/2015)

---

T_Peters (5/21/2015)

---

I've run into various naming conventions that have caused problems over the years. One of my favorites was naming...

Gary Varga (5/22/2015)

---

Eric M Russell (5/22/2015)

---

T_Peters (5/21/2015)

---

I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow...

The high level data flow depends on the sequence for which the application calls the stored procedures, so perhaps ask the application team if they have a diagram. Also, running...

mrl6254 (5/21/2015)

---

I’m involved in an application where a database is to be migrated over to a new server.

I have been told that numerous applications each today with their own database...

T_Peters (5/21/2015)

---

I've run into various naming conventions that have caused problems over the years. One of my favorites was naming printers after the 7 Snow White dwarfs. It was a...

If you feel confident that this particular query should always leverage the non-clustered columnstore index, then have you tried an index like so?

WITH (INDEX (IX_EmployeeReview_CS))

Executive managment has requested that available MB disk storage (zero padded to 10 digits) be appended to the end of all server names. You know... as a convenience for the...

dmbaker (5/21/2015)

---

Because when I'm querying a London server from Seattle, I like to know that I can step...

Why is including location in server name important for some?

Server names that include it's physical location are problematic when the server is relocated to a different data center. Like wise a name like MSSQL2012 is problematic when it's upgraded....

Gary Varga (5/21/2015)

---

A recent client had a system where known potential faults, e.g. missing data that cause overnight job failures, had a documented resolution. These resolutions where not aimed at...

It looks like the results are for a handful of tables in MASTER database. When running the script, change context to database containing...