SQL Server A to Z – Audit

In previous versions of SQL Server, there were a number of methods for auditing activity within an instance or database.В  You could use DDL triggers to track any DDL changes, login auditing to write login successes or failures to the error log, Profiler tracing, and even C2/Common Criteria Compliance Auditing.В  But each of these methods [...]

July 8, 2011  Tags: , ,   Posted in: Features  No Comments

Stuff I learned today – Table Types

Since SQL Server 2000, you’ve been able to create variables of type TABLE, but you needed to define that table structure when (and each time) you declared the variable. You also couldn’t pass these table variables into a stored procedure. SQL Server 2008 introduced the user-defined TABLE datatype. Now you can create and store custom-made [...]

June 8, 2011  Tags: ,   Posted in: Features, T-SQL  No Comments

Stuff I learned today – hierarchyid

I’m in training this week. Since I was restricted to a local class, I decided to take one focused on development, rather than dba-related topics, and get some exposure to facets of SQL Server I don’t normally deal with on a day-to-day basis. And I figured I’d share some of my newly garnered knowledge with [...]

June 6, 2011  Tags: , ,   Posted in: Features, T-SQL  No Comments

Resource Governor causing memory problem??

So.В  Last week I blogged about the experiment I was running with Resource Governor for one of our newly upgraded development databases.В  I had enabled Resource Governor and created a procedure to categorize sessions, but I hadn’t set any limits and everyone was sharing the same default pool.В  The plan, if you’ll recall, was to [...]

April 22, 2011  Tags: , , ,   Posted in: Features, Troubleshooting  One Comment