Ryan, IMHO Filestream does not complicate life - it provides a dual view on BLOBS (the best of 2 worlds) when BLOB could be stored as a file but database...

FileTable does not support transactions, while Filestream does, plus in Filestream you have a choice to hide files from Windows 🙂

Do you know that there is an option to store files in SQL Server via SQL Server FILESTREAM technology since SQL 2008?

GPO (4/5/2015)

---

"The customer is always right." is a great principle but not an absolute. Especially when the customer comes to you with a problem and then proceeds to tell you...

Steve, I would suspect that this gig is heavily using EAV

From my personal experience with developers, some of them have no clue how to return auto-generated identifier after INSERT operation. 🙁

Both validation check and paging had been implemented in stored procedure - you are preaching to a church choir 😉

I had a wonderful conversation with BAs - they were...

In advanced search situation instead of creating acrobatic code on back end I just added a simple validation on front end that at least one input parameter has to be...

Jeff - from business prospective I have to deal with situations when a Customer of on-line Assessment system could bring their own definition of their curriculum (and trust me each...

Jeff Moden (9/15/2014)

---

fregatepllada (9/14/2014)

---

Larry - are you aware that since SQL Server 2008 R2 there is a data type HierarchyID?

If you using anything older than that version there is a...

Del

Larry - are you aware that since SQL Server 2008 R2 there is a data type HierarchyID?

If you using anything older than that version there is a Joe Celco book...

Yes, an antiquated COM way 🙂

Dwain you do not need CLR to use regex 🙂

There is an old way to call Vbscript library

From t-SQL code 😉

Does anybody try regex and XQUERY?