I’ve had a really disappointing experience with the Liquid Web sales team, regarding the web server that hosts this blog post you’re reading right now. My disappointment is compounded...
2024-01-26
36 reads
Understanding query plans is key to successful query tuning in Microsoft SQL Server. Randolph West of the Microsoft docs team posted on Thursday that the logical and physical showplan...
2024-01-26
48 reads
So what did I learn? I think a better question is, "What did I re-learn?"
2024-01-26 (first published: 2024-01-09)
241 reads
It’s T-SQL Tuesday again! In fact, it’s the first of the year and our intrepid host is Reitse Eskens (blog|twitter). ... Continue reading
2024-01-24 (first published: 2024-01-09)
531 reads
I am a big fan of the cloud. While I appreciate local storage and privacy/control/security, etc., that stuff can also go away locally. Plus, I like the convenience, and...
2024-01-24
41 reads
A couple of weeks ago, I encountered a DAX question that I had not previously considered. They had a situation where there were two paths between two tables: on...
2024-01-24 (first published: 2024-01-09)
497 reads
All Spark Connect Posts
Goal of this post This post aims to show how we can create a .NET application, deploy it to Databricks, and then run a Databricks job...
2024-01-24 (first published: 2024-01-23)
110 reads
Since conditional formatting was released for Power BI, I have seen countless examples of bar charts that have a gradient color fill. If you aren’t careful about the gradient...
2024-01-23
22 reads
When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...
2024-01-22 (first published: 2024-01-04)
225 reads
Have you ever been tasked with creating test data for an application and then ran into performance problems once the application moves to production? Many of us manage databases...
2024-01-22 (first published: 2024-01-08)
639 reads
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers