Great Developers
A great developer is worth more than an average one, but how much more? Steve Jones has a few thoughts for you to think about.
2016-05-30 (first published: 2012-03-12)
581 reads
Editorials
Mentors and Professional Groups
When wrestling with technical problems or ideas, it is good to discuss with, argue against, present ideas to, and listen to your colleagues. This is true of anyone working in IT, but really important for the likes of database professionals who are engaged in a very rapidly-developing engineering specialism that demands that you keep up […]
2016-05-30
41 reads
Bias, the Serial Killer of Diversity
Today we have a guest editorial from Kellyn Pot'Vin that tackles the tough topic of diversity.
2016-05-27
157 reads
Should I Stay or Go?
Today we have a guest editorial from Andy Warren that looks at the decision to leave a job. Or not.
2016-05-26
150 reads
The Clustered Index is not the Primary Key
As the title says, the clustered index doesn't have to the primary key and vice versa.
2016-05-24
1,322 reads
Boundless Opportunities
There has never been more reasons or better opportunities to learn new skills. Gail Shaw shares her favorite online video training resources sites, what's on her current learning list and why.
2016-05-23
158 reads
The Politics of SQL Security
Dealing with SQL Server security when the application it uses is full of security holes.
2016-05-23
190 reads
What's Your Test Plan?
This week Steve Jones looks at the formal way in which you might verify changes to your system. Do you have a process?
2016-05-20
217 reads
The Complexity of Branches
Branching code creates complexity to development and should be undertaken with caution.
2016-05-19
87 reads
Half Baked Features
Steve Jones notes that some features aren't fully developed, but that's not a reason to avoid releasing them.
2016-05-17
137 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
Tables with a SPARSE Column and Consumption
Comments posted to this topic are about the item Tables with a SPARSE Column...
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers