Data Overload
When do you have too much data? What do you do if you aren't actually using all of it?
2016-08-09
91 reads
Editorials
Making Complex Table Changes
The complexity of tables makes modifying them over time a challenge, especially as data sizes grow.
2016-08-08
74 reads
Security Shaming
This week Steve Jones looks at a new idea, rating the security of products publicly to try and shame vendors into more secure coding.
2016-08-08
89 reads
Failover
Too many failovers can cause problems, as can those that happen to often. Steve Jones says you need to consider whether you always need to failover in a sitaution.
2016-08-05
183 reads
2016-08-04
232 reads
Moving Fast at Redgate
It's possible to change a software development team and dramatically improve things. Steve Jones highlights an example from Redgate Software.
2016-08-02
95 reads
2016-08-01
71 reads
Passwords Under Pressure
Passwords are a problem, especially when we're in a hurry. What should we do?
2016-08-01
91 reads
How Far Have You Traveled for a SQL Saturday?
This Friday Steve Jones talks SQL Saturdays and asks how far you've traveled to attend one.
2016-07-29
108 reads
Too Much Information for Sports
Gathering too much data isn't always helpful, and doesn't necessarily help you make better decisions. However, that's up to you to decide how much is too much.
2016-07-28
82 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
BIT_COUNT() IV
Comments posted to this topic are about the item BIT_COUNT() IV
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers