What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them, it just names...

I agree with TomThomson - This msdn page says "The bcp utility is written by using the ODBC bulk-copy".

I'd say that means it does indeed use an ODBC connection to...

Thanks to all our service men and women who have given so much so we can live the way we do.

Anyone looking for a good book related to Memorial Day...

We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can be tuned to provide the biggest...

Whew, I'm not the only one.

Great question, thanks for sharing!

I loved Clancy's first nine books, but Red Storm Rising was my favorite. After the first nine they all seemed to be about the same thing with slightly different...

terry.home (3/28/2015)

---

Thanks for sharing the script.

Whilst I appreciate what you are doing and that you have shared your script, I am just wondering if it is not simpler and...

This seems like a good idea, but I can't imagine having time to set up these tests. Do many companies really run these types of test on their database...

+1

I totally agree with that last idea about the blog. I started one about four months ago as a way to learn more, inform potential employers about my knowledge...

This is a great question. I was unclear on this my first half year as a DBA. My lack of knowledge never caused any mistakes, but once I...

What would be the purpose?

archie flockhart (3/4/2015)

---

Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work as...

Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?