A TON of new features announcements at the European Microsoft Fabric Community Conference help last week. The full list is here, and I wanted to list my favorite announcements...
2024-10-08 (first published: 2024-10-07)
22 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
33 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
9 reads
If a technology is still viable, don’t overlook it. Don’t get caught up chasing the “shiny” or the “perfect” solution just because you can.
2024-10-08
11 reads
Last Updated on September 24, 2024 by John Morehouse Years ago, I saw the wave of the future and that wave was Cloud. The Cloud is not a fad...
2024-10-07 (first published: 2024-09-24)
373 reads
I got a message a few months back that Microsoft was deprecating the MySQL server version that I was using in Azure. The cost was going up, and while...
2024-10-07
7 reads
I often need to shrink database files. I know, ‘shrinking is bad’, however there are situations where it is very much needed. In my line of work, I come...
2024-10-07
95 reads
Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...
2024-10-07 (first published: 2024-09-22)
283 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential for revealing insights buried within extensive databases. However, basic SQL queries can only take you...
2024-10-07
29 reads
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-06 (first published: 2024-10-05)
16 reads
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
i have subscription of github copilot which i can access in vs 2022 comunity...
Comments posted to this topic are about the item Password Guidance
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers