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,266 reads
humor
2024-04-01
450 reads
CosmosDB APIs Inside SQL Server 2024
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
173 reads
2023-12-29
434 reads
2023-12-25
409 reads
Why Haven’t You Disabled SA? Wrong Answers Only.
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
422 reads
The Top 5 Technologists
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
166 reads
2022-10-31
736 reads
2022-05-30
548 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers