Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

Common SQL Server Security Issues and Solutions

In the August 2008 issue of TechNet Magazine, Paul Randal wrote an article Top Tips for Effective Database Maintenance .  It was geared toward "involuntary  DBAs" (IT pros who inadvertently wind up responsible for a SQL Server instance).  Read More...
Posted Wednesday, April 29, 2009 8:30 AM by matt_graven | 1 Comments
Filed under: ,

A Month of SQL Server Tips - Week 4

Here are the SQL Server 2008 tips we posted last week on the TechNet Magazine site, wrapping up A Month of SQL Server Tips :  Understand the 9 Numeric Data Types in SQL Server 2008 There are nine numeric data types that ship with SQL Server 2008. Read More...
Posted Monday, February 02, 2009 11:37 AM by matt_graven | 0 Comments
Filed under: ,

SQL Server: Understanding Logging and Recovery in SQL Server

Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Why is it possible for the transaction log to grow unbounded? Why does it sometimes take so long for the database to come online after a system crash? Why can't Read More...
Posted Wednesday, January 28, 2009 11:02 AM by matt_graven | 0 Comments
Filed under: ,

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 Read More...
Posted Tuesday, January 27, 2009 3:33 PM by matt_graven | 0 Comments
Filed under: ,

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 Read More...
Posted Friday, January 23, 2009 5:07 PM by matt_graven | 0 Comments
Filed under:

A Month of SQL Server Tips - Week 2

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 we posted this week. Use New Cmdlets in SQL Server PowerShell to Mange SQL Server 2008 SQL Server Read More...
Posted Friday, January 16, 2009 12:35 PM by matt_graven | 2 Comments
Filed under: ,

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 Read More...
Posted Tuesday, January 13, 2009 12:30 PM by matt_graven | 1 Comments

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 Read More...
Posted Friday, January 09, 2009 1:25 PM by matt_graven | 2 Comments
Filed under: ,

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 Read More...
Posted Wednesday, December 17, 2008 12:26 PM by matt_graven | 1 Comments

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 Read More...
Posted Tuesday, December 09, 2008 1:42 PM by matt_graven | 1 Comments

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 Read More...
Posted Thursday, November 20, 2008 7:18 AM by joshhoff | 1 Comments

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, Read More...
Posted Thursday, October 16, 2008 2:50 PM by matt_graven | 1 Comments
Filed under: ,

TechNet Magazine November 2008 Issue Is available online

The November 2008 issue of TechNet Magazine is now available online.   FEATURE ARTICLES                                                                   Read More...
Posted Thursday, October 02, 2008 8:00 AM by matt_graven | 4 Comments

October 2008 issue of TechNet Magazine available online

The October 2008 issue of TechNet Magazine is now available online. And it's all about Virtualization. FEATURE ARTICLES   An Introduction to Hyper-V in Windows Server 2008 The introduction of Hyper-V makes virtualization an even more compelling solution Read More...
Posted Tuesday, September 09, 2008 4:31 PM by matt_graven | 0 Comments

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 Read More...
Posted Thursday, July 17, 2008 2:30 PM by matt_graven | 0 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker