-
Log shipping: Four tips to maintain RTO and RPO with SQL Server
It's not uncommon for DBAs to be lulled into a false sense of security by log shipping, without realizing the negative effects it could have on disaster recovery.25 Feb 2010
-
Finalizing maps with Report Builder 3.0
Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.23 Feb 2010
-
Geospatial mapping made simple with Microsoft SQL Server
The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.23 Feb 2010
-
Adding a polygon layer to a map in Report Builder 3.0
The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.23 Feb 2010
-
Ten key changes with SQL Server 2008 R2
A lot's different in Microsoft's upcoming SQL Server release. Check out our list of the 10 most significant changes.18 Feb 2010
-
SQL Server 2008 R2 key changes: Enhanced scale-up capabilities
SQL Server 2008 R2 gives you more room to grow than previous versions -- a whole lot more. See where scalability improvements land on our list of key changes.18 Feb 2010
-
SQL Server 2008 R2 key changes: Data-tier applications (DAC)
See why data-tier applications, a facet of Microsoft's new multi-server management features, made our list of the top changes for SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: StreamInsight
Learn why the new StreamInsight component is on our list of top 10 changes in SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: Parallel Data Warehouse
Parallel Data Warehouse is one of two new editions of SQL Server. See why PDW made our list of the top changes in SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: Reporting Services improvements
There's a ton of new BI features for SQL Server 2008 R2 -- but existing tools also deserve attention. Improvements to SSRS earn it a spot on our list of top R2 changes.18 Feb 2010
-
SQL Server 2008 R2 key changes: Report Builder 3.0
The latest edition of Microsoft's Report Builder tool has several cool new data visualization capabilities, making it one of our picks for the top changes in SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: PowerPivot for Excel and SharePoint
PowerPivot integrates with Excel and SharePoint to create a self-service BI. But that's not all. See why else this tool made our list of the top changes for SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: SSMS enhancements for SQL Azure
Microsoft made some nifty improvements to SQL Server Management Studio for SQL Azure. See where these enhancements fall on our list of the top changes for SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: Multi-server management
See the new capabilities in SSMS that earned multi-server management a spot on our list of the top changes for SQL Server 2008 R2.18 Feb 2010
-
SQL Server 2008 R2 key changes: Master Data Services
A big step forward for Microsoft's collective BI platform, Master Data Services is on our list of top changes for SQL Server 2008 R2.18 Feb 2010
-
The ultimate SQL Server security faux pas: Overlooked systems
Maintaining a secure environment means not only shoring up your highly visible systems, but also staying on top of the smaller installations that tend to slip through the cracks.10 Feb 2010
-
SQL Profiler: A network trace for SQL Server
SQL Server newbies should be sure to take advantage of Microsoft's SQL Profiler tool, which can be used as sort of a network monitor for the database.08 Feb 2010
-
Tweet-SQL: Interacting with Twitter through SQL Server
Twitter has gotten so popular, even SQL Server is getting in on the act. Confused? Don't be. Check out this new tool for leveraging Twitter in the database.03 Feb 2010
-
An introduction to XML shredding for SQL Server
It's critical to understand the effects XML shredding can have on your database environment before selecting a particular shredding approach.01 Feb 2010