Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
T-SQL Challenge #1
Do you want to improve your T-SQL skills? MVP Jacob Sebastian runs regular challenges to get you to think about how to solve a problem in T-SQL. These run monthly and we have a summary and explanation from challenge #1 to help you learn more about moving data from 3 tables into a specific format.
Disaster Recovery for SQL Server Databases
High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
SQL Server 7.0 – Transaction Log Not Backing Up
I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...
A Function Gotcha with the Use of an Asterisk
This article describes and demonstrates the problem of using asterisk to select all fields from a table within a table function. (from Apr 2008)
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Moore's Law
Moore's Law has been in the front of technical people's minds for years. However is the end of it's applicability to our world near? This Friday Steve Jones asks if you pay attention to the news about processor hardware.
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
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...
Forums
BCA KCU GALAXY TLP/WA 083800209966
BCA KCU GALAXY TLP/WA 083800209966 Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec....
BCA KCU DARMO TLP/WA 083800209966
BCA KCU DARMO TLP/WA 083800209966 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya,...
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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