Notes From the February 2016 OPASS Meeting
I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...
2016-03-09
640 reads
SSC Editorial: Lessons From Little Green Army Men
This one is about spending time with my daughter – she bought some army men as a toy after a visit...
2016-03-09
527 reads
SSC Editorial: Spousal Surcharges
I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...
2016-03-09
482 reads
SQL server on Linux
Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...
2016-03-09
2,262 reads
Consider removing the NON EMPTY key word from the COLUMNS axis
You might have seen error message like this from a SQL job that pulls data from an OLAP cube using...
2016-03-14 (first published: 2016-03-08)
2,243 reads
SQL Server on Linux!
Looks outside: pigs are flying!
In an announcement yesterday, SQL Server will be made available on Linux. The private preview of...
2016-03-08
913 reads
Converting SQL Backup Files to MTF
I got a copy of some backup files recently and needed to restore them. However, I don’t have SQL Backup...
2016-03-08
1,359 reads
My thoughts on SQL Server on Linux
Well yesterday was a big day in the SQL Community, Microsoft announced that they will be developing a version of SQL Server for Linux. Check out the announcement here.
Image...
2016-03-08
5 reads
My thoughts on SQL Server on Linux
Well yesterday was a big day in the SQL Community, Microsoft announced that they will be developing a version of...
2016-03-08
1,765 reads
Announcing SQL Server on Linux
Yes, you read that right. SQL Server will be ported to Linux. Here’s the Blog post from Scott Guthrie.
http://blogs.microsoft.com/blog/2016/03/07/announcing-sql-server-on-linux/
Today I’m...
2016-03-08
491 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
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