Turn Out the Lights
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
2019-09-06 (first published: 2016-01-18)
400 reads
Editorial
Security Convenience
Security is always a hot topic, and Steve Jones notes that we should be specific when we work with security.
2016-01-15
131 reads
Tracking Professional Athletes
Today Steve Jones looks at the use of tracking sensors to gather spatial data on professional athletes for later analysis.
2016-01-14
91 reads
The Ongoing Costs of Building Software
There are lots of costs to building your own software, which Steve Jones notes might not be what you want to spend over time.
2019-09-05 (first published: 2016-01-13)
309 reads
2016-01-12
144 reads
2016-01-11
176 reads
2016-01-11
253 reads
2016-01-08
115 reads
2016-01-07
248 reads
Hacking to Hide
People have hacked the voyage data recorders in ships. Steve Jones thinks this is a fundamental problem in computing systems.
2016-01-05
169 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Be Wary of Data
Comments posted to this topic are about the item Be Wary of Data
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;