Dan's Blog - All Comments

re: Loading SQL Server Snapins into your PowerShell Session

Martin Rousev — Fri, 29 Mar 2013 15:35:37 GMT

What is SqlServerProviderSnapin110 and how do I obtain it?

re: Where the Heck is DMO?

ArthurZ — Wed, 08 Aug 2012 03:10:01 GMT

Based on my findings the SQL Server 2012 production release does no longer support SQL-DMO.

It is not part of its Feature Pack either: www.microsoft.com/.../details.aspx

re: Designing for Security

Dan Jones MSFT — Fri, 20 Jan 2012 01:54:53 GMT

Thanks Brent. Insightful as usual.

re: Designing for Security

Brent Ozar — Fri, 20 Jan 2012 00:59:53 GMT

By "less sensitive information" he means things like clickstream data. I'm working with a client today that's putting every mouse movement on their web site into SQL Server - on the same database server that houses their orders, inventory, and credit card data. With your experience, you can guess which kind of data is absolutely dominating the buffer pool, and in order to get increased performance on the transactional data, we need to separate out the clickstream data into another instance, another server, or another platform altogether. With SQL Server 20012's Enterprise Edition licensing running $7k per core, it was a pretty easy decision to move the clickstream data into NoSQL.

"As I said, adding security after the fact is extremely hard." And Microsoft should know, right? After the default blank SA passwords, the Slammer problems, finally putting TDE in SQL 2008, and still requiring SA access for third party backup software that needs to use the VDI interface, we live in a glass house and we shouldn't be throwing stones.

re: Oracle Unbreakable == Oxymoron

Stephen Wells — Wed, 18 Jan 2012 21:33:55 GMT

Keep in mind that Microsoft released a out of band critical security patch for ASP.Net only 20 days ago.

I don't think anyone is immune to security holes in a large system, it is about managing the problems in a safe way.

re: Oracle Unbreakable == Oxymoron

Papy Normand — Wed, 18 Jan 2012 21:07:26 GMT

www.thefreedictionary.com/oxymoron is where i found the definition of oxymoron ( or oxymore ). I am sorry but the english language is not my mother tongue so a philology word : i discovered it

My own Oracle experience was short 12 months in 2003 , so i see that Oracle is meeting also security problems

re: Refreshing the IntelliSense Cache

bob — Tue, 29 Nov 2011 19:01:42 GMT

Thank you. I was restarting SMS to get it to work.

re: Be a Virtual SQL Server Team Member

Víctor M — Thu, 13 Oct 2011 22:44:18 GMT

Hi Dan,

being so, where I can get my shirt? :D

Good work team. I really like the Microsoft path for CTP releases format: to complete development details, get bugs and take care about community comments. Keep pushing forward!

re: SQL PASS PowerShell Session Materials

Andy Lohn — Thu, 13 Oct 2011 19:42:54 GMT

Excellent work - thanks for getting this out here so fast.

re: Refreshing the IntelliSense Cache

Goran — Thu, 13 Oct 2011 09:11:54 GMT

Thanks!

I'm sure it's very valuable tip to a lot of us!