2022-10-18 (first published: 2022-10-14)
452 reads
Administration
2022-10-07
487 reads
2022-10-05
558 reads
[Video] Fragmentation Explained in 20 Minutes at SQLBits
What does fragmentation mean? How does it happen? Can you fix it with fill factor? Should you rebuild your indexes to fix it?
2022-09-26
2022-09-16
353 reads
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
3,838 reads
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
144 reads
Getting More Information From the String or Binary Data Truncated Error
Get more information from the string or binary data truncated message to help troubleshoot data problems on SQL Server 2016, 2017, and 2019.
2022-08-17
5,983 reads
2022-08-03
464 reads
Linked Servers: a Peek Behind the Curtain
Learn how a linked server caused an issue with Gallium Data.
2022-07-15
5,104 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers