SQL Server and Hyper-threading

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...

Implementing Fuzzy Sets in SQL Server, Part 6: Fuzzy Numbers and Linguistic Modifiers

By Steve Bolton
…………I’ve written several amateur tutorial series on this blog in order to more quickly absorb difficult data mining,...

Database Configuration

It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...

The New PASS Logo and More

Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...

SQL Server 2016 has reduced the NoSQL JSON “advantage” over SQL Server

 Microsoft has finally implement support for JSON data in SQL Server 2016 and in Azure SQL Database. In a previous...

Database Backup History – Back to Basics

In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.
Related Posts:

The Mystery of Missing...

Database Backup History – Back to Basics

Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...

Report Portal in SSRS 2016

SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction...

SQL Server and Hyper-threading

This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...

Last Restore of a Database – Back to Basics

In this article I explore the basics around how to determine when a database was last restored.
Related Posts:

Changing Default Logs Directory - Back to Basics January 4, 2018

SQL...