Problem solve

Microsoft SQL Server 2008

• Implementing SQL Server 2008 FILESTREAM functionality

  The FILESTREAM feature in SQL Server 2008 enables SQL Server-based apps to store unstructured data. Learn to enable FILESTREAM in SQL Server 2008. Continue Reading

• New GROUP BY option provides better data control in SQL Server 2008

  GROUPING SETS in the GROUP BY clause trumps the ROLLUP and CUBE options by providing a more efficient and specific data aggregator in SQL Server 2008 – and greater data control. Continue Reading

• Scaling up vs. scaling out with SQL Server 2008

  To scale your SQL Server properly means to make it bigger and better. But what is the best method for 2008? Continue Reading

• New replication features in SQL Server 2008 and what they mean to you

  SQL Server 2008 features several replication improvements, and some are more compelling than others. Here you'll learn what's new with snapshot delivery, peer-to-peer topologies, merge replication and more. Continue Reading

• Migrating to SQL Server 2008 and leveraging new features

  New features in SQL Server 2008, including the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL Server 2008 a no-brainer. Continue Reading

• SQL Server consolidation strategies and best practices

  Several consolidation options are available for managers and DBAs who are looking to cut costs. Learn about some of these strategies and when to use them along with details on the benefits of SQL Server consolidation with Windows 2008.Continue Reading

• Does upgrading to SQL Server 2008 fit your business?

  While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.Continue Reading

• New data profiling tools in SQL Server 2008

  New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy up front.Continue Reading

• Creating Windows PowerShell scripts to manage SQL Server 2008 instances

  Creating Windows PowerShell scripts helps manage SQL Server 2008 objects, databases and other instances. This tip covers two PowerShell snap-ins that aid the navigation of the SQL Server component hierarchy.Continue Reading

• A guide to advanced new features in SQL Server Management Studio 2008, part 2

  SQL Server Management Studio 2008 has several new features, including the T-SQL Debugger for easier debugging and a new Object Explorer Details window that's easier to use.Continue Reading

• A guide to basic new features in SQL Server Management Studio 2008, part 1

  SQL Server Management Studio 2008 comes packed with the new features that have been on your wish list, including syntax help, word completion and a list of stored procedure parameters.Continue Reading

• Implementing security audit in SQL Server 2008

  If you're a DBA tasked with producing detailed audits tracking database use, take a look at these capabilities in SQL Server 2008 where the process is much easier than in earlier versions.Continue Reading

• What's new in SQL Server 2008 Reporting Services?

  As expected, SQL Server 2008 Reporting Services has new features, but the improvements to existing reporting features are what will have you considering an upgrade. For example, Microsoft has re-architected SSRS so it's no longer dependent on IIS, ...Continue Reading

• New security features in SQL Server 2008 leave some work for you

  Microsoft has certainly taken security in SQL Server 2008 to a higher level. But as IT security expert Kevin Beaver points out, just because SQL Server 2008 is secure to begin with, that doesn't mean it'll be secure in your environment. Add people ...Continue Reading

• New datetime data types in SQL Server 2008 offer flexibility

  The fifth and final tip in this series on SQL Server datetime values outlines four new data types supported by T-SQL in SQL Server 2008. SQL Server expert Robert Sheldon walks you through how to use DATETIME2, DATETIMEOFFSET and DATE and TIME data ...Continue Reading