Custom Statistics Distributions in SQL Server 2022
You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag
2024-04-01
1,112 reads
You can create custom statistics distributions, sampling, and histograms in SQL Server 2022 with a new trace flag
2024-04-01
1,112 reads
2024-04-01
425 reads
New enhancements in SQL Server 2024 will allow MongoDB and Cassandra clients to store their data in a SQL Server database, in native NoSQL format.
2024-04-01
136 reads
2023-12-29
421 reads
2023-12-25
401 reads
On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:
2023-12-01
2023-11-24
414 reads
There's a common party question about which 5 people would you invite to a dinner party? Often this is amended to include living or dead people, and it's often interesting to hear people tell you who they'd invite and why. Since most of the people reading this work in technology in some way, I was […]
2023-02-24
161 reads
2022-10-31
730 reads
2022-05-30
541 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Comments posted to this topic are about the item Ingest and Retrieve data from...
Comments posted to this topic are about the item The DBAccountant
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers