Some Sql Server properties to configure on a new instance
After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the...
2016-02-26
567 reads
Fix a Network Binding Order Warning
Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in...
2016-03-03 (first published: 2016-02-26)
1,724 reads
The Jarvis–Standing Desk Update
I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of...
2016-02-26
1,974 reads
Announcing Workshops – Columnstore Deep Dive (in German)
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days...
2016-02-26
886 reads
SQL 2012 Identity Columns Feature
Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this...
2016-02-25
1,446 reads
DBCC Just Runs Faster, Unless You’re Cheap
The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales...
2016-02-25
610 reads
Well that’s just neat: Row Level Security, new in SQL Server 2016
SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...
2016-02-25
1,120 reads
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...
2016-02-24
15 reads
SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog]
I had a question at work recently where there was some confusion around how SQL...
2016-03-02 (first published: 2016-02-24)
2,693 reads
Grabbing Fitbit Data
Recently the T-SQL Tuesday topic was Power BI. A cool topic, and an interesting application.
I saw Rob Farley build a...
2016-02-24
1,326 reads
Blogs
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...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
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...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
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