Database Administration Seth Delconte in Database Administration Recover Data in SQL Server AWS RDS with the Help of BACPAC With Amazon RDS, it’s easy to have a SQL Server running in minutes. There are some limitations, though. Seth Delconte... 22 March 2018 15 min read
Seth Delconte Introduction to SQL Server Filtered Indexes SQL Server filtered indexes can save space and improve performance if they are used properly. Under what circumstances can they... 19 April 2013 13 min read
Seth Delconte Ad-Hoc XML File Querying When you need to shred just part of the data within a large XML file into a SQL Server table,... 05 March 2013 15 min read
Seth Delconte Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012 Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1... 25 January 2013 14 min read
Seth Delconte Manipulating XML Data in SQL Server When the average database developer is obliged to manipulate XML, either shredding it into relational format, or creating it from... 23 October 2012 14 min read
Seth Delconte Getting Started With XML Indexes XML Indexes make a huge difference to the speed of XML queries, as Seth Delconte explains; and demonstrates by running... 25 September 2012 17 min read
Seth Delconte NULL-Friendly: Using Sparse Columns and Column Sets in SQL Server Sparse columns and column sets in SQL Server 2012 provide a way of accomodating the less-structured data that has always... 10 July 2012 14 min read