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?

Fortunately, there are often free products that are only slightly less effective than their paid counterparts. For example, if your employer won't pay for SQL Prompt, you can always...

Being an avid fisherman, I've always thought there would be great value in a site where you could share fishing results and in return, receive other people's results. If...

It's looking like most here have never used this, me included. Does anyone have any real world examples?

We're on 2008 R2 Enterprise at my shop and we've cancelled plans to upgrade to 2012 because of the costs. Once Microsoft stops supporting 2008 R2 I believe we'll...

Cool stuff. In my last job I had to set this kind of stuff up using VBA or a bunch of formulas behind the scenes. Good to know...

Wow, I didn't understand synonyms to be so abstract. Thanks for the question!

I'm getting to this one a day late, but as written it now returns NULL:

DECLARE @OUTPUT VARCHAR(max);

SELECT @Output = @Output + SPECIFIC_SCHEMA + '.' + SPECIFIC_NAME + Char(13) + Char(10)

...