Windows 2012 and .Net 3.5 Feature Install

Windows 2012 Sever RTM was this week, I can think of no better way of honoring it than to write a post on the first thing you will have to work around when installing anything that needs .Net 3.5.   While it is well know the .Net is a feature that must be installed separately, what…

25

SQL 2012 Security Audit 3 (Predicate and Failure)

This is the script to bring it all together.  In this case I have opted for just a server side specification with a filter on the database and exclusion of system objects.  You can certainly leave the access to system objects, however it will generate a significant number of audit entries.  I encourage you to…

2

SQL 2012 Security Audit 2 (Database Audit)

After mastering SQL Server Audit creation the next item is the database audit.  As the name indicates, the Database Audit is Database scoped, so it will focus to the database level actions.  This can be useful if you have a single database on the server, or perhaps even a single schema or even table you…

0

SQL 2012 Security Audit 1

While the SQL Server audit is not difficult to setup, I am still seeing many folks use and ask about SQL server side trace to address their auditing needs.  Though the SQL Server Audit is a bit confusing the first time or two you set it up it is vastly more flexible and much easier…

1

PASS 2012 Sessions posted

Nothing techy today, just a reminder that phase 1 of PASS early registration ends June 30.  The individual rate will go from $1395 to $1595 on July 1. You will have until October 1 before the rate jumps again. If you can find 4 friends to go with, the 5 of you can register at the…

0

Thank you, and Who is on my schedulers?

In the last two days I have had over 2000 page views on the two posts I have put up.  I know I am not that good of blogger yet and the posts are not riveting, so I can only assume that it is the work of Joe Sack and Grant Fritchey who have blasted…

0

SQL Server 2012 License Core Limitaion

Well, I wondered how long it would take before I got a case related the 2012 licensing change, looks like today was the day.  I will admit, it is confusing and at the end of the day it is usually not the fault of the DBA that you ended up with a 20 core license…

3

Surface and SQL

For my first post i can think of nothing better than mentioning the new Surface.  I recall when we demoed the original Surface about 4-6 years ago, depending on where you were at the time. As time goes by it will be more difficult to find a reference to it, but it will live on the…

0