May 2008
Business Intelligence (BI) enhancements to SQL Server 2008 Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) improve performance and make reporting easier.
March 28, 2008
Take a tour of the new features and functionality in Visual Studio 2008.
March 2008
New data types in SQL Server 2008 offer more precise date/time storage and solve such problems as unstructured LOB storage—DBAs will like the addition of spatial data types, new date data types, and the FILESTREAM data type.
March 2008
In this exclusive interview with Ted Kummert, Microsoft corporate vice president of the Data and Storage Platform Division, Karen Forster finds out about some of SQL Server 2008’s key features and what they might mean for you.
March 2008
The new Extensible Key Management feature makes SQL Server’s built-in database encryption more secure by supporting third-party encryption providers, so that you can store keys outside of the database.
March 2008
Get the facts about the new data compression feature in SQL Server 2008 and the stored procedure that can help you estimate how much space you might save by compressing your data.
February 2008
This update to the original DBA Repository solution adds support for SQL Server 2005, support for SQL Server authenticated domains, support for server location, information for reports and ad-hoc queries, and an enhanced SQL Server Agent job schedule.
August 2007
The sixth annual Best of TechEd Awards took place in June and highlighted outstanding products from Microsoft partners. Here are the top SQL Server-related product winners.
August 2007
SQL Server Magazine gives you information about database-related hardware, software, and services in every issue. In our second annual Editors' Choice Awards, we honor the best of the best from all the products we've covered in the past year.
July 2007
Microsoft System Center 2007 products offer many new SQL Server management features, such as more detailed alerting, configuration management, and SQL Server–specific data protection.
July 2007
Learn about the updated products that comprise the latest version of Microsoft System Center.
May 2007
Data Mining Add-ins for Office 2007 help you develop business intelligence by using the power of SQL Server 2005 and Microsoft Office Excel 2007 to analyze your organization's data.
March 2007
For the many shops still using SQL Server 2000, this extensible, data-driven utility can cure a wealth of date-formatting headaches.
February 2007
What's important to consider in designing a database? For optimal performance, you need to be mindful about three interrelated factors: indexing, maintenance, and statistics. Here's some advice to get you started in the planning process.
December 2006
Our annual salary survey respondents tell us how they acquire the knowledge that sets them apart from the average DBA. We also highlight how your salary stacks up with your peers for this year.
December 2006
Find out how your salary compares with those of other SQL Server professionals and which factors have the most influence on compensation.
November 2006
In a database performance-engineering process, applying the right design techniques will ensure smooth-running operations. Here’s a laundry list of essential technical items you need to include in your process.
December 2006
Here's how we carried out the SQL Server Magazine Salary Survey.
October
Regardless of the size and speed of your database, if you can’t trust your data, it’s useless. Learn how you can use some basic database best practices to set up your database and processing environment to enforce validation automatically.
September 2006
Reporting Services gives you an inexpensive way to deliver Analysis Services data to business users. Here’s how you can provide greater flexibility in your reports so users can easily change the ways they view BI data.
Add these Headlines to your Website
