Initialize a Transactional Replication from a Database Backup
During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that...
2012-08-05
1,540 reads
Klaus Aschenbrenner
SQL Server Quickie #2 - Extents
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I'm
talking about Extents, and how SQL...
2012-08-04
1,120 reads
SQL Server Quickie #2 – Extents
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...
2012-08-04
634 reads
SQL Server Quickies – a new way to learn about SQL Server
We are all living in a fast moving world, especially in the IT industry. We have to
learn new technologies every...
2012-08-01
1,301 reads
SQL Server Quickies – a new way to learn about SQL Server
We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies...
2012-08-01
495 reads
Perform a Rolling Upgrade to SQL Server 2008 R2 SP2 in a Database Mirroring Scenario
Yesterday evening (European Time zone) Microsoft has released the SP2 for SQL Server
2008 R2. You can download the Service Pack...
2012-07-27
2,560 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,732 reads
SQL Server Performance Tuning & Troubleshooting Workshop
Der Sommer 2012 ist schon ein interessantes Phänomen
– gestern Sonnenschein mit 34°, und heute wieder Regen mit 20°. Gestern war...
2012-07-25
1,293 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 3: Setting up AlwaysOn through T-SQL
In the last blog posting about AlwaysOn you have seen how you can deploy your first
Availability Group through the AlwaysOn...
2012-07-25 (first published: 2012-07-23)
7,105 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 2
It's already a long time since I have blogged how
to configure your Windows- and SQL Servers for SQL Server 2012...
2012-07-23 (first published: 2012-07-19)
5,311 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Comments posted to this topic are about the item Delta Lake: The Definitive Guide:...
Databricks Data Intelligence Platform: Unlocking the GenAI Revolution
Comments posted to this topic are about the item Databricks Data Intelligence Platform: Unlocking...
Storytelling with Data: Let's Practice!
Comments posted to this topic are about the item Storytelling with Data: Let's Practice!
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers