See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
TechNet Magazine Blog
The official blog of TechNet Magazine
Exchange 2007 Sp1
High Performance Computing
Inside the Magazine
Mobile Device Manager
Network Access Protection
Office Communication Server
Software plus Services
USB Flash Drives
Windows and Macs
Windows Compute Cluster Server
Windows Deployment Services
Windows PE 2.0
Windows Server 2008
Browse by Tags
TechNet Magazine Blog
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...
14 Mar 2007
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...
13 Jan 2009
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...
17 Jul 2008
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...
17 Dec 2008
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
3 Jun 2010
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...
16 Apr 2008
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...
20 Nov 2008
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...
27 Jan 2009
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
9 Apr 2010
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...
19 Nov 2007
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...
9 Dec 2008
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...
14 Jul 2008
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...
28 Sep 2007
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...
25 Jan 2007
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...
16 Oct 2008
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
19 Oct 2010
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...
13 Dec 2007
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...
9 Jan 2009
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
4 Jun 2010
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...
7 Apr 2008
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
11 Apr 2010
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...
24 Jan 2009
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...
29 Feb 2008
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
19 May 2011
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
20 Oct 2010
© 2015 Microsoft Corporation.
Privacy & Cookies