Democratizing the Microsoft MVP Award
Tony Davis believes that it's time for a little more openness and democracy in the MVP award. In short, it's time to introduce community voting.
2010-02-08
137 reads
Editorial
What's a Toaster?
There are always generic items that we encounter in life, things where it doesn't seem to matter to each of us what brand/price/model we pick. This Friday Steve Jones asks what you might consider to be generic in your job.
2018-07-27 (first published: 2010-02-05)
383 reads
What Do You Include in Your Database Maintenance Plans?
A guest editorial from Brad McGeHee today talks about maintenance plans and his new book.
2010-02-04
580 reads
Too Good to be True? The Story Behind SQL Search
A guest editorial today from Simon Galbraith, founder of Red Gate Software talking about SQL Search, a new product that was developed in an interesting way.
2010-02-03
346 reads
Coding By The Sea
An interesting experiment at Red Gate, Coding By the Sea, produced results, and Steve Jones thinks this could be a great idea for other companies.
2010-02-02
162 reads
Get In a Line
Steve Jones talks a little about disk alignment for your SQL Server instances. This is something that you might to check on your systems and see if you can improve performance.
2010-02-01
142 reads
Keeping It All In Memory
With the release of an in-memory database from Sybase, is it time for SQL Server to join the fray?
2010-02-01
320 reads
Rotating Keys
This Friday's poll deals with security. Steve Jones asks how often you might rotate those encryption keys to ensure that your systems are secure.
2010-01-29
148 reads
Arrogance Has No Place in Security
Arrogance has no place in assessing threats and attempting to build security to mitigate them.
2010-01-28
123 reads
The Dying Administrator
Is the SAN administrator dying out as a job? Steve Jones comments on an article that suggests it might be.
2010-01-27
189 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