SearchSQLServer: Expert advice on database development

New SQL Server 2008 R2 CTP set for November

Brendan Cournoyer — Tue, 03 Nov 2009 15:04:00 EST

Microsoft's next-generation DBMS will be released to manufacturing in early 2010, along with two new editions for the enterprise.

DBA career paths could lead to business intelligence

Brendan Cournoyer — Mon, 02 Nov 2009 16:00:36 EST

Business intelligence could prove to be an ideal specialty for SQL Server DBAs who feel like they've hit a wall with their current jobs.

Are data warehouses made for the cloud?

Brendan Cournoyer, Site Editor — Fri, 23 Oct 2009 12:06:30 EDT

Cost and scalability benefits might make data warehousing seem like a perfect fit for cloud computing, but storage limitations with Azure could slow deployments.

Q&A: Business intelligence gets a facelift in SQL Server 2008 R2

SearchSQLServer.com Staff — Wed, 21 Oct 2009 13:54:24 EDT

From grab-and-go reporting to Master Data Services, SQL Server 2008 R2 will include several changes to Microsoft business intelligence.

Project Gemini gets a new name, Madison earns buzz

Brendan Cournoyer, Site Editor — Tue, 20 Oct 2009 16:39:26 EDT

PowerPivot for Excel and SharePoint (formerly codenamed 'Gemini') along with Project Madison will be of keen interest to those looking ahead to SQL Server 2008 R2.

Q&A: Moving forward with SQL Server in the cloud

SearchSQLServer.com Staff — Mon, 19 Oct 2009 11:36:34 EDT

DBAs and developers have concerns about cloud computing , but enhancements to Microsoft's SQL Azure Database could ease those worries.

End of life comes for SQL Server 2005 SP2, 2008

SearchSQLServer.com Staff — Thu, 08 Oct 2009 13:47:23 EDT

Mainstream support for at least two versions of Microsoft SQL Server is set to expire next year.

Data Transformation Services vs. SSIS: The key differences

Denny Cherry, Contributor — Tue, 06 Oct 2009 16:11:14 EDT

While SQL Server Integration Services 2008 is a major step up from the days of DTS, there are still some gotchas for developers to be aware of.

Using package configurations in SQL Server Integration Services (SSIS)

Eric Johnson — Thu, 01 Oct 2009 13:10:58 EDT

Microsoft MVP Eric Johnson demonstrates how to use the Package Configurations option in SQL Server Integration Services and explains the value it brings to database developers.

Microsoft SQL Server Tools Guide

SearchSQLServer.com Staff — Tue, 29 Sep 2009 11:41:10 EDT

Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find the tool or utility you need in this guide. Check out some of the best native and third-party tools for Microsoft's database management systems.