Grant Fritchey in Tools

Automated Database Provisioning for Development and Testing

If your development team needs to work on anonymised copies of the current production database, and if changes are being...

02 August 2017 10 min read

Phil Factor

Pseudonymization and the Inference Attack

It is surprising that so much can be identified by deduction from data. You may assume that you can safely...

01 August 2017 10 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

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

Blogs

Dennes Torres in Blogs

Auto Starting SQL Server Agent

I faced this problem some years ago. The company I was working for had a lot of clients with very...

17 July 2017 2 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

Saurabh Desai in BI

The Best of Both Worlds: Using Excel and Power BI Together

Excel and Power BI work well together. This allows you to use the two tools together to provide for many...

17 July 2017 12 min read

Database Administration

Laerte Junior in Database Administration

SQL Server High CPU: Investigating the Causes

Any DBA who is trying to find the cause of an intermittent problem such as SQL Server high CPU dreams...

17 July 2017 9 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

SQL Server 2017: New ‘Queries with high variation’ Graph

A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At...

30 June 2017 3 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

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

Database Administration

Laerte Junior in Database Administration

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is...

27 June 2017 8 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

Register for Simple Talk

Databases

Automated Database Provisioning for Development and Testing

Pseudonymization and the Inference Attack

SQL Server Query Hints in Entity Framework: DbCommandInterceptor Guide

The Basics of Good T-SQL Coding Style – Part 4: Performance

Data in Motion and Data at Rest

Representing a simple hierarchical list in SQL Server with JSON, YAML, XML and HTML

Auto Starting SQL Server Agent

SQLCLR Email in SQL Server: Build a Custom sp_send_dbmail Alternative

The Best of Both Worlds: Using Excel and Power BI Together

SQL Server High CPU: Investigating the Causes

SQL Server R Services: Digging into the R Language

SQL Data Aggregation Aggravation

Using R to illustrate relationships from graph objects

SQL Graph Objects in SQL Server 2017: Pros, Cons & Examples

Statistics in SQL: The Mann–Whitney U test

SQL Server 2017: New ‘Queries with high variation’ Graph

New T-SQL Functions in SQL Server 2017

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

SQL Server IsNumeric vs TRY_CAST and TRY_CONVERT: Why IsNumeric Gives Misleading Results