Andy Brown Moving Data From Excel to SQL Server – 10 Steps to Follow SQL Server Integration Services provide a versatile way of reading Excel files into SQL Server. A task like this illustrates... 21 May 2013 15 min read
Phil Factor SQL Server JSON to Table and Table to JSON One of the surprises that I got from writing for Simple-Talk was the popularity of my article Consuming JSON Strings... 26 March 2013 7 min read
Database Administration Seth Delconte in Database Administration SQL Server XML: Creating, Shredding, and Combining XML Data with T-SQL Manipulate XML data in SQL Server using T-SQL: create XML from tables with FOR XML, shred XML to rows with... 23 October 2012 14 min read
Joe Celko SQL VIEW Basics SQL Views are essential for the database developer. However, it is common to see them misused, or neglected. Joe Celko... 10 May 2012 19 min read
Andy Brown 10 Reasons Why Visual Basic is Better Than C# After having converted a whole lot of training materials based on VB.NET into C#, Andy 'Wise Owl' Brown decided to... 14 February 2012 8 min read
Robert Sheldon Converting String Data to XML and XML to String Data We all appreciate that, in general, XML documents or fragments are held in strings as text markup. In SQL Server,... 01 February 2012 18 min read
Robert Sheldon SQL Server XML Methods: query(), value(), exist(), nodes(), modify() The five SQL Server XML methods - query(), value(), exist(), nodes(), and modify() - explained with working AdventureWorks examples. Covers... 08 December 2011 23 min read
Jeremiah Peschka SQL Server Functions: The Basics SQL Server's functions are a valuable addition to TSQL when used wisely. Jeremiah provides a complete and comprehensive guide to... 10 November 2011 41 min read
Robert Sheldon Working with the XML Data Type in SQL Server The XML data type, introduced in SQL Server 2005, is a powerful construct. When used wisely, it can provide useful... 07 November 2011 16 min read
Phil Factor Import HTML Data into SQL Server with PowerShell: HTML Agility Pack and DataTable Approach Scrape HTML tables, lists, and unstructured content into SQL Server using PowerShell and the HTML Agility Pack (HAP). Covers reading... 30 March 2011 22 min read
Robert Sheldon The EXCEPT and INTERSECT Operators in SQL Server The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a... 28 February 2011 14 min read
Joe Celko Look-up Tables in SQL Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a... 01 February 2011 18 min read
Robert Sheldon SQL Server BULK INSERT and OPENROWSET BULK: Performance Tuning Bulk Loads Load large datasets into SQL Server using BULK INSERT and INSERT...SELECT with OPENROWSET(BULK). Covers the core syntax, performance tuning through... 31 January 2011 21 min read
Robert Sheldon Data Conversion in SQL Server Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a... 06 January 2011 17 min read
Robert Sheldon The DELETE statement in SQL Server Of the big four DML statements in SQL Server, the DELETE is the one least written about. This is odd... 25 November 2010 11 min read
T-SQL Programming Phil Factor in T-SQL Programming Consume & Query JSON in SQL Server with T-SQL Parse and consume JSON strings in SQL Server using T-SQL. Includes a custom JSON parser function, adjacency list techniques, and... 15 November 2010 26 min read
Robert Sheldon Working with Window Functions in SQL Server With SQL Server 2005, SQL Server introduced some of SQL's window functions, that apply, not to the full set, but... 28 October 2010 12 min read
Robert Sheldon Working with the INSERT statement in SQL Server The INSERT statement in SQL Server is versatile. It now allows the insertion of multiple rows of literal values. It... 27 September 2010 12 min read
Robert Sheldon The MERGE Statement in SQL Server 2008 When the SQL MERGE statement was introduced in SQL Server 2008, it allowed database programmers to replace reams of messy... 27 August 2010 14 min read
Robert Sheldon Implementing the OUTPUT Clause in SQL Server 2008 In retrospect, it was probably the inclusion of the OUTPUT clause in the MERGE statement that gave SQL Server 2008... 22 July 2010 17 min read
