Jeff Moden (7/12/2016)

---

HappyGeek (7/11/2016)

---

quentin.harris (7/8/2016)

---

True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.

It seems to be...

It could be that the sessions performing updates on this table as part of a larger batch transaction. Often times programming will begin a transaction, update, and then do some...

What you're dealing with is probably blocking of some time. To get to the bottom of this issue, during these occasions where query latency is extremely long, you need to...

djackson 22568 (7/11/2016)

---

Japie Botma (7/11/2016)

---

djackson 22568 (7/11/2016)

---

What could possibly be embarrassing about...

quentin.harris (7/8/2016)

---

Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords....

David.Poole (7/11/2016)

---

Japie Botma (7/11/2016)

---

What about POPI laws? (Protection of Personal Information Act). If your data is in the cloud and the whereabouts of the actual server can change with...

I have a hanful of suggestion for making smart phones more secure.

First, I understand why Apple and Samsung manufactore their phones in cheap overseas sweatshops; it's all about economics. However,...

It's funny how, just within the past few years, 2 billion regular folks around the globe are burdened with the responsibility of being an accidental system administrator for a tiny...

SQL!$@w$0ME (7/7/2016)

---

Hello Folks,

Is it a good practice to create clustered index on non-primary key columns since the primary key column is not queried at all. Please share your thoughts or...

The Need for Developers Who Are Literate About Relational Database Design

TheFault (7/7/2016)

---

Iwas Bornready (7/7/2016)

---

Over forty years ago one of my advanced math classes had a problem about how to aim a moving sub's torpedo at a moving ship and hit...

The SoundEx fuzzy matching algorithm for comparing names dates back to Franklin Roosevelt era paper and microfilm records archiving.

https://www.census.gov/history/www/genealogy/decennial_census_records/soundex_1.html

Restore

Steve Jones - SSC Editor (7/6/2016)

---

David.Poole (7/6/2016)

---

If we are planning to do a continuous delivery system for vehicle software then we need to have some heavy weight software engineering that...

xsevensinzx (7/6/2016)

---

Eric M Russell (7/6/2016)

---

Although you can technically store unstructured data in SQL Server, the question is: Why would you?

If you're ultimately trying to import facts and dimentions (as properly...