The Ten Commandments for DBAs
What should a good DBA do? Steve Jones came across a list he likes that showcases those things that should guide your efforts on a daily basis.
2014-09-15
406 reads
Editorial
The DBA Team Wants You!
There's a new contest going on, giving you the chance to win some software, SQL training, and a vacation, all at once.
2014-09-11
174 reads
Prepping for 2015
Steve Jones looks ahead at the new year and how you might want to begin shaping your career.
2014-09-10
187 reads
Estimates
Software estimates are often wildly off from the actual amount of time and resources that are required. Today Steve Jones looks at a few reasons why.
2014-09-09
196 reads
Misconfiguration is a Problem
The configuration of server systems matters. Not just to ensure software runs smoothly, but also for security.
2014-09-08
85 reads
2014-09-08
362 reads
Titles Matter – Part 2
In a followup to his previous piece, Andy Warren looks at job titles again and they can affect the people he works with.
2014-09-05
189 reads
2014-09-02
254 reads
2014-09-01
75 reads
On the importance of a complete break
If you’re the type who habitually checks work email and thinks about work while on holiday, here’s Gail Shaw's challenge for next time: don’t.
2014-09-01
176 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