SQL Server Quickie #44 – SQL Server on Docker
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker.
SQLServer
SQLpassion Live Training about SQL Server Availability Groups
On September 29, 2022 I will run an SQLpassion Live Training about SQL Server Availability Groups. High Availability with previous versions of SQL Server was always complex: you had Clustering, Database Mirroring, Log Shipping, and Replication. Beginning with SQL Server 2012 Microsoft changed everything and introduced a new High Availability technology called Availability Groups. In …
SQLpassion Live Training about SQL Server Availability Groups + read more
SQLpassion Live Training about Query Tuning Fundamentals
On May 3, 2022 I will run an SQLpassion Live Training about SQL Server Query Tuning Fundamentals. If you have a database driven application which reacts very slowly when the data increases, then you are right in this live training! In this live training you will learn how you can tune SQL Server Queries with …
SQLpassion Live Training about Query Tuning Fundamentals + read more
Heap Tables
In today’s blog posting I want to talk about Heap Tables in SQL Server. Heap tables are tables without a Clustered Index. A table in SQL Server can have a Clustered Index, then it’s called a Clustered Table, and without a Clustered Index, it’s called a heap table. In a heap table, the data is …
Data Page Restrictions
Today I’m talking about limitations that you have with data pages, and why there are restrictions that you will love, while you will hate other restrictions. As you learned, a data page is always 8kb large, and you can store 8060 bytes of data on it. And the size of your records dictates how many …
