Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.
Learn how you can automate the creation of the CML and CEK for Always Encrypted in SQL Server
Kathi Kellenberger discusses the challenge of deciding how to describe the content in the sessions she presents.
A good day for a database administrator (DBA) is a lot like a good airline flight. A lot of excitement in either situation is bad. In a perfect world, a DBA will be productive and not spending most of their time “putting out fires.” (And fires are never a good idea on a flight!)
One of the decisions that I've been involved with at the beginning of every software project is whether to buy software to solve the problem or build our own. This might be a quick "is there software anyone knows about to do this?" query, or an in-depth review of the marketplace or something in between. […]
We have got a deal for you, Microsoft is concerned about the health of your company and is doing something about it.
It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.
Whether you’re looking to go cutting-edge and hop on SQL Server 2019 as soon as it’s available, or whether you’re just trying to evacuate from SQL Server 2008 to anything that’s going to be supported after this summer, you’re probably doing upgrade projects. This is a good time to ask yourself 5 questions...
In this second part of this tip series we take a look at the dplyr package for R that can be used to query data using the R Language with SQL Server and build data visualizations.
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...
Komplek Pertokoan Metro Trade Center, Jl. Soekarno-Hatta No.590 Blok D01 & D02, Sekejati, Kec....
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
Jl. DR. Abdul Rivai No.11, Pasir Kaliki, Kec. Cicendo, Kota Bandung, Jawa Barat 40131
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