Be sure to check these out: White Paper: Security Overview for Database Administrators 2008.   http://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-security.aspx SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as ...

I wanted to take a minute to draw some attention to a few things in this month’s SQL Server Magazine.  If you’ve gotten your copy of SQLMag, you’ll notice poster that's a really great reference guide for SQL Server system stored procedures.  This outstanding poster can hang in your cube or office and outlines the function and syntax of ...

For some reason, the title of this blog post makes me grin because it evokes a mental image of one guy trying to comically strangle another guy.  But I digress…   Speaking at a user group meeting recently, an attendee asked whether the mirroring process had any capability to speed up or slow down its workload according to the amount of ...

As with all of the blog posts I keep meaning to write -- I keep a list and given the infrequency with which I've been posting lately, it's getting quite large -- this script has been on the queue for quite some time. So here I find myself with a spare moment right on the cusp of the new year, and figured what better way to end the year than with a ...

Join me tomorrow for a webcast on SQL Server backup and recovery. Here are the details:  Tuesday, April 24, 2007 2pm Time Zone:Eastern Time (US & Canada)         Seminar Name: LiteSpeed/ SQL Server 2005 Presenter: Kevin Kline/Andrea Schneider  Are you looking for a solution that can help ...

If you're a fan of the MSDN on-line search tool for the SQL Server 2005 Books On-Line (BOL), you might want to try a new tool.  The new search tool is available at http://search.live.com/macros/sql_server_user_education/booksonline and offers more precise and targeted search results than MSDN.You can investigate creating your own Windows ...

As I've been traveling around speaking at various SQL Server user groups, I get requests for my slide decks.  Of course, I'm happy to share those, but I've got one better for you.  As it turns out, you can find five of my most recent webcasts here.  These are recorded webcasts that you can listen to any time.  I believe that ...

SQL Server MVP Kent Tegels recently raise an interesting question. SQL Server publishes a number of performance counters. In the code he's written that publishes performance counter data, he's had to explictly code the counter updates within his code regardless of knowing if any processes were consuming those ...