What is Application and Multi-server Management in SQL Server 2008 R2?
What is Application and Multi-server Management?Microsoft’s investments in Application and Multi-server Management will help organizations manage database environments..
What is StreamInsight?
What does StreamInsight mean for customers?While OLTP databases have matured and are capable of processing thousands of transactions..
Create Tables in SQL Server 2008 - Part 1 of 2
SQL Server databases store all of your data in tables. Each table models something in the real world..
How to Design and Build SQL Server Tables - Part 2 of 2
SQL Server databases store all of your data in tables. Each table models something in the real world..
SQL Server Recovery Models
In our previous article we discussed how to design a backup strategy. This time we’re going to talk..
Top 4 Reasons to Move to Microsoft SQL Server 2008 R2
Microsoft® SQL Server 2008 R2 expands on the value delivered in SQL Server 2008 with new technologies and..
Troubleshoot a Slow Database in SQL Server 2008
Troubleshooting database slowness can be both fairly straightforward and tricky at the same time. Most of the time..
How to Design a Backup Strategy in SQL Server
Designing a backup strategy is fairly straightforward, but it can get complicated when you’ve got a lot of..
How to Choose a SQL Server Authentication Mode
Probably one of the most important decisions you’ll make during your install of SQL Server 2008 is which..
How to Manage SQL Server Database Files
Managing database files in SQL Server 2008 is fairly easy and most of it can be done in..
How to Create a Simple Backup Job in SQL Server
There are several ways to create a backup job in SQL Server 2008 and I’m going to show..
