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
363 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
999 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
368 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,544 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
520 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,354 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
494 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
896 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
323 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,087 reads
Blogs
SQL Training Black Friday Deals
By Brian Kelley
If you're looking for particular "Black Friday" deals, here is what I've seen advertised...
Dry-run xp_delete_file Before Actually Deleting Files?
By SQLPals
Dry-run xp_delete_file Before Actually Deleting Files? xp_delete_file doesn’t really have a...
Happy Thanksgiving! (USA Holiday)
By Brian Kelley
In the United States, today is Thanksgiving. The intent behind the holiday is to...
Forums
Which Object Definitions Are Available?
Comments posted to this topic are about the item Which Object Definitions Are Available?
What's Your Theme Music?
Comments posted to this topic are about the item What's Your Theme Music?
T-SQL in SQL Server 2025: The PRODUCT Function
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Which Object Definitions Are Available?
For which of these object types can I get the code when I run the OBJECT_DEFINITION() function in SQL Server 2025? (choose 3)
See possible answers