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
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data SQL was designed to be a third-generation language, expressed in syntax close to real language, because it was designed to... 27 June 2017 17 min read
Other Phil Factor in Other 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
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects Technical debt is a real problem in database development, where corners have been cut in the rush to keep to... 02 June 2017 22 min read
Other Phil Factor in Other Statistics in SQL: The Kruskal–Wallis Test Before you report your conclusions about your data, have you checked whether your 'actionable' figures occurred by chance? The Kruskal-Wallis... 01 June 2017 4 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
T-SQL Programming Phil Factor in T-SQL Programming Visual Checks on How Data is Distributed in SQL Server There are many reasons for wanting to know how data is distributed. Sometimes you just want a rough idea of... 05 May 2017 12 min read
T-SQL Programming Robert Sheldon in T-SQL Programming The Basics of Good T-SQL Coding Style TSQL Code must work properly and efficiently. That's not enough though. Unless you are working alone, have perfect memory and... 05 May 2017 20 min read
Other William Brewer in Other 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
Other Phil Factor in Other Statistics in SQL: Simple Linear Regressions Although linear regressions can get complicated, most jobs involving the plotting of a trendline are easy. Simple Linear Regression is... 13 April 2017 4 min read
Other Phil Factor in Other Statistics in SQL: Kendall’s Tau Rank Correlation Statistical calculations in SQL are often perfectly easy to do. SQL was designed to be a natural fit for calculating... 10 April 2017 6 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Questions About SQL Server Collations You Were Too Shy to Ask Of course we all like our colleagues to think that we know everything there is to know about SQL Server... 06 April 2017 29 min read
Other Phil Factor in Other Statistics in SQL: Pearson’s Correlation Some people will assure you that you can't do any serious statistical calculations in SQL. In the first of a... 06 April 2017 3 min read
.NET Jon Smith in .NET Building Better Entity Framework Applications Entity Framework (EF) is Microsoft’s Object/Relational (ORM) database access library, with a new generation, EF Core, released in 2016. In... 27 March 2017 22 min read
T-SQL Programming Nat Sundar in T-SQL Programming Using the DbFit Framework for Data Warehouse Regression Testing It is ironic that the users of database application need to rely on the very technologists that created the system... 08 March 2017 15 min read
T-SQL Programming Robert Sheldon in T-SQL Programming Encrypting SQL Server: Dynamic Data Masking Dynamic Data Masking is a good way of rendering data unreadable for such purposes as user-acceptance testing, or demonstrating an... 08 March 2017 15 min read
