IDEs sweet but beguiling
IDEs are wonderful, but tend to lull you out of the good habits of thinking up front about how the code you write will be monitored and tested. So argues Phil Factor.
2016-02-29
79 reads
Editorial
The Dangers of Algorithms
How we implement algorithms can change the way the world works with our software. Steve Jones wonders if we should be disclosing the algorithms themselves.
2016-02-29
154 reads
2016-02-26
136 reads
2016-02-25
154 reads
2016-02-23
142 reads
2016-02-22
119 reads
2016-02-22
336 reads
Lessons from Little Green Army Men
Today we have a guest editorial from Andy Warren that looks at digging deeper into stereotypes and deeper learning.
2020-07-03 (first published: 2016-02-19)
222 reads
Why Log Shipping is still a viable solution in 2016
An explanation as to what Log Shipping is and why it's still a viable solution in 2016.
2016-02-18
559 reads
Forcing Strong Passwords
Passwords are always a challenge, but are bad passwords the users' fault? Steve Jones has a few thoughts.
2016-02-17
102 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;