Data Security Policies
Does your organization have policies around data security? Perhaps they should, or perhaps you should ask for some to be created and education available for users.
2017-12-21 (first published: 2014-04-07)
157 reads
Editorial
Short Stroking and Performance
Disk performance can make a difference to your SQL Server instance. Steve Jones discusses a few things this week.
2014-04-07
166 reads
Team Reputation
The way that various departments might view a team of technology employees can affect how we interact. Andy Warren remembers a few situations and notes it's always more fun to join a team with a good reputation.
2014-04-04
167 reads
The Internet of Things
Today Steve Jones notes that the explosion of cheap hardware and electronics might be good for data professionals.
2014-04-03
136 reads
2014-04-02
1,069 reads
Telepresence
Today Steve Jones notes that an advance in technology will help change the way he works.
2014-04-01
109 reads
IT Skills Shortage? No, Just Looking in the wrong place
In which Phil ruminates on the ridiculous idea that we in the West suffer from an IT skills shortage. In truth we have a very blinkered idea of the sort of person who would succeed in an IT Development role
2014-03-31
221 reads
X in Technology
Steve Jones talks about the women in technology, and other efforts to help minorities.
2014-03-31
135 reads
The Perfect Environment
All our environments for SQL Server are different, but Andy Warren wonders if each of us might have a "perfect environment." Would things be standardized to make administration consistent? Or perhaps flexible to allow each instance to be tailored to its own needs.
2014-03-28
171 reads
Getting Fired
When should a DBA get fired? Steve Jones thinks it should be rare and gives you two cases.
2025-10-06 (first published: 2014-03-27)
705 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