SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this fall. Now in its fourth year, it features presentations by some of the world’s top SQL Server speakers.
2014-10-23 (first published: 2014-08-15)
1,044 reads
SQL in the City London is a Red Gate event, full of SQL Server MVP training and networking. These events get bigger and bigger each year, so it's not one to be missed!
2014-10-23
940 reads
Red Gate are developing new tools for users of SSDT and Database Projects in Visual Studio. If you use these technologies, help us make our tools ingeniously simple by completing this 10 minute survey.
2014-10-21
14,721 reads
DevIntersection and SQLIntersection conference will bring together experts from Microsoft, SQLSkills, .NET Rocks, and 90 industry gurus.
2014-10-20
275 reads
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.
2014-10-14
6,901 reads
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.
2014-10-13
8,510 reads
SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.
2014-10-09
7,670 reads
Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.
2014-09-30
8,081 reads
An interview with James Rowland-Jones in advance of the PASS election.
2014-09-26
6,152 reads
This is Orlando's 8th SQLSaturday and this year will be better than ever with more than 50 different speakers giving over 50 presentations - all for FREE. Sept 27, 2014.
2014-09-26
7,599 reads
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers