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
253 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
118 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
103 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)
193 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
174 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)
708 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)
325 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
86 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
811 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
133 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers