Yeah, but could you reproduce the non-blocking behaviour?

With the exception of secure document storage, I don't see the point in containing BLOBs in a relational database. With what you're suggesting, the website would hit your database whenever...

I actually can't reproduce this. I'm using SQL Server 2014, and Session 2 WILL wait for Session 1 to commit on the 2nd run, which is what we'd normally expect...

You can do a brute force dictionary query against the sys.sql_logins table to discover the password for any sqlserver login, including 'SA'.

declare @pw table (pwtext varchar(180) not null primary key);

...

Ed Wagner (12/23/2015)

---

Alvin Ramard (12/23/2015)

---

Eric M Russell (12/23/2015)

---

Alvin Ramard (12/23/2015)

---

Eric M Russell (12/23/2015)

---

Putting your data in the cloud: that's then you save a backup to external disk, and then have...

Alvin Ramard (12/23/2015)

---

Eric M Russell (12/23/2015)

---

Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for...

Because it can be shared across multiple...

Putting your data in the cloud: that's then you save a backup to external disk, and then have it boosted up the Space Station for safe keeping; right? :Wow:

Alvin Ramard (12/23/2015)

---

Ed Wagner (12/23/2015)

---

mjh 45389 (12/23/2015)

---

Eric M Russell (12/23/2015)

---

Eric M Russell (12/23/2015)

---

mjh 45389 (12/23/2015)

---

I was in a shop at the weekend and they were selling external hard drives as...

sql_novice_2007 (12/23/2015)

---

Hi I have a ZipCode column in the address table and this column has some invalid zipcodes like 'a36477','445-2'.

I am trying to write a query to select only those...

But regardless of the implementation, you need to let the developers know this deployment isn't going into production until after New Years at the very least. Has this been tested...

I generally contain things like CRM Comments, Phone Numbers, and often times Status Codes in a separate table. They are not 1:1 static attributes in the same way that SSN,...

Matt Miller (#4) (12/22/2015)

---

Hmm that reminds me of some quotes I...

The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.

Eric M Russell (12/23/2015)

---

mjh 45389 (12/23/2015)

---

I was in a shop at the weekend and they were selling external hard drives as 'Private Clouds'! Things like this are not going to...