A New Word: Ozurie

Ozurie – feeling torn between the life you want and the life you have. I think many people feel ozurie often. I certainly had a lot of this in...

Notes from SQLSaturday South Florida 2023

Quick notes on the event this year: Overall a good event and now I have a few months until SQLSaturday in Orlando in October.

Statistics and the Ascending Key Problem

I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...

Volunteering at Work: Teaching Others

I give a few talks on career topics, and one of these is Branding Yourself for a Dream Job. In the talk, I sometimes tell a story in the...

db_ddladmin Jr.

A while back I talked about the fact that you can grant someone CREATE PROCEDURE and ALTER on a schema ... Continue reading

Tracking the Inaccurate Cardinality Estimates

Tracking the Inaccurate Cardinality Estimates

When it comes to query performance, lately the Cardinality Estimates seems to have been a hot topic with each new release  of SQL...

Microsoft Fabric Overview

First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn...

Reading and searching events inside the SQL Server default trace

Note: SQL Trace and SQL Server Profiler are deprecated and will be removed in a future version of Microsoft SQL Server. The replacement technology for them is Extended Events. To Learn More: https://learn.microsoft.com/en-us/sql/relational-databases/sql-trace/sql-trace?view=sql-server-ver16SQL Server...

Tech Lunch News

Tech Lunch News

Červencové novinky ze světa dat byly trochu prázdninové a odpočinkové, ale i tak jsme se podívali na pár zajímavých a šikovných demíček, které by se vám mohli hodit.
Co nového...