We want to hear from you on the approaches you take and the challenges you face when delivering test data to development and testing environments. Take part now for an advance copy of the research and a chance to win a $250 Amazon voucher.
Learn how you can create a SQL Server instance in the Google Cloud Platform.
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
Whether you are a long time Redgate customer or have recently made a purchase you can find helpful and easy to follow video courses on Redgate University. With the brand-new look and the recently added courses you will soon be getting the most from your Redgate tools.
You can use SQL Audit to record changes to security, access to tables, and more to help you meet compliance requirements. In this article, Joshua Feierman explains how to set up the audit and collect the data in Azure Log Analytics when running SQL Server in an Azure VM.
SQL Change Automation's Development component for developing new databases and modifying existing databases, using migrations, now integrates directly into SQL Server Management Studio as well Visual Studio. It allows teams to collaborate effectively during development, regardless of their preferred IDE, and in a way that integrates easily with common build/integration servers and release management tools.
Is the DBA a fading star? More likely, there is a general lack of understanding of the roles of the different types of DBA, and of the other IT teams that ensure that successful application developments happen in any large enterprise.
In this blog post Rebecca Woof walks us through the new features of SQL Monitor 9.1. With PowerShell API alerting and a new permissions table the latest release addresses challenges that come with a growing SQL Server Estate.
In this tip we look at ways to sort alphanumeric strings in SQL Server by decomposing all numeric values and sorting the string based on numeric sorting rules.
There is a lot of data collected from web browsing. Steve doesn't think we need all that data, unlike Google.
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...
Jl. Samanhudi No.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat, Daerah Khusus Ibukota...
Rukan Ekslusif Bukit Golf Mediterania, Pantai Indah Kapuk St No.17 Blok C, RT.7/RW.2, Kamal...
Blok A VI No, Jl. Parang Tritis Raya 3B-3C, Ancol, Kec. Pademangan, Jkt Utara,...
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