Red Fish Blue Fish

Abrar Ahmad_ (5/2/2016)

---

[font="Verdana"]After working in DBs (DEV - DBA) and specialized in SQL SERVER product for last 8 years, I tend to have expert opinion from board members that in...

stakes (5/2/2016)

---

Eric M Russell (5/2/2016)

---

However, the downside of this architectural approach is that I see a lot of queries written by the application developing teams that (in all fairness by...

Consider PRINT-ing the text to the SSMS Message window.

malefactor

[Mr.] Data

Where I work now, most instances are virtualized and that's the default configuration for all new instances, so we can scale them up if needed. What that means is that...

pietlinden (4/30/2016)

---

LOL...

<insert TERRIBLE advice here> ... and don't forget to ascribe to someone who actually knows what he's talking about.

Sorry, couldn't resist!

The question reminded me of some "documentation" of a...

Yes, you can prevent the web application from interrogating employee SSNs by implementing role based security and abstracting the application from the employee table(s) by using stored proceure(s). Ideally, you...

If you really want, you can also model an entire database containing objects with only spaces for names.

create database [ ];

GO

use [ ];

GO

create schema [ ];

GO

create table [...

Jeff Moden (4/28/2016)

---

Apologies. I'm not going to get to this tonight or tomorrow. I'm in the middle of a server migration and I need to sanitize the code...

Sergiy (4/28/2016)

---

http://opendata.stackexchange.com/questions/5595/how-should-us-ssn-be-anonimized

Since SSN has only 9 digits, changing hash function will not suffice because attacker can simply apply the function to all 10^9 SSN's and match the result against the...

You don't want indexes on a table that arn't being used (don't benefit queries or insure uniqueness), because they require I/O to maintain whenever the table is inserted, updated, or...

Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

https://www.microsoft.com/en-us/learning/exam-70-463.aspx

A table lock (TABLOCK) will improve the performance of a bulk table insert, but it will also hold a lock on the entire table. If you can tolerate somewhat longer...