Blogs Phil Factor in Blogs 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
Tools 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 Using SQL Server Query Hints with Entity Framework Entity Framework (EF) is designed to work with a variety of data sources. Although this presents many advantages, there is... 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 in Practice: Creating a Better Way of Sending Email from SQL Server SQLCLR is now considered a robust solution to the few niche requirements that can't be met by the built-in features... 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: the Good and the Bad Graph databases are useful for certain types of database tasks that involve representing and traversing complex relationships between entities. These... 05 July 2017 28 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
