The Weekly News for November 19, 2007
A few comments on the news of the past week: SQL Server 2008 CPT5, a 1.6SSD Array, Non-Compete agreements and more.
Declarative Management Framework - Performing Policy Management
The Declarative Management Framework is a new policy based management framework included with the upcoming SQL Server 2008. Using this feature administrators can define policies to govern their SQL Server environments much like in the Windows environment. This article, written based on the SQL Server "Katmai" July CTP introduces you to the DMF and shows you how you can perform policy management.
Importing Text-based data: Workbench
Robyn and Phil return with some fresh ideas about how to import text files into SQL Server, without resorting to DTS or SSIS scripting. They go on to show how much can be done in TSQL
SQL Server Job Scheduling
The scheduling system in SQL Server is quite flexible and powerful, but can be confusing at times. Peter He looks at some of the advanced options you have in automating the various jobs on your server.
Create a Custom Test Interface Provider for Team Sytem
This article looks at fuzzy testing and how to build a provider for your own use.
SQL Server 2005 Database Options and Configuration Performance Audit Checklist
As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.
Rethinking Analysis Services
Integrate SQL 2005, ASP.NET, Reporting Service and Analysis Services to rapidly develop and deploy a survey application for data entry and results analysis.
Brad McGehee On Being a Better DBA!
Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.
Calculate Percentiles with SQL Server 2005
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers