Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
373 reads
The DBA Who Came In From The Cold
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
1,013 reads
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
373 reads
SQL Server 2016 – Stretch Databases
One of the features I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-25 (first published: 2015-06-15)
5,557 reads
SQL Server 2016 – Stretch Databases
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
531 reads
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
1,365 reads
SQL Server 2016 features I’m interested in
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
501 reads
In-Memory OLTP: Part 4 – Native Compilation
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
912 reads
In-Memory OLTP: Part 4 – Native Compilation
This post follows on from In-Memory OLTP: Part 3 – Durability & Recovery
In this final post for the #SQLNewBlogger challenge I want...
2015-04-27
332 reads
In-Memory OLTP: Part 3 – Checkpoints
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
1,097 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers