Email Alerts
-
Understanding transparent data encryption in SQL Server 2008
Transparent data encryption can go a long way toward meeting compliance and security standards. Learn what TDE can do for you, with details on the considerations that should be made before it's implemented. Tip
-
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. Tip
-
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. Tip
-
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? Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip