Saving the Day from Delay: Recap & Series Kick-Off
Ironically, I’m a few months behind on a recap for my presentation on building and using a sustainable, dynamic date query in M code – Saving the Day from...
2021-01-05
16 reads
DataOnWheels
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
127 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
15 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-30 (first published: 2020-10-23)
228 reads
Welcome to 3Cloud …
A little over a month ago, Pragmatic Works Consulting was a part of a merger that included 3Cloud and Applied Cloud Services over a period of a few months....
2020-10-23
10 reads
Azure SQL Database Elasticity – Presentation Notes
This blog covers the content and points to the code used to create the demos in my Azure SQL Database Elasticity presentations. As of today, I have presented this...
2020-10-27 (first published: 2020-10-20)
355 reads
New Logo, More Family Contributions
Kristyna and I were looking for an update to our logo prior our sponsorship and speaking at the Minnesota SQL Server User Group (PASSMN) in September 2020. I had...
2020-09-03
57 reads
Your First Databricks Notebook
On August 4, 2020, I presented this on the weekly Pragmatic Works webinar series. You can view that presentation here. As part of that presentation, I committed to give...
2020-08-26 (first published: 2020-08-13)
909 reads
Congratulations to Pragmatic Works – Microsoft Partner of the Year Finalists, Again
Pragmatic Works has done it again. Microsoft has recognized us for our work this year with two finalist awards — Power BI and PowerApps and Power Automate. This recognizes...
2020-07-14
56 reads
PASSMN June 2020 – Data Classification with SQL Server and Azure
I presented at the virtual Minnesota SQL Server User Group meeting on June 16, 2020. The topic was data classification with SQL Server 2019 and Azure SQL Database. Data...
2020-06-17
64 reads
Blogs
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
The Disabled Index
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers