2021-09-08
864 reads
Evgeny Garaev
2021-08-13
747 reads
Index fragmentation on all databases
The script returns all the fragmented indexes on all databases on the instance you run it. Can be run on multiple instances in the same time using central management capability.
2021-07-12 (first published: 2021-07-06)
4,266 reads
2021-04-27
859 reads
2021-04-26
517 reads
Space allocated to the databases by disk letters
Found this useful for database migrations. This helps to identify how much space will need to be allocated for a new server and how a SQL Sever instance is using discs currently. Note. This won't show correct information on Linux instances and if you use mounting points in Windows.
2021-04-23 (first published: 2021-04-19)
1,021 reads
Offline R Services installation and patching
The R Services installation package is not included in the MS SQL Server installation package. When you install MS SQL Server with R Services the installer actually download the package from the Internet.
2021-02-12 (first published: 2019-03-28)
9,554 reads
2020-07-24 (first published: 2018-12-27)
4,816 reads
2020-07-07
599 reads
Logshipping to SQL Server on Linux
An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.
2020-06-25 (first published: 2018-06-05)
2,490 reads
Blogs
Microsoft Fabric Data Agents: Bringing Structured and Unstructured Data Together
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Forums
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Hyperscale Replicas I
Comments posted to this topic are about the item Hyperscale Replicas I
The End of Summer
Comments posted to this topic are about the item The End of Summer
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers