Welcome to Sign in | Join | Help

decembrie 2011 - Posts

Late tonight I tried something that I didn't think would work because @@version on SQL Azure didn't report anything different from last week. (Microsoft SQL Azure (RTM) - 11.0.1814.30 Nov 21 2011 16:46:09 Copyright (c) Microsoft Corporation). Read More...
I am no longer part of the SQL Server team, but I still have a lot of passion for security and SQL Server, so I am reviving this blog. I cannot promise to write articles on a regular basis anymore, but if you are interested in any topic for SQL Server Read More...
It's gotten around to the week of the Portland, Oregon, SQL Server User Group meeting. And there's not only going to be a holiday dinner, but I've volenteered to speak again. This time, it's about parameterization and autoparameterization Read More...
Got to take some time out from research and writing because yesterday Paul Randal announced SQLskills' first series of SQL Server Immersion training classes for Spring of 2012 in Chicago. They'll be 4 (count 'em) immersion-level class for Read More...
... Continued from previous blog entry ... The point of using a Server Audit Specification with database events in SQL Server 2012 is this. In SQL Server 2008, audit is an Enterprise-only feature. Only available in Enterprise, Evaluation, and Developer Read More...
I've always been pretty "standard" in my approach to SQL Server's auditing feature. That is, Server Audit Specifications are for auditing server-level objects and Database Audit Specifications are for auditing database-level objects. Read More...
When I installed CTP3 of SQL Server 2012 (on Windows Server 2008 R2 OS), I noticed that the "Service SID account" (known as the Managed Service Account) was directly available in the setup dropdown box, selected it, wrote a blog entry mentioning Read More...