Problem solve
Get help with specific problems with your technologies, process and projects.
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