-
A first look at Microsoft SQL Server 2008 R2
Get details on the new features and improvements that are expected to be apart of Microsoft's upcoming SQL Server release, set to launch in early 2010.
-
Top load balancing methods for SQL Server
There are a number of way to achieve load distribution in SQL Server environments. Learn about some of the key methods, including merge replication, log shipping and SSAS server farm deployment.
-
Shrinking your transaction logs to death - Phase 2
Take a closer look at the performance implications of shrinking transaction log files in SQL Server.
-
The keys to database backup protection
There is a lot more to database backup than simply saving your info to a disk. Learn the steps that must be taken after the backup process to ensure that you and your database are 100% protected.
-
Maintaining high availability of SQL Server VMs
Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.
-
The short course on how SQL Server really works
Have you found yourself in the uncomfortable role of DBA simply because there's no one else to do the job? This series is for you. In part one, learn the basics of how data moves from disk to memor...
-
Understanding transparent data encryption (TDE)
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 imp...
-
Creating fault-tolerant SQL Server installations
Several fault-tolerance configuration options are available with SQL Server 2008, from the traditional (failover clustering) to the updated (database mirroring).
-
Working with sparse columns in SQL Server 2008
Sparse columns can provide significant storage benefits to those working with SQL Server 2008. Learn the proper way to implement sparse columns, as well as column sets and filtered indexes.
-
Determining the source of full transaction logs
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
-
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.
-
Using Microsoft Hyper-V for SQL Server consolidation
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
-
Improving SQL Server full-text search performance
What's the best full-text approach for your business? Check out these secrets to ensure high performance of SQL Server full-text search.
-
New option provides improved data control
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.
-
Managing the development lifecycle with VSDB 2008
Learn how Visual Studio Team System 2008 Database Edition can add and modify objects, generate deployment scripts and manage the development lifecycle of your SQL Server databases.
-
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?
-
Using the OPENROWSET function in SQL Server
Whether you're bulk loading data or connecting to an OLE DB data source, OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Acc...
-
Inside the new replication features for SQL Server 2008
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 ...
-
New features in SQL Server 2008 justify migration
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-br...
-
The challenges of SQL Server consolidation
Despite the benefits of SQL Server consolidation, some IT pros are reluctant to make the move. Learn which scenarios could pose a challenge to those looking to consolidate.
-
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
SQL Server meets database application security
Make sure your SQL Server is secure by studying these general guidelines for secure database applications from SQL Server expert Roman Rehak.
-
xVelocity Columnstore Indexes in SQL Server 2012
Curious about how xVelocity can help with your columnstore indexes? Check out this tip from Basit Farooq to find out.
-
Useful SQL Server 2012 features to become familiar with
SQL Server expert Basit Farooq shares his favorite SQL Server 2012 features you might not yet know. Read this tip to learn more.