Relational By Default
Should we consider the relational model the default and only after having a good reason look at a NoSQL platform? Steve Jones has a few comments.
2015-11-18
103 reads
Editorial
Private Data
The laws and morals regarding privacy aren't well defined, but Microsoft is making a stand.
2015-11-17
109 reads
Rogue Software Changes
Today Steve Jones wonders if software developers would make changes to software on their own, without direction from management.
2019-10-29 (first published: 2015-11-16)
305 reads
Mind your Database Ps and Qs
Louis Davidson explains why a little database courtesy goes a long way.
2015-11-16
223 reads
2019-11-04 (first published: 2015-11-13)
418 reads
2015-11-12
221 reads
Do You Have Scary Code?
Many organizations have code no one wants to touch. Steve Jones notes that's a bad place to be.
2015-11-10
250 reads
2015-11-09
226 reads
A big thank you
Grant Fritchey shows his softer side, extending his appreciation to all DBAs who work tirelessly to keep our software running in the face of adversity.
2015-11-09
690 reads
The Lost Laptop Crisis
Losing a laptop isn't something most of us would want to deal with, usually because of the expense. However, there may be other implications that concern you. Share your worries with us today.
2015-11-06
118 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;