Blogs Dennes Torres in Blogs What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well... 04 July 2022 8 min read
Dennes Torres in Blogs Count Distinct and Window Functions Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t... 15 March 2021 7 min read
Robert Sheldon Questions About Using TSQL to Import Excel Data You Were Too Shy to Ask It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or... 05 November 2014 31 min read
Robert Sheldon TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get... 19 May 2014 31 min read
T-SQL Programming Phil Factor in T-SQL Programming SQL Server FOR JSON: Produce JSON from T-SQL Queries (Flat and Nested) Learn how to produce JSON from SQL Server queries using FOR JSON PATH, FOR JSON AUTO, and custom T-SQL techniques... 06 May 2014 33 min read
Joe Celko On Handling Dates in SQL The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical... 06 March 2014 16 min read
Hugo Kornelis Generating Test Data in TSQL To test SQL, you need test data. There are usually many reasons why you can't use production data. Although it... 14 January 2014 30 min read
Jonathan Allen Preparing to Upgrade SQL Server: Finding Deprecated Features with DMVs and Extended Events Preparing for a SQL Server upgrade by identifying deprecated features still in use - querying sys.dm_os_performance_counters for deprecation counters and... 12 June 2013 17 min read
Robert Sheldon tSQLt Tutorial: Unit Testing SQL Server Databases with Test Cases and Fakes A complete tSQLt tutorial for SQL Server unit testing: setting up the tSQLt framework, creating test classes and test cases,... 08 April 2013 22 min read
Hugh Bin-Haad TSQL Pivot Rotations using only REPLACE Pivoting SQL Server tables is always awkward, even with the PIVOT and UNPIVOT operators. If you want to get the... 01 April 2013 8 min read
Robert Sheldon Some Books on Programming SQL Server 2012 It is a measure of the range of facilities that are available to the database developer nowadays that three different... 21 February 2013 12 min read
Tools Phil Factor in Tools SQL Server Registered Servers and Central Management Server: SSMS Setup Guide Manage multiple SQL Server instances with Registered Servers and Central Management Server (CMS) in SSMS. Covers setup, permissions, querying the... 28 August 2012 15 min read
Grant Fritchey Seven T-SQL Performance Anti-Patterns: Wrong Data Types, Non-Sargable WHERE, Multi-Statement UDFs, NOLOCK, Query Hints, RBAR, Nested Views Seven classic T-SQL performance anti-patterns that cause slow queries: wrong data types forcing implicit conversions, functions in ON/WHERE clauses blocking... 31 July 2012 15 min read
Timothy Wiseman SQL Scripts Manager and IronPython As well as running TSQL and PowerShell, the free SQL Scripts Manager tool can also run Python scripts. This allows... 04 May 2012 10 min read
Phil Factor Working with CSV Files in SQL Server: ODBC, Linked Server, and T-SQL Parsing Read and write CSV files from SQL Server using three approaches: the ODBC Text Driver, a linked server, and a... 13 April 2012 20 min read
Feodor Georgiev Exploring SSIS Architecture and Execution History Through Scripting When you are using SSIS, there soon comes a time when you are confronted with having to do a tricky... 16 February 2012 12 min read
Phil Factor PowerShell SMO: Automate SQL Server Script Generation Automate SQL Server database scripting with PowerShell and SMO. Covers Transfer objects, scripting options, and generating build scripts for tables,... 03 February 2012 24 min read
Feodor Georgiev Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting DBAs are usually charged with the administration of Reporting Services, but are often short on guidance on how to go... 22 November 2011 17 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
T-SQL Programming Solomon Rutzky in T-SQL Programming CLR Performance Testing Are Common Language Runtime routines in SQL Server faster or slower than the equivalent TSQL code? How would you go... 21 July 2011 19 min read
