.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
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
