Mr Fox SQL

Interests: Databases, DW, BI, AI, ML, SQL, Visualisation, Streaming, Architecture, Security, Automation
Skills: Anything Data, AI, ML or Analytics in the Cloud (Azure or AWS)

LinkedIn: https://www.linkedin.com/in/rolftesmer/

Compression Performance with Low Key Selectivity

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...

2016-03-15

11 reads

SQL Filegroup/File Proportional Fill Algorithm

by Mr Fox SQL

Mr. Fox SQL

[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,679 reads

SQL Filegroup/File Proportional Fill Algorithm

by Mr Fox SQL

Mr. Fox SQL

[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

12 reads

A “Business Intelligence” (BI) Definition

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog]
Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions...

2016-01-19 (first published: 2016-01-11)

2,778 reads

SQL Saturday Melbourne (#464) – 20 Feb 2016

by Mr Fox SQL

Mr. Fox SQL

For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016.
SQL Saturday is an excellent free learning...

2016-01-18

692 reads

SQL Saturday Melbourne (#464) – 20 Feb 2016

by Mr Fox SQL

Mr. Fox SQL

For those not aware SQL Saturday is coming to Melbourne on Sat 20 Feb 2016. SQL Saturday is an excellent free learning resource for all things SQL Server – all costs are...

2016-01-18

8 reads

A “Business Intelligence” (BI) Definition

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog] Over the years I have presented many times to various clients describing Business Intelligence (BI) solutions using the Microsoft BI solutions stack. In all of...

2016-01-11

14 reads

Calculating Table Partition Sizes in Advance

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 7.
The partitioning includes several major...

2015-11-30 (first published: 2015-11-23)

1,492 reads

Calculating Table Partition Sizes in Advance

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog] Continuing on with my Partitioning post series, this is part 7. The partitioning includes several major components of work (and can be linked...

2015-11-23

7 reads

Implementing Partition Aware Index Optimisation Procedures

by Mr Fox SQL

Mr. Fox SQL

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 6.
The partitioning includes several major...

2015-11-09

1,185 reads

All authors

Mr Fox SQL

Compression Performance with Low Key Selectivity

SQL Filegroup/File Proportional Fill Algorithm

SQL Filegroup/File Proportional Fill Algorithm

A “Business Intelligence” (BI) Definition

SQL Saturday Melbourne (#464) – 20 Feb 2016

SQL Saturday Melbourne (#464) – 20 Feb 2016

A “Business Intelligence” (BI) Definition

Calculating Table Partition Sizes in Advance

Calculating Table Partition Sizes in Advance

Implementing Partition Aware Index Optimisation Procedures

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Midjourney, Healthcare?

Changes, Happiness, and a Few Tears

BCP on Linux

Question of the Day

BCP on Linux