SQL Monitor 10 packs a lot more under the hood in terms of connectivity, establishing cause-and-effect, and alerting. This article provides the high-level tour of the features we've introduced or improved, and why.
2020-03-20
MidnightDBA and Red Gate have joined together to produce a new book on SQL Server, written by 15 first-time authors. The resulting book, TribalSQL, includes everything you should know about SQL Server that isn’t taught in traditional training, they call it Tribal knowledge.
2019-03-26 (first published: 2013-09-18)
444 reads
This article from Tony Davis describes how to the use the Redgate SQL Compare and SQL Data Compare GUIs to get the current version of a database schema, and its static data, into version control, and then automate database deployments from the version control system using SQL Compare's command line and PowerShell.
2017-05-26
4,474 reads
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
749 reads
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
150 reads
The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.
2014-12-26 (first published: 2009-11-02)
543 reads
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
576 reads
Source control can and should play a key role in the database development and deployment process, and this book will show you exactly how to get started.
2014-11-11
1,915 reads
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
186 reads
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
2014-02-03
308 reads
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
By Steve Jones
I used Claude to build an application that loaded data for me. However, there...
End-to-end NVMe vs SCSI testing over NVMe/TCP to a Pure Storage FlashArray: TPC-C and...
Good Evening, Is there a simpler way to rearrange the following WHERE condition: [Column_1]...
Comments posted to this topic are about the item Which Table I
Comments posted to this topic are about the item Using Python notebooks to save...
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
SELECT ProductName
FROM product;
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers