Review Your Indexing
Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.
2012-11-26
311 reads
Editorial
Password Insecurities
Tony Davis argues that the Standards and best practices exist to avoid being hacked, but implementing them requires time and investment and often there simply doesn't seem to be the will to do it.
2012-11-26
117 reads
The SQL Server Pro Awards
Phil Factor is pleasantly surprised by the SQL Server Pro awards, and talks about the thinking behind Down Tools Week.
2012-11-23
173 reads
2012-11-22
156 reads
The Small Print
In today's guest editorial, Phil Factor issues a stark warning against cunning salesmen and hidden costs in cloud computing.
2012-11-21
127 reads
A Tool for the Job
Phil Factor is puzzled by reading how difficult a relatrional database is to use for certain tasks.
2012-11-20
204 reads
SSD Lifetimes
This week Steve Jones looks at the expected lifetimes of SSDs and finds one that might be a nice upgrade for your system.
2012-11-19
257 reads
The Cost of Storage
As DBAs we constantly need more storage, but do we know what the impact or cost of this storage is to our employers? Answer this week's poll.
2012-11-16
139 reads
Failure Lessons
Steve Jones would like to see more disclosure about what works and doesn't work when deploying new systems and software.
2012-11-15
128 reads
The Future of DBAs
What's the future for DBAs with cloud services and computing? Steve Jones talks about what might be coming soon.
2012-11-14
348 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
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