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,042 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
273 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 James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Comments posted to this topic are about the item Faster Data Engineering with Python...
Comments posted to this topic are about the item Which Result II
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
exec('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