Recursive Queries using Common Table Expressions (CTE) in SQL Server
Learn how to write recursive queries in SQL Server by using a Common Table Expression also know as a CTE.
Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."
- MSSQLTips Awards: Champion Award (100+ tips) - 2017 | Author of the Year Contender - 2020, 2017
Automate Restoration of Log Shipping Databases for Failover in SQL Server
When failing over to a standby server in a log shipping pair, we need to restore the latest transaction log backup to make the standby databases ready for access. This process may be cumbersome if it involves manually restoring more than five database in
Exploring Database Backup Compression in SQL Server 2008
Database backups and maintenance windows for very large database are very frustrating especially if we need to generate full database backups to initialize a database mirroring or transaction log shipping session. As we are looking through the new feature
Implementing Transparent Data Encryption in SQL Server 2008
Security is a major concern in any organization. Database backups are prone to theft and can be restored on any SQL Server instance. As we are looking through the new features in SQL Server 2008 we found a potentially interesting one called Transparent Da
Introduction to Language Integrated Query (LINQ)
Language-Integrated Query (LINQ) is a groundbreaking innovation in Visual Studio 2008 and the .NET Framework version 3.5 that bridges the gap between the world of objects and the world of data. As LINQ is part of the development enhancements in SQL Server
Evaluate and Implement Policies in Multiple SQL Server Instances
In relation to the tip on Policy-Based Management in SQL Server 2008, we would like to implement policies on multiple SQL Server 2008 and even SQL Server 2005 instances. Can you give us a detailed explanation of how we go about doing this?
Automate SQL Server Express Backups and Deletion of Older Backup Files
In this tip we look at how perform a backup of our system and user databases in SQL Server Express Edition.