2021-09-08
823 reads
Evgeny Garaev
2021-08-13
743 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,120 reads
2021-04-27
841 reads
2021-04-26
502 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)
995 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,415 reads
2020-07-24 (first published: 2018-12-27)
4,769 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-07-09 (first published: 2018-06-05)
2,442 reads
2020-07-07
587 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kantor BCA KCP Pahlawan Telp:083178278662
Telp:083178278662Jl. Khp Hasan Mustopa No.108, Padasuka, Kec. Cibeunying Kidul, Kota Bandung, Jawa Barat 40125
Alamat kantor BCA KCU DIPONEGORO Telp:083178278662
Telp:083178278662Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat kantor resmi BCA KCU THAMRIN Telp:083178278662
Telp:083178278662Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers