The State of SQL Server Monitoring was launched in 2018. This year we are interested in gathering insight across database platforms, not just SQL Server. Have your say and take the survey to be first to receive the report and enter your chance to win a $500 Amazon voucher.
Take the survey.
Do you remember the very first time you had to do a database restore to fix something you messed up?
The purpose of this article is to detail steps that would help implement an enhancement to reporting application that uses SQL Server Database (or any other database) in backend without causing downtime to reporting application.
Sometimes it is hard to admit that you are not the best person for the job that is presented to you.
This presentation is to get you thinking about the disaster recovery options for SQL Server, things like backups, log shipping, Availability Groups, clustering and more while putting them in the context of the enterprise.
You have more time to earn that MCSA, MCSE, or MCSD, thanks to Microsoft and the pandemic.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
Delve behind the scenes and learn about the catalog used to manage Azure Data Lakes.
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Telp/wa 085169998765 Jl. Transyogi Cileungsi-Cibubur. 3-4 RT 002/003, Cileungsi, Kec. Cileungsi, Kabupaten Bogor, DKI...
BCA Kantor Kas Thamrin City Telpon/wa:0813.7887.595.Jl. Kb. Melati 5 No.26, Kb. Melati, Kecamatan Tanah...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Boulevard Raya No.1 Blok L, Klp. Gading Tim., Kec. Klp. Gading, Jkt...
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