Featured Article(s)
Script Demo: DM like Views representing sp_spaceused data
A "DM View"-like view is described which returns sp_spaceused statistics for the tables of the database the view is created in. …includes both an SS2K compatible version, and an enhanced SS2K5 version
Did You Watch the Latest SQL Server Show Yet?
Posted Friday – Watch it Here. (Show is open access to everyone)
Boost SQL Server Performance
Did you know that you can boost SQL Server performance by as much as 500%? It’s true. I get a lot of questions asking about tuning, how to configure SQL Servers when splitting up workloads between servers for transaction vs. reporting-type solutions. You can make a lot of headway in the performance department for your servers without even having to rearchitect your applications. Check out RamDisk Plus – Microsoft tested and certified for compatibility, RamDisk Plus can make a huge difference in query and response time on your server. Get more information here.
Unlocking SQL Server Infrastructure Consolidation
Consolidating SQL Server database servers represents an efficient path to infrastructure optimization, with significant benefits to IT. With the right approach, a consolidated framework cures low server utilization, assures availability and dramatically lowers the time and costs spent managing SQL Server environments. Join this webcast, presented by HP PolyServe Database Utility for SQL Server, and learn how a utility approach can enable you to: – Reduce by half the number of servers needed for SQL Server – Decrease storage requirements and software images for comprehensive cost reduction – Provide robust failover and DR services for every server, easily and cost effectively – Reduce the time required to manage servers, storage and O/S patches by as much as 75% – React to capacity changes in 30 seconds for real-time scalability Presented by HP PolyServe (www.polyserve.com)
> Register Now
> Webcast Date: 8/28/2007 at 12:00pm Noon Pacific
SQL Server Optimization and Data Protection with Intelligent ISCSI SANs
More and more companies are deploying storage area networks or SANs as storage needs continue to proliferate. SANs deliver many unique capabilities that improve data protection, storage performance and scaling, and reduction in storage management time. Intelligent iSCSI SANs offer an affordable, enterprise-class choice in SAN technologies. We will review best practices in deploying SQL Server in an intelligent iSCSI SAN, and the resulting dramatic improvements in deploying, optimizing, backing up, and recovering SQL. Presented by EqualLogic (www.equallogic.com)
> Register Now
> Webcast date: 8/29/2007 at 12:00pm Noon Pacific
Fantasy Football Quick Note:
If you sent in your request for the Fantasy Football league, you’ll be receiving an email from Yahoo! sports with your login information. We’re going with an automated draft this year to really stir things up. Trades will be interesting. Keep your eyes peeled for that email!
Registration is currently closed for the leagues. It’s going to be a record year!
Featured White Paper(s)
Foolproof Upgrades for SQL Server 2005
SQL Server 2005 is a major new release of Microsoft’s flagship database platform. But how do you know when is the right time … (read more)
Data Privacy Compliance in the Application Testing Environment – Data Masking and Transformation for Privacy Compliance
News of high-profile data breaches has increased awareness and heightened the need to protect data privacy in the more vulner… (read more)
SQL Injection: What it is and how to prevent it
SQL injection is the hacking technique which attempts to pass SQL commands through a web application for execution by a backe… (read more)