I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
I read, a lot. I’ve been a prolific reader all my adult life. I use to split my reading between tech books and my regular relaxing reading but since I got into audio books several years ago I just pretty much read tech books now. Some times I’ll listen..
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
Are you looking to raise your profile? Add something to your resume? Consider writing for SQLServerCentral. Longtime author and expert David Poole gives us some hints.
This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.
This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Hi to all We have situation at a client where someone is illegally changing...
Hi to all We have situation at a client where someone is illegally changing...
This week my BI Developer colleague proudly showed me a new Power BI report...
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