Lawsuits and Data Breaches
Steve Jones notes that a data breach resulted in a lawsuit. How long before that's a common practice, and should we be preparing as data professionals.
2014-02-25
134 reads
Editorial
2014-02-24
102 reads
Auditing Matters
We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.
2014-02-24
166 reads
The SQLCLR Impact
Has the SQLCLR system impacted your SQL Server environment? Steve Jones wants to know if it has or has not today.
2014-02-21
215 reads
The Remote Balance
Telecommuting and remote work are growing in many fields, but especially technology. However the practice needs to be balanced with the notion that you still have a life outside of work.
2017-10-20 (first published: 2014-02-20)
195 reads
2014-02-19
821 reads
The Security of Interconnected Systems
We are interconnecting more and more computer systems and applications all the time. Security becomes a problem when one of these systems hasn't been properly configured, secured, or coded. Steve Jones notes this is becoming a real problem.
2014-02-18
132 reads
2014-02-17
177 reads
VMs for Development
Many technical people use Virtual Machines to build their own lab or test environment. Today Steve Jones asks how you've built your setup.
2017-12-22 (first published: 2014-02-14)
248 reads
What is Continuous Integration for Databases?
What is continuous integration for databases? Steve Jones gives a short explanation and information on why you might care about this.
2014-02-13
439 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
BCA KCP Duta Mas Fatmawati TLP:WA 08216366654
Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No.6, 7, Cipete...
BCA KCP Permata Hijau TLP/WA 08216977701
Pertokoan, Jl. Permata Hijau Blok D No. C27-28 dan B22, RT.4/RW.12, Grogol Utara, Kec....
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
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