Walk on the Wild Side
Today Steve Jones talks about the differences between development and production and how it can be good to spend a little doing the other type of work.
2012-10-23
116 reads
Editorials
2012-10-22
85 reads
Unprofessional Employers
This Friday Steve Jones talks about training and employers, and who has the responsibility for your knowledge? Let us know if you think your employer shares the burden with you.
2012-10-19
329 reads
Windows Server 2012 and Hyper-V
Steve Jones talks about the improvements in Hyper-V in Windows Server 2012. These days there isn't a good reason to avoid considering virtualization for SQL Servers.
2012-10-18
274 reads
Manage By Delegation
There always seem to be more and more instances to manage, but not more and more staff. Steve Jones talks about the key to good management being delegation of the work.
2012-10-17
147 reads
I'm Not a Rock Star
Steve Jones reflects on the SQL in the City tour that recently wrapped up in the US.
2012-10-16
151 reads
Innovation
This Friday Steve Jones wants to know if innovation matters in your company. And if you really enjoy working with computers and solving problems.
2012-10-12
251 reads
Potential
We often view potential hires based on their potential and not necessarily on their experience. Today Steve Jones talks about the dangers of putting more emphasis on future, rather than past, performance.
2012-10-10
128 reads
Why SQL Server is Better Than Oracle
WARNING: This editorial contains graphic language. Viewer discretion is advised.
2012-10-09 (first published: 2007-10-04)
1,603 reads
Software is Like Building a House
One of the really classic analogies in software is that it's like building a house. You have a foundation, multiple teams, lots of contractors that specialize in something, etc. And it's an analogy that's debated as to its relevance over and over. I won't go into the correctness of this analogy, but I wanted to comment on it.
2012-10-08 (first published: 2007-10-05)
360 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