Hunting in Packs
Waterfall is the practice most destructive to developer productivity? Nonsense, according to Phil Factor. Lack of basic team coordination skills comes much higher in the list.
2016-04-11
119 reads
Editorial
How Much Can You Learn?
This Friday Steve Jones wonders about the upper limits for what you may learn in a year.
2025-09-01 (first published: 2016-04-08)
253 reads
Naming Is Hard
Naming objects and variables in software can create contention in a team. While there are good conventions and standards, ultimately a team just needs to agree on something.
2016-04-07
130 reads
Would You Move For a Job?
Today we have a guest editorial from Andy Warren as Steve is on vacation. Would any job be enough for you to uproot your life?
2020-09-18 (first published: 2016-04-04)
243 reads
Code smells versus transgressions
The oddest SQL practices can be done deliberately for good reason, but are there any that are always wrong, that are so bad that that their use should be prohibited as a matter of policy?
2016-04-04
153 reads
2016-04-01
122 reads
The Database Transaction Unit (DTU) Decoded
In an Azure SQL Database, you pay for a certain number of DTUs, but what are these? Steve Jones explains.
2016-04-01
2,681 reads
Is PowerShell Intimidating?
Today we have a guest editorial from Andy Warren that asks if the rest of you are intimidated by PowerShell.
2016-03-30
184 reads
Examining SQL Server 2016
Today Steve Jones wonders if any of you are looking at the next version of our platform, SQL Server 2016.
2016-03-31 (first published: 2016-03-29)
283 reads
Track Your Consultants
It's possible to perform a man-in-the-middle attack against SQL Server. Steve Jones notes you should be aware these attacks could take place inside of your network.
2016-03-29
86 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;