Happy Memorial Day 2012
It's Memorial Day in the US and Steve out is paying tribute to our soldiers and cutting grass on the tractor. He's left you a blooper reel to enjoy.
2012-05-28
61 reads
Editorials
A Break from Data
This Friday, before the Memorial Day holiday in the US, Steve Jones wants to know how you would spend your break from work.
2012-05-25
118 reads
Making New Infrastructure Investments
One of the areas where the cloud may have the most impact is with new infrastructure improvements. Steve Jones talks about a few companies that are using the cloud in different ways.
2012-05-24
116 reads
The TCO of the Cloud
When is the cloud right for your databases? Steve Jones talks about some metrics and ways you can measure your usage to determine when it makes sense.
2012-05-22
112 reads
Continuous Releases
The idea of continuous development, integration and release can be a way to get your software in use by clients quicker. Steve Jones talks about releases, and some benefits you might get.
2012-05-21
159 reads
Password Handling
A system administrator can set a good example with the passwords they give to users or a bad example. Which one do you set?
2012-05-18
251 reads
Do Interviews Work?
Interviews are the way we primarily make hiring decisions but as Steve Jones notes, we don't really end up doing a very good job of picking good employees in many cases.
2012-05-17
326 reads
What is Big Data?
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
2012-05-16
745 reads
Self Service SQL
Self service in IT is something Steve Jones likes, but it doesn't solve all problems, and might end up creating more issues.
2012-05-15
237 reads
Is Software Engineering Dead?
Software engineering is seen as a dead end career choice, at least by some people. Steve Jones disagrees.
2012-05-14
434 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