2016-04-01
137 reads
Editorials
The Database Transaction Unit (DTU) Decoded
In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.
2016-04-01
2,710 reads
Examining SQL Server 2016
Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.
2016-03-31 (first published: 2016-03-29)
294 reads
Is PowerShell Intimidating?
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
2016-03-30
197 reads
Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
93 reads
Dexterity Matters
The individual's dexterity can impact how we use software. Perhaps we need ways to undo mistakes in various systems.
2016-03-28
73 reads
2016-03-28
188 reads
Protecting sa
Today Steve Jones talks about the issues with the sa account, and how you might protect this on all your instances.
2016-03-25
113 reads
Do Less
One way to make code run faster is to have less of it. Or ensure the code you have does less work.
2016-03-24
118 reads
2016-03-22
162 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