Today the Data Platform Virtual Summit begin at 06:00 am for us…
It’s in our time offset, this time better to wake up! 😉
My schedule for the day:
- D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay Mahajan
- D3B2 – KATMAI – Extent and Page Management in Microsoft SQL Server – Expert – Torsten Strauß
- D3B3 – SPHINX – SQL Server on Linux & Kubernetes! – From Zero to Hero – Intermediate – Tejas Shah & Amit Khandelwal
- D3B4 – SPHINX- How to model and partition data in Azure Cosmos DB to achieve cloud scale – Intermediate – Richa Gaur
- D3B5 – HYDRA- Deadlocks – Analysing, Preventing and Mitigating – Advanced – Erland Sommarskog
- D3B6 – SHILOH – Performance tuning for Azure Cosmos DB – Intermediate – Hasan Savran
- D3B7 – HYDRA – My Favourite New T-SQL in SQL Server 2022 – Intermediate – Edward Pollack
- D3B8 – KATMAI – Data Ingestion on Azure: Real-life scenarios and solutions – Intermediate – Dustin Vannoy
I will begin with the session SQL Server on Linux & Kubernetes! – From Zero to Hero from Tejas Shah & Amit Khandelwal because it’s not every day that we work on Linux with SQL Server. I good agenda in perspective:
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-78.png)
We have in Azure already images to create our SQL Server on Linux in Azure:
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-79.png)
You don’t need to install SQL Server, it’s already there and created in few minutes…
It’s also good to see a remember of the Best Practice for SQL Server VMs:
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-80.png)
Forced-Unit-Access is one of the most important configuration to keep in mind and to enable to have good performance.
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-81.png)
A good summary to have good performance on Linux with SQL Server
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-82.png)
After the presentation of the installation though Kubernetes, I great demo for the HA
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-83.png)
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-84.png)
It was a very interesting session.
Now, go to the next one…
I follow the session of Edward Pollack named My Favourite New T-SQL in SQL Server
On this session I discover a lot of new T-SQL to have better quality of the code:
The first T-SQL is “IS DISTINCT FROM / IS NOT DISTINCT FROM” very useful to use and can replace = and <> but include null (this is the good point). I will write soon a blog on it.
The second is APPROX_PERCENTILE_xxx where is already used in SQL 2019 for APPROX_COUNT_DISTINCT but extend on SQL Server 2022
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-85.png)
The next one is the DateTrunc() to rounds/truncates a date/datetime and can be use in order by and order by
Some new bit manipulation to be useful if you need to manipulate it
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-86.png)
The Greatest() and the Least() return the largest or smallest value from any number of expressions.
A great demo to illustrate it with dates to find the first and the last date of modification:
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-87.png)
String_Split() to splits up a delimited string into its component elements.
Date_Bucket() returns a rounded date/time based on a given date part:
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-88.png)
This can be very useful to use for date aggregation and group dates.
Generate_ series() builds a number series based on a set of parameters
![](https://www.dbi-services.com/blog/wp-content/uploads/sites/2/2022/09/image-89.png)
Window allows a window function over clause to be reuse and simplify the T-SQL code.
First_value() and Last_Value() are very useful and return the first or last value for a column over an ordered window
This last session gives me the desire to test some of this new T-SQL commands and blog about it! 😉
See you tomorrow again for this great event with a lot of interesting sessions