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 for them. Licensing is given at the end of...
2016-12-20
20 reads
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...
2016-12-20
280 reads
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,...
2016-12-30 (first published: 2016-12-20)
2,232 reads
Database Configuration
It’s amazing just how much the landscape changed with the release of SQL Server 2016 SP1. For example, I just...
2016-12-20
466 reads
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...
2016-12-20
342 reads
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...
2016-12-20
3,641 reads
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...
2016-12-20
32 reads
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...
2016-12-20
561 reads
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...
2016-12-20
574 reads
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...
2016-12-20
6,031 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers