Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

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: ,

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 Read More...
Posted Monday, July 14, 2008 7:09 PM by matt_graven | 0 Comments

SQL Server 2008: Data Warehouse Query Performance

SQL Server 2008 offers more powerful relational data warehousing capabilities. Take a close look at key performance-related data warehousing features and find out how you can use all this new technology to optimize query performance. The article explores Read More...
Posted Friday, April 18, 2008 8:30 AM by matt_graven | 0 Comments

Minimize Blocking in SQL Server

While locking is esse ntial to support concurrent read and write activities on a database, blocking can adversely affect system performance. Learn how to optimize your SQL Server database to minimize blocking, and see how you can monitor the system to Read More...
Posted Thursday, April 17, 2008 7:00 AM by sharont | 0 Comments
Filed under: ,

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 Read More...
Posted Wednesday, April 16, 2008 4:50 PM by matt_graven | 0 Comments

What's New in SQL Server 2008

Policy management, query seeks against partitions, Extensible Key Management --the list goes on.  SQL Server 2008 offers a lot of new features and enhancements that will make life easier for database administrators.  In the April issue of TechNet Read More...
Posted Wednesday, April 09, 2008 2:00 PM by matt_graven | 0 Comments

SQL Server 2008: New Data Types

The more complex the econ omy grows and the more global its reach, the more complex the data we have to deal with. The seven new data types built into SQL Server 2008 provide the means for working with more complicated data, simplifying the management Read More...
Posted Tuesday, April 08, 2008 9:57 AM by sharont | 0 Comments
Filed under: ,

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 Read More...
Posted Monday, April 07, 2008 9:00 AM by matt_graven | 1 Comments

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 Read More...
Posted Friday, February 29, 2008 8:15 AM by matt_graven | 0 Comments

Better Backups with Data Protection Manager 2007

Microsoft Exchange support was the number-one feature request of users of DPM 2006—and Microsoft listened. As Calvin Keaton describes in our January issue, the new version of Data Protection Manager introduces support for both Exchange Server 2003 Read More...
Posted Tuesday, January 22, 2008 7:00 AM by sharont | 0 Comments

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 Read More...
Posted Thursday, December 13, 2007 7:00 AM by sharont | 0 Comments
Filed under:

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 Read More...
Posted Monday, November 19, 2007 7:00 AM by tdorsey | 0 Comments
Filed under:
More Posts Next page »
 
Page view tracker