What Counts for a DBA: Patience
Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.
2013-09-02
140 reads
Editorial
Stunned
The comment from one person has Steve Jones stunned today. He discusses the value of diversity and what we can do in the community.
2013-08-28
1,099 reads
Lost in the Noise
Can a honeypot provide you with more security? It's an interesting idea from Steve Jones today that might help you detect, and respond, to security events.
2013-08-27
139 reads
The Third Evolution
Steve Ballmer is retiring in the next year and Microsoft needs to find a new CEO. Steve Jones has a few thoughts.
2013-08-26
109 reads
Physical Security
The physical security of our systems might be a bigger problem in the future as more and more hackers are finding ways into secure areas.
2013-08-26
157 reads
Cool Projects
This week Steve Jones wants to know what type of really interesting projects you are working on. Is there something you really enjoy and look forward to building?
2017-07-14 (first published: 2013-08-23)
253 reads
The Costs of Data
Information is free, but data certainly has a cost. Especially as there are real costs to storing and managing large volumes of bits and bytes.
2013-08-22
122 reads
Always Abstract
When developing your code, should you use views? There are reasons why you might choose to do so, or not do so, however Steve Jones thinks you should consider abstracting your systems.
2013-08-21
160 reads
Guidance
When you are looking to help someone improve performance on a system, there isn't a single set of steps you provide. The advice and guidance you provide will vary, depending on the situation.
2013-08-20
111 reads
Opinions and Votes
When we look to improve software, we are often expressing our opinion on which items need to be handled first. It's helpful to keep in mind that it's an opinion being expressed, and not a vote, no matter how much it is solicited by a company.
2017-08-17 (first published: 2013-08-19)
129 reads
Blogs
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
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...
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