The Mastering Azure Data Studio Series
A list of articles in my series on Azure Data Studio along with a few other links.
2024-09-13 (first published: 2024-01-10)
3,095 reads
A list of articles in my series on Azure Data Studio along with a few other links.
2024-09-13 (first published: 2024-01-10)
3,095 reads
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
2024-09-13
In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.
2024-09-13
This next article examines the impact of transaction sizes on the performance of our Delta Parquet tables.
2024-09-11
2,093 reads
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
2024-09-11
2024-09-09
4,196 reads
Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.
2024-09-09
I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]
2024-09-06
5,727 reads
Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.
2024-09-06
I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work.
2024-09-04
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
Unused Indexes in SQL Server: Find them, vet them, and drop them safely Indexes are...
By Steve Jones
I hosted this month, late as it turns out, but we still had a...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
This is a topic to test whether reply notifications are working or not.
What does a slipstream installation mean?
See possible answers