2010-03-04
3,288 reads
Press Release
A SQL Evening in London
Spend an evening with Itzik Ben-Gan, Greg Low, Davide Mauri and Bill Vaughn in London on March 16th. Come attend if you can.
2010-03-03
1,191 reads
SQL Saturday #33
A one day training event in the Charlotte, NC area. Come join MVPs from around the area at another great SQL Saturday.
2010-03-03 (first published: 2010-02-03)
4,143 reads
Data Mining with Microsoft SQL Server 2008 - Sample Chapter
Another sample chapter from Wiley, this time for one of the hot topics in business intelligence: data mining.
2010-03-02
2,608 reads
Expand Your Brand
There are a number of events coming up in 2010 that need speakers to share their knowledge of SQL Server with others. Check out this list and consider submitting something.
2010-02-24
437 reads
SQL Saturday #37 - Philadelphia
Come to this great one day training event in Philadelphia, PA. SQL Saturday is a great way to get free training on all aspects of SQL Server.
2010-02-24 (first published: 2010-02-04)
2,952 reads
Professional Microsoft SQL Server 2008 Reporting Services - Sample Chapter
Learn about SQL Server 2008 Reporting Services with this new title from Wiley. We have a sample chapter you can read to see if you like this book.
2010-02-23
2,831 reads
Professional Microsoft SQL Server Analysis Services 2008 with MDX - Sample Chapter
A sample chapter from a new book on Analysis Services. Check it out and see if this is the book for you.
2010-02-16
2,069 reads
Webinar Series: SQL Server 101
A partnership with Pragmatic Works brings you some basic SQL Server training through a series of webinars.
2010-02-15
2,057 reads
Newsletter Changes for Yahoo Mail
We have recently made a few changes in our newsletter sending process and been working with Yahoo to ensure delivery. If you are just receiving this newsletter to a Yahoo account, welcome.
2010-02-10
506 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
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