T-SQL Programming Joe Celko in T-SQL Programming Missing Data In the real world of business or scientific reporting and analysis, data can prove to be awkward. It can be... 08 September 2017 11 min read
Database Administration Brent Ozar in Database Administration Six Scary SQL Surprises The working life of the DBA can be punctuated by surprises, but they aren't generally nice surprises. This is especially... 06 September 2017 24 min read
BI Robert Sheldon in BI SQL Server R Services: Working with Data Frames Although you can get started with R in SQL Server without understanding data frames, they are a key structure of... 06 September 2017 29 min read
Dennes Torres Thoughts about submitting a new Power BI Quick Measure ‘Quick Measures’ is a feature included in Power BI Desktop April update. It’s still in preview, so you need to... 25 August 2017 5 min read
.NET Dan Turner in .NET Why is My Database Application so Slow? When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that... 24 August 2017 14 min read
Jackie Barre Mixing MongoDB and Relational Databases in the Enterprise Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and... 24 August 2017 9 min read
Opinion Pieces Robert Sheldon in Opinion Pieces The SQL Server Features that Time Forgot Every new release of SQL Server comes with new features that cause a ripple of excitement within the industry: well,... 23 August 2017 12 min read
T-SQL Programming Joe Celko in T-SQL Programming Simple SQL: Random Thoughts How does one get a truly random sample of data of a certain size from a SQL Server database table.... 11 August 2017 9 min read
BI Robert Sheldon in BI SQL Server R Services: Working with ggplot2 Statistical Graphics It is when you use R in SQL Server with one of the huge range of packages that comes with... 11 August 2017 21 min read
Blogs Dennes Torres in Blogs Monitoring UnmatchedIndexes Warning If you are using filtered indexes in SQL Server, it worthwhile monitoring the UnmatchedIndexes warning, it can give us very... 07 August 2017 4 min read
T-SQL Programming Hitendra Patel in T-SQL Programming The Power of Python and SQL Server 2017 Python is new to SQL Server 2017. It is intended primarily to allow the use of Python-based machine-learning within SQL... 04 August 2017 14 min read
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
