Opinion Pieces Joe Celko in Opinion Pieces Degree of Duplication Technology is constantly moving forward, but it is also helpful to understand how we arrived where we are today. Joe... 25 January 2018 13 min read
T-SQL Programming Phil Factor in T-SQL Programming Pivoting Data in SQL Server with JSON: A Generic Dynamic Matrix Approach A JSON-based approach to pivoting and transposing data in SQL Server that works without knowing column names in advance. Covers... 16 January 2018 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Validation, Verification, and Modification A proper database design is very important, and changes to fix problems after the fact are expensive. In this article,... 26 December 2017 20 min read
T-SQL Programming Alfonso Hernandez in T-SQL Programming Summarizing Data Using the GROUPING SETS Operator Writing aggregate queries is one of the most important tasks for anyone working with T-SQL. Determining the expressions required in... 14 November 2017 9 min read
T-SQL Programming Phil Factor in T-SQL Programming Import and Validate JSON from Web Services into SQL Server: T-SQL Techniques Import and validate JSON from web services into SQL Server using T-SQL. Covers path expression parsing, metadata comparison, data type... 27 October 2017 35 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Handling Location Datatypes How do you record locations in SQL? Most relational database systems support spatial and geographical data, generally using the round-earth... 19 October 2017 14 min read
Other Phil Factor in Other SQL Server OPENJSON: Parse Hierarchical JSON into Relational Tables Use SQL Server OPENJSON to parse hierarchical JSON documents into relational table structures. Covers recursive and iterative approaches, EAV patterns,... 12 September 2017 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Missing Data In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be... 08 September 2017 11 min read
.NET Dan Turner in .NET Why is My Database Application so Slow? When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that... 24 August 2017 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Random Thoughts How does one get a truly random sample of data of a certain size from a SQL Server database table.... 11 August 2017 9 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
Other Phil Factor in Other Statistics in SQL: Student’s t-test Many undergraduates have misunderstood the name 'Students' in the t-test to imply that it was designed as a simple test... 03 August 2017 5 min read
.NET Dennes Torres in .NET SQL Server Query Hints in Entity Framework: DbCommandInterceptor Guide Add SQL Server query hints to Entity Framework using a DbCommandInterceptor. Covers OPTION RECOMPILE, table hints (UPDLOCK, HOLDLOCK), and why... 01 August 2017 29 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 4: Performance There are several obvious problems with poor SQL Coding habits. It can make code difficult to maintain, or can confuse... 31 July 2017 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Data in Motion and Data at Rest Microsoft (StreamInsight), and Azure Stream Analytics represent a very different model for processing data. They are concerned with processing complex... 28 July 2017 11 min read
Other William Brewer in Other Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML How difficult can it be to produce a simple hierarchical list in JSON, YAML, XML and HTML from a SQL... 18 July 2017 7 min read
T-SQL Programming Darko Martinović in T-SQL Programming SQLCLR Email in SQL Server: Build a Custom sp_send_dbmail Alternative Build a SQLCLR stored procedure for sending email from SQL Server without sp_send_dbmail. Covers .NET SMTP integration, custom email profiles,... 17 July 2017 36 min read
BI Robert Sheldon in BI SQL Server R Services: Digging into the R Language It is not just the analytic power of R that you get from using SQL Server R Services, but also... 17 July 2017 16 min read
T-SQL Programming Joe Celko in T-SQL Programming SQL Data Aggregation Aggravation When we have to deal with and store a lot of data, it makes sense to aggregate it so that... 17 July 2017 10 min read
Other Dennes Torres in Other Using R to illustrate relationships from graph objects My new article about Graph Database Objects was just published, it’s really a very good new feature. Another new feature... 06 July 2017 3 min read
