What Sarbanes-Oxley Won't Do
Today we have a reprint of an editorial from Dec 4, 2005 as Steve is on vacation.
2011-02-16
174 reads
Editorials
Data Quality
Today we have an editorial reprinted from Dec 12, 2005 as Steve is on vacation. Steve talks about the hassles of poor data quality and why it can hurt a business.
2011-02-15
264 reads
A Variety of Interpretations
This week was T-SQL Tuesday week, the brainchild of Adam Machanic, and hosted by Pat Wright. The theme of Automation produced some very interesting posts. Some of them might inspire you to change the way you tackle the solutions for a variety of problems.
2011-02-14
98 reads
Careful Blogging
Today we have a reprint of an editorial from Sept 22, 2005. In this one, Steve Jones reminds you that blogging is a public event and you want to be careful about what you write.
2011-02-14
113 reads
Most Work is Mundane
Today we have a guest editorial from Andy Warren. Work can seem mundane and tedious at times, and today Andy asks you you remain engaged when the work isn't exciting.
2011-02-11
215 reads
OldSQL
Support for SQL Server 2005 expires in April. Should you care? Steve Jones thinks it might not be a big deal for many people.
2011-02-10
344 reads
You Should Know
Are there things you should know? It seems that we quite often find that others in our profession don't understand the simple things we assume they do. Steve Jones talks about one item in particular: staging servers.
2011-02-09
305 reads
Life Without Keyboards
The way we input data is changing with the advent of the iPad and tablets. Is that good or bad for the acquisition of data? Steve Jones has a few thoughts today.
2011-02-08
183 reads
I lied, now what?
What do you do if you've lied to get a job and now are in a bad position? Steve Jones offers his advice today.
2011-02-07
578 reads
Let the optimizer drive
For many, there is something disconcerting in the idea of the Query Optimizer; they crave control, but it really is best to take a back seat and let the Optimizer do its job.
2011-02-07
198 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