Blogs William Brewer in Blogs 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
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
Blogs Dennes Torres in Blogs 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
T-SQL Programming Dennes Torres in T-SQL Programming SQL Graph Objects in SQL Server 2017: Pros, Cons & Examples Evaluate SQL Server 2017 graph objects: node tables, edge tables, MATCH queries, with a relational vs graph model comparison. Covers... 05 July 2017 29 min read
Phil Factor Statistics in SQL: The Mann–Whitney U test Imagine you have some data. Maybe you’ve done a web redesign and you want to do some A/B testing to... 30 June 2017 6 min read
Blogs Dennes Torres in Blogs New T-SQL Functions in SQL Server 2017 SQL Server 2017 brings us some new T-SQL functions. They are very simple to use, and can also help us... 28 June 2017 5 min read
Blogs Phil Factor in Blogs SQL Server IsNumeric vs TRY_CAST and TRY_CONVERT: Why IsNumeric Gives Misleading Results Why IsNumeric() returns true for values that can't actually be cast to numeric types - currency symbols, commas, scientific notation,... 23 June 2017 17 min read
Database DevOps William Brewer in Database DevOps Database Code Analysis Database code analysis will reduce the number of 'code smells' that creep into your database builds. It will alert the... 20 June 2017 12 min read
BI Robert Sheldon in BI SQL Server R Services: The Basics It is possible to do a great deal with R within SQL Server, but it is best to start by... 19 June 2017 18 min read
Phil Factor SQL Server User-Defined Functions: Scalar, Inline, and Multi-Statement TVFs A complete reference to SQL Server user-defined functions - covering scalar functions, inline table-valued functions (TVFs), and multi-statement TVFs. Includes... 23 May 2017 26 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Attribute Splitting If the design of a relational database is wrong, no amount of clever DML SQL will make it work well.... 23 May 2017 11 min read
Blogs William Brewer in Blogs Generate HTML Tables & Lists from SQL Server Queries Learn how to generate HTML tables, directory lists, and hierarchical lists directly from SQL Server using FOR XML PATH. Includes... 21 April 2017 12 min read
.NET Dino Esposito in .NET Printing from ASP.NET MVC Even though we're less inclined to print web-pages nowadays, it often makes sense to save useful content from a website... 12 January 2017 12 min read
Dino Esposito Tracking Online Users with SignalR SignalR is all about pushing notifications and data between web server and browser, but you can tap into a by-product... 14 July 2015 11 min read
Robert Sheldon SQL Server Dates and Times: Ten Common Failures from DATETIME to DATEDIFF Ten common failures developers make with SQL Server date and time handling: DATETIME vs DATETIME2 precision, string-format assumptions, regional date... 28 May 2015 35 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
Learn SQL Server Jes Borland in Learn SQL Server SQL Server Indexed Views: What They Are and How to Create Them SQL Server indexed views persist query results as a physical clustered index, making complex aggregations and joins fast for repeated... 12 February 2014 24 min read
Joe Celko SQL Server SEQUENCE Basics The SEQUENCE statement introduced in SQL Server 2012 brings the ANSI SQL 2003 standard method of generating IDs. This is... 06 February 2014 13 min read
Dwain Camps Gaps and Islands in SQL Server: Fast Set-Based Solutions Compared Efficient SQL Server solutions to the gaps and islands problem - detecting unbroken sequences and the gaps between them. Covers... 25 July 2013 16 min read
