What's a Passive Server?
Today Steve Jones talks about licensing and the complexity if brings in various scenarios. Do your passive servers have to be licensed? What is the definition of "passive"?
2011-02-01
250 reads
Editorial
It's Almost Always the Humans
Today we have a reprint of an editorial from Sept 19, 2005 as Steve Jones is on vacation. In this one, Steve Jones reminds companies that saving money sometimes on Customer Service isn't as easy as you think.
2011-01-31
116 reads
A Great Deal of Hot Air
Even though neither the science nor politics of climate change is fully established yet, the legislators and bureaucrats have smelt an opportunity to further tighten their grip on IT. A sign of things to come is the EU’s Code of Conduct for Data Centers on Energy Efficiency.
2011-01-31
101 reads
Does It Count?
This Friday Steve Jones asks how you track uptime. Does your scheduled maintenance count against your metrics?
2015-06-19 (first published: 2011-01-28)
187 reads
Master Training
Steve Jones talks about the value of deep training. He is aiming to get some from SQLskills this year as part of their MCM training series, even without trying to pass the certification.
2011-01-27
167 reads
What Not To Say
Steve Jones has some advice for data professionals today. These are a few things that your boss doesn't want to hear, and you probably don't want to say.
2015-06-03 (first published: 2011-01-26)
703 reads
Sharing Code
Most people blog to share something they've done, and hopefully with the idea that someone else will learn and benefit from it. Steve Jones is happy to share code, but not everyone seems to be in agreement. In any case, you ought to respect the author's wishes.
2015-12-29 (first published: 2011-01-25)
322 reads
Is hyper-threading still relevant for SQL Server?
There still seems to be a lot of fear, uncertainty and doubt, in the community, with regard to use of Hyper-threading (HT) with SQL Server workloads. So, how and when should it be used?
2011-01-24
802 reads
Help Us Help You
SQLServerCentral has a new place for discussions and Steve Jones hopes you use it. It's a forum built for critiquing and discussion the presentations that the SQL Server community shares with each other.
2011-01-24
85 reads
Changing the Past
This Friday Steve Jones explores archived data. Can you restate past results or change old data? This week Steve Jones asks how data professionals feel about this and what guidance they give to their customers.
2011-01-21
128 reads
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
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.
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
exec etl.GettheProduct
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