SQL Server Infernals – Circle 5: Inconsistent Baptists
There’s a place in the SQL Server hell where you can find poor souls wandering the paths of their circle,...
2015-07-23 (first published: 2015-07-17)
2,935 reads
SpaghettiDBA
SQL Server Infernals – Circle 4: Anarchic Designers
Constraints are sometimes annoying in real life, but no society can exist without rules and regulations. The same concept is...
2015-07-07
819 reads
SQL Server Infernals – Circle 3: Shaky Typers
Choosing the right data type for your columns is first of all a design decision that has tremendous impact on...
2015-07-10 (first published: 2015-07-02)
2,227 reads
SQL Server Infernals – Circle 2: Generalizers
Object-Oriented programming taught us that generalizing is a good thing and, whenever possible, we should do it. Complex class hierarchies...
2015-06-29 (first published: 2015-06-24)
977 reads
SQL Server Infernals – Circle 1: Undernormalizers
There’s a special place in the SQL Server Hell for those who design their schema without following the Best Practices....
2015-06-17
868 reads
Announcing SQL Server Infernals
Today I’m starting a new blog series called “SQL Server Infernals”.
Throughout this series, I will take your hand and walk...
2015-06-09
670 reads
Native Client Aliases don’t like Trailing Spaces
I usually don’t post small things like this, but today I fought with this obnoxious problem long enough to convince me that...
2015-06-02 (first published: 2015-05-26)
1,560 reads
Counting the number of rows in a table
Don’t be fooled by the title of this post: while counting the number of rows in a table is a...
2015-05-25 (first published: 2015-05-18)
9,258 reads
How to post a T-SQL question on a public forum
If you want to have faster turnaround on your forum questions, you will need to provide enough information to the...
2015-04-24
2,282 reads
Tracking Table Usage and Identifying Unused Objects
One of the things I hate the most about “old” databases is the fact that unused tables are kept forever,...
2015-04-29 (first published: 2015-04-20)
16,506 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers