Browse by Tags

Sorry, but there are no more tags available to filter with.

Plan Freezing with SQL Server 2008

By Ronald Barrett With the advent of SQL Server 2008, many DBAs worry about issues that sometimes arise with updating query plans during the upgrade process. Plan Freezing allows you to store plan guides, which can be reverted to if queries either fail or drain resources after the upgrade. Plan Freezing...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-21-2008
Working with Pipelines

By David Chernicoff TechNet Virtual Lab: Working with Pipelines does a good job of pulling the covers off of some basic BizTalk functionality by walking the user through the process of configuring Biztalk and setting up a custom pipeline. By providing the bulk of the project in predefined form, Microsoft...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-19-2008
SQL Server 2008 Analysis Services: Delivering Analysis Services Capabilities through Microsoft Office

By Ronald Barrett Yet again another virtual lab title which had me thinking “That’s a mouthful”, but one must admit the idea of using Analysis Services in Office is in itself a great motivator for moving forward with this lab. Anytime you can move data from the SQL Server and into users’ hands via a...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-18-2008
SQL Server 2008: X-Event Infrastructure

By Ronald Barrett A new feature of SQL Server 2008 is the SQL Extended Events (a.k.a. the X-Event Infrastructure), while event reporting is not a new feature in SQL Server products. X-Event is an exciting new event infrastructure that allows for detailed traces of what is happening within the SQL Server...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-13-2008
SQL Server 2008 Reporting Services Enhancements: Report Designer, Visualizations, and Tablix

By Ronald Barrett When I first saw the title of this virtual lab I thought it would be shorter had they called it “everything but the kitchen sink”. But seriously as daunting as the name sounds, and as difficult as the lab might be deemed based upon the name, the areas covered in the virtual lab all...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-12-2008
SQL Server 2008: Change Data Capture

By Ronald Barrett The dynamic nature of databases, and in particular data warehouses, calls for a method of updating, inserting and deleting activity in a SQL server table. But change data capture is not only about the physical change of the database, it is about the ability to report on and track these...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 03-11-2008
SQL Server 2008: Declarative Management Framework (DMF)

By Ronald Barrett Day to day management of SQL Servers can be a time consuming task, especially in large data intensive environments. SQL Server 2008 has introduced a management tool to help alleviate some of the Administrative overhead associated with database management. Before we move into the Virtual...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 02-29-2008
SQL Server 2008: Database Mirroring

By Ron Barrett We have reached a point in business where recovery from failures needs to happen in seconds not minutes. When I was an IT Director for a Financial Services firm in NYC, partners would remind me daily that every time the databases for our CRM, Financial Applications or Time and Billing...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 02-28-2008
Going beyond relational data with SQL Server 2008

By Haidong Ji SQL Server 2008 will be released in the first half of 2008, about six months from now, so it's time for me to get a good feel of the new features and enhancements in this exciting new release. Fortunately, Microsoft TechNet provides a series of webcasts to get us started, beginning...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 01-10-2008
Performance Monitoring and Troubleshooting with SQL Server 2008

By Haidong Ji The New Performance Monitoring and Troubleshooting Using Management Studio webcast gives you a great walkthrough of the new features of SQL Server 2008. SQL Server 2005 introduced Dynamic Management Views (DMVs), which greatly enhanced DBA’s understanding of the internal working of the...

Posted to IT Pro Tips (Weblog) by itprotipsadmin on 01-09-2008

Page 1 of 1 (10 items)

FEATURED LINKS

Order Your SQL Fundamentals CD Today! Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions. Free Online Event! Virtualization:Get the Facts!Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)! Check Out Hyper-V Video on ITTVWatch Karen Forster's interview on Hyper-V's performance on ITTV.net. Ease Your Scripting Pains with the Flexibility of PowerShell!Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer! PASS Community Summit 2008 in Seattle on Nov 18-21The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.