Tips

Tips

• The keys to database backup protection for SQL Server

  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.  Continue Reading

• Maintaining high availability of SQL Server virtual machines

  Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.  Continue Reading

• 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 memory in Microsoft SQL Server.  Continue Reading

• 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.  Continue Reading

• 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).  Continue Reading

• 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.  Continue Reading

• Determining the source of full transaction logs in SQL Server

  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.  Continue Reading

• 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

• 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.  Continue Reading

• 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.  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

• Managing the development lifecycle with Visual Studio Team System 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.  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

• 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 Access.  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