Unless development happens directly on the production database, every organization will manage one or more development and test instances. Redgate is doing research to learn how development and test databases are managed within organizations. If you’d like to know more about our plans, or are happy to help us understand the problem, please take part in this 3-page survey.
Work is important, and it's a large part of our lives, but Steve Jones notes we need to keep things in perspective.
One of the benefits of a version control system (VCS) is that you can look at the history of code changes. Ed Elliot shows us a situation where that helps a DBA track down a problem.
Consider a situation when you have a large number of databases on your SQL Server, and you are requested to grant user access to all SQL Server databases. How can you grant access to a user for all databases on a SQL Server instance?
References and links to help you learn how to create multiple tempdb files.
A few links to help you understand the Cardinality Estimator.
A list of technologies in SQL Server 2014 that you might want to learn more about.
Phil factor find much to admire in the StackOverflow architecture. It is built on SQL Server, doesn't use microservices or the cloud. It all seems a bit retro, but it manages manage 440 million queries a day, peaking at 8500 queries per second, and never even breaks into a sweat.
Automation - done right - frees you to add real value to your team, but you've got to be careful not to shoot yourself in the foot. Join Brian A. Randell, Grant Fritchey and Steve Jones as they discuss how to get started when automating your database operations, and what activities are ripe for automation!
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...
Untuk menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp (6288220114008): atau...
Untuk menonaktifkan dan menutup kartu kredit Bank UOB, Anda dapat menghubungi UOBCall melalui WhatsApp...
Hi to all We have situation at a client where someone is illegally changing...
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