TechNet Magazine Blog

The official blog of TechNet Magazine

Browse by Tags

Related Posts
  • Blog Post: The March 2007 issue of TechNet Magazine is now available online

    The March 2007 issue of TechNet Magazine is now available online at www.technetmagazine.com/issues/2007/03/ . This month, TechNet Magazine contributing editor and Microsoft technical fellow Mark Russinovich continues his three-part series entitled Inside the Windows Vista Kernel . This month looks at...
  • Blog Post: TechNet Magazine February 2009 Is Now Available Online

    The February 2009 issue of TechNet Magazine is now available online. Discover how you can use Excel and SharePoint to provide Business Intelligence in your organization, learn about logging and recovery in SQL Server and learn how to maintain a better database, see how you can automate the deployment...
  • Blog Post: Top Tips for Effective Database Maintenance

    In the August 2008 issue of TechNet Magazine, Paul Randal offers invaluable guidance to involuntary DBAs (those people who are not trained database administrators but somehow end up responsible for a database). In the article, Paul gives a crash course on key tips for effectively maintaining a production...
  • Blog Post: SQL Server 2008: Advanced Troubleshooting with Extended Events

    "SQL Server DBAs the world over have a problem that never seems to go away: troubleshooting—with the vast majority of troubleshooting being done to find a performance problem of some kind."   In the January 2009 issue of TechNet Magazine , which is now available online, Paul Randal...
  • Blog Post: Know when not to Maximize Data Throughput for Network Applications

    Find out about one scenario in which you should avoid the Maximize Data Throughput For Network Applications setting . Follow our daily tips: • facebook.com/TechNetTips • twitter.com/TechNetTips • blogs.technet.com/tnmag
  • Blog Post: SQL Server 2008: Security

    SQL Server 2008 may be a mature product, but security continues to be an area of deliberate improvement. The new release includes numerous enhancements and new features that can help you improve the overall security of your database environment. You get new encryption and authentication capabilities...
  • Blog Post: New TechNet Webcasts, Podcasts, and Virtual Labs on SQL Server 2008 and Exchange Server 2007

    The TechNet Online team has just posted two new series of webcasts, podcasts, and virtual labs about SQL Server 2008 & Exchange Server 2007. These are not only useful - but entirely free - resources. Take a look!   SQL Server 2008: Access Your Data Any Place, Any Time See how the business intelligence...
  • Blog Post: A Month of SQL Server Tips - Week 3

    This month, TechNet Magazine is bringing you A Month of SQL Server Tips .  We're posting a new tip every day, Monday through Friday. Here are the tips from the third week of January 2009. Ways to Find out What Data Was Deleted by SQL Server Repair In the unfortunate case that you have to use the...
  • Blog Post: Change Settings with ALTER DATABASE in SQL Server 2008

    The ALTER DATABASE statement replaces sp_dboption as the preferred way to change database settings in SQL Server 2008. Here’s what you need to know . Follow our daily tips on: Twitter | Facebook | blog | Web | RSS
  • Blog Post: Optimizing SQL Server Query Performance

    Even if your database server runs on the most powerful hardware available, its performance can be negatively affected by a handful of misbehaving queries. In fact, even one bad query, sometimes called a "runaway query," can cause serious performance issues for your database. Conversely, the overall performance...
  • Blog Post: TechNet Magazine January 2009 Issue Available Online

    The January 2009 issue of TechNet Magazine is now available online. Learn about Identity Lifecycle Manager 2, delve into Group Policy Preferences, get an overview of advanced SQL Server troubleshooting with Extended Events, discover a handy free utility for managing USB flash drives, and more. FEATURE...
  • Blog Post: August 2008 issue of TechNet Magazine available online

    The August 2008 issue of TechNet Magazine is now available online. FEATURE ARTICLES Far too often, people who are not trained database administrators end up responsible for managing one or more databases. In the latest issue of TechNet Magazine , Paul Randal offers a crash course for all those involuntary...
  • Blog Post: Hey, Scripting Guy! - Relationships Matter

    Relationships do matter. But how would the Scripting Guys, of all people, know that relationships matter? TV Or so they say. You'll have to read their Hey, Scripting Guy! column in the September issue of TechNet Magazine to find out why. While you're there, you may just learn a thing or two about how...
  • Blog Post: Get Your SQL Questions Answered

    Hey SQL Server users! For the past couple of years we’ve been using the TechNet Magazine SQL Q&A column as a forum to share the kinds of problems customers bring to support personnel and the solutions to those problems. As you’ll see if you visit our archive , we like to field all sorts of...
  • Blog Post: SQL Server 2008: Track Changes in Your Database

    "For developers, one difficult problem in SQL Server is tracking what data has changed in a database. An even greater challenge is architecting a simple solution that doesn’t heavily impact workload performance and isn't difficult to create, implement, and manage. So why go to all the trouble...
  • Blog Post: How to use Windows PowerShell to Manage SQL Server

    Get an overview of how you can use Windows PowerShell to manage SQL Server 2008 and learn the basic syntax you’ll need to know. Follow our daily tips: • facebook.com/TechNetTips • twitter.com/TechNetTips • blogs.technet.com/tnmag
  • Blog Post: SQL Q & A: Memory Configuration, Performance Profiling, Setting Your Fill Factor, and More

    You’ve got questions, we’ve got answers–and tips. Here’s what our experts cover in the December issue: Q: I’m trying to figure out the best memory configuration for my SQL Server boxes. Q: Can I use my server’s IP address now in SQL Server 2005 Replication to indicate...
  • Blog Post: A Month of SQL Server 2008 Tips - Week 1

    In December, TechNet Magazine brought you a new Windows Vista tip every day , Monday through Friday.  This month, we're delving into SQL Server 2008 .  Here's a roundup of the tips we've published so far. Customize Memory Allocation for Queries in SQL Server 2008 By default, SQL Server 2008...
  • Blog Post: SQL Server 2008: Learn About Manually Tweaking Parallel Processing Settings

    Here’s a quick look at setting parallel processing options in SQL Server 2008. Follow our daily tips: • facebook.com/TechNetTips • twitter.com/TechNetTips • blogs.technet.com/tnmag
  • Blog Post: April 2008 issue of TechNet Magazine available online

    The April 2008 issue of TechNet Magazine is now available online at http://technet.microsoft.com/en-us/magazine/cc405670.aspx . The April 2008 issue of TechNet Magazine is available online, offering a host of information about SQL Server 2008. Randy Dyess kicks things off with an overview of what's new...
  • Blog Post: New SQL Server Utility and Utility Control Points in SQL Server 2008 R2

    Get an overview of how to use the new SQL Server Utility and Utility Control Points in SQL Server 2008 R2. Follow our daily tips on: Twitter | Facebook | blog | Web | RSS
  • Blog Post: SQL Q&A: Backup Compression, Client Redirection with Mirroring, and More

    Have SQL Server questions?  Paul Randal has answers.  Here's what you can find in the February 2009 installment of the TechNet Magazine SQL Q&A column, which is available online now. Question: We're going to be upgrading most of our servers to SQL Server 2008, and one of the features that...
  • Blog Post: SQL Q&A: Non-Clustered Indexes and Retaining Permissions

    The ever-changing and ever-growing databases you have to manage these days can really keep you on your toes. There are always new problems to tackle and new questions to ask.  Every other month (it used to be monthly, but now we're answering Exchange questions also), we get database experts to answer...
  • Blog Post: The Basics of SQL Server Policy-Based Management

    Get a brief overview how to use policy-based management to manage SQL Server in your organization. Follow our daily tips: • facebook.com/TechNetTips • twitter.com/TechNetTips • blogs.technet.com/tnmag
  • Blog Post: Configure SQL Server Agent to Restart Services Automatically

    Here are 4 easy steps to keep SQL Server running while you get more sleep. Follow our daily tips: • facebook.com/TechNetTips • twitter.com/TechNetTips • blogs.technet.com/tnmag