Featured Article(s)
Tips for using SQL Server 2005 cursors
Here are some helpful tips to ensure you use SQL Server 2005 cursors in the most efficient manner possible.
SQL Server Licensing Reviewed
I know that, time after time, one of the questions that comes up as you work with people installing or just getting going with SQL Server is that of licensing. How does it work, where are the lines in the sand, etc. I noticed a couple of great blog posts that go into the licensing and what I thought was great was that the postings also look into how features impact the licensing. Specifically, how does failover impact licensing.
So, without further delay, check it out… Here’s part 1, and here’s part 2.
Video: SQL Server 2005 Jobs and Tasks
SelectViews special – how to work with SQL Server 2005 jobs, tasks and more. We’ll look at monitoring the job system, seeing what the status is, demo the steps to add a TSQL job (specific demo) and a lot more. This is a different format show – would love to have your feedback!
> Watch the show here
Other Video Programs/Shows available:
[Watch] SQLonCall – Creating Standards for Your SQL Server
[Watch] SelectViews – Accidental DBA Tips II, Security, Data Masking and more
Featured White Paper(s)
ESG Lab Validation Report of the HP PolyServe Database Utility for SQL Server
ESG Lab, the testing facility of industry analyst firm Enterprise Strategy Group, reports its comprehensive testing of HP’s s… (read more)
7 Steps to Successful SQL Server Auditing
This easy-to-read guide will explain and simplify the basic steps associated with successful SQL Server auditing & give you t… (read more)