SQL Server Quickie #44 – SQL Server on Docker
SQLpassion Blog
by Klaus Aschenbrenner
3w ago
Today I have uploaded SQL Server Quickie #44 to YouTube. This time I’m talking about SQL Server on Docker ..read more
Visit website
Vscode-binutils: Analyzing Binary Files directly within Visual Studio Code
SQLpassion Blog
by Klaus Aschenbrenner
2M ago
As you know, I’m a crazy person, and I have done a lot of different computer science research projects like developing my own RISC-based CPU and implementing my own x64-based operating system. But over the last weeks and months, I have spent a lot of time doing some low-level research in the Linux Kernel. This work helps me to better understand how Linux works, how SQL Server works on Linux (and on Docker), and it also helps me for further improving my own operating system implementation. The Windows Subsystem for Linux (WSL) is here a great help, because it gives me a fully working Linux ..read more
Visit website
Configuring WSL on Windows Server 2022 for Visual Studio Code Remote Access
SQLpassion Blog
by Klaus Aschenbrenner
4M ago
Over the last few weeks and months, I have spent a lot of time researching and experimenting with Linux on a very low level – mostly directly on the C and assembly level in combination with the official source code. For that reason, I had initially built a dedicated Ubuntu virtual machine to perform my research and my experiments. But a dedicated virtual machine for this purpose is a quite huge overhead. Therefore, I have tried to reproduce my research efforts directly in WSL – the Windows Subsystem for Linux, which is available on the most recent Windows builds – including Windows Server 2022 ..read more
Visit website
SQLpassion Live Training about SQL Server Availability Groups
SQLpassion Blog
by Klaus Aschenbrenner
5M ago
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 this live training you will learn the basic architecture around Availability Groups, how to work with Availability Groups, and how to troubleshoot them. During the live training I will cover the following areas: I ..read more
Visit website
Virtual Memory & x64 Long Mode
SQLpassion Blog
by Klaus Aschenbrenner
6M ago
In my last blog posting I have talked about how you can read and execute the Second Stage Boot Loader of your own Operating System. In today’s blog posting I want to show you in the first step how you can remove the dependency from floppy disks. Afterwards we will switch our CPU into the x64 Long Mode, which is necessary to be able to execute our x64-based OS Kernel. Reading Data through ATA PIO Over the last few blog postings, you have already learned how to read from floppy disks through the BIOS interrupt 0x10. Floppy disks are great for the first steps in OS development, because you can in ..read more
Visit website
Loading and executing the Second Stage Boot Loader
SQLpassion Blog
by Klaus Aschenbrenner
7M ago
In the last blog posting I have talked about how to read files from a FAT12 partition and print out its loaded content to the screen. In today’s blog posting I want to talk more about how to implement a Second Stage Boot Loader that can be loaded into memory for its execution. But let’s talk first, why we need a Second Stage Boot Loader. Second Stage Boot Loader – Why? In my first blog posting about OS development, we have talked about how the BIOS loads the boot sector at the memory location 0x7C00 and executes it. The restriction of the boot sector is that it has only a size of 512 bytes (on ..read more
Visit website
SQLpassion Live Training about Query Tuning Fundamentals
SQLpassion Blog
by Klaus Aschenbrenner
11M ago
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 the information available inside an execution plan. You will see how SQL Server retrieves data from the database files, how SQL Server can join resultsets, and how you can react with indexes if you are in performance troubles. During the live training I will cover the following areas: How ..read more
Visit website
Reading Files from a FAT12 Partition
SQLpassion Blog
by Klaus Aschenbrenner
1y ago
In my last blog posting I have talked about how a PC boots up, and how you can write your own boot loader. As you have seen it is quite easy to spin up your own OS and print out some characters to the console. But at some point, you need to have the functionality to load additional files into memory, because you can’t do that much work with 512 bytes available in the boot sector. In the case of my OS, it must load the Second Stage Boot Loader (x32 code) into memory and execute it. The Second Stage Boot Loader loads the real Kernel from the file system, switches the processor into Long Mode (x6 ..read more
Visit website
Heap Tables
SQLpassion Blog
by Klaus Aschenbrenner
1y ago
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 not sorted in any way, it’s just a pile of unordered, unstructured records. When you access a heap table through a SELECT statement, SQL Server will use a Table Scan operator in the Execution Plan, when you have no suitable Non-Clustered Index defined. There is no Table Seek operator available. That’s ver ..read more
Visit website
Data Page Restrictions
SQLpassion Blog
by Klaus Aschenbrenner
1y ago
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 records you can store on one page. When you deal with fixed-length data types (like CHAR, INT, DATETIME, etc.) you have the restriction that the record length can’t exceed the 8060 bytes including the internal overhead that SQL Server uses. Restrictions – the good ones When you have a table with less ..read more
Visit website

Follow SQLpassion Blog on Feedspot

Continue with Google
OR