How Automating Your Tests Improves Productivity
In some shops, testing is entirely in the realm of quality analysts. In this article, Julio Sampaio argues that testing should be automated and start with the developers.
SQL Prompt in Azure Data Studio now in free public preview
We’re pleased to announce that the SQL Prompt extension for Azure Data Studio is now available to download for free. With SQL Prompt in Azure Data Studio, you can use an extensive collection of code snippets to write your SQL code quickly and efficiently. You can also keep your code consistent using the powerful formatting capability, and customize the applied style to suit your preferences.
The Social Impact of Data
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
3 Things I Wish I Knew When I Started Using Entity Framework
Coming from a SQL developer background these few inner workings of Entity Framework caught me by surprise.
Migrating SQL Monitor’s Base Service to .NET Core
Josh Crang explains why SQL Monitor will be switched to run on .NET Core, and how the team tested the potential performance improvements in the monitoring service.
Storage 101: Modern Storage Technologies
In this article of the series, Robert Sheldon discuses emerging trends in storage like virtual SANs, intelligent storage, computational storage and storage-class memory.
Do You Think About CheckDB?
Running checkdb is part of ensuring your database health and data integrity. Steve notes that you might want to review that you have the best strategy for your organization.
How to Download Stocks on Schedule Using R
Learn how you can use R to download stock data from Yahoo and schedule a script to run as often as you would like.
Help Redgate to build the next generation of Database DevOps solutions
Help Redgate to build the next generation of Database DevOps solutions so that we can help you to deliver the next generation of your software. To get involved please complete our short 2-page survey on current development practices.
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU PONTIANAK WhatsApp 08388331786
WhatsApp 08388331786.Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
BCA KCP Ketapang WhatsApp 08388331786
WhatsApp 08388331786.Jl. M.T. Haryono No.68, Tengah, Kec. Delta Pawan, Kabupaten Ketapang, Kalimantan Barat 78812
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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