Growing and Changing
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
2019-08-26
177 reads
It can be hard to let go of old knowledge and try something new, but we need to find a balance.
2019-08-26
177 reads
2019-08-20
429 reads
Learning to become a DBA is often a winding and twisty road. Steve has a little advice today.
2019-08-13
248 reads
In this weeks Simple Talk editorial Kathi Kellenberger discusses how to measure the performance of a development team and why you should always make sure you are measuring the right thing, not just the easy thing.
2019-08-12
Steve wants to know what's in your current home lab. Leave a note and help others learn to set one up.
2019-08-09
603 reads
Every year, July 1 is the Microsoft MVP Renewal date and quite a few people received good news that day. I was one of those renewed for another year, and I am honored that Microsoft chose me again. I also congratulate all the others that received the award for the first time as well as […]
2019-07-29
274 reads
There is a hero complex for many in IT. Steve provides some advice in how we should look at our workload and our employer's expectations when we consider a new job.
2019-07-11
1,104 reads
Using a VCS is a core skill, according to Steve. One part of that is learning to write better commit messages.
2019-07-08
466 reads
Today Steve talks about the soft skills and why these might be important as you advance in your career and grow into a senior role.
2019-07-02
525 reads
There is quite a bit of suffering within tech and caused by tech, from poorly commented code to shaming someone who asks a question on a forum. In this article, Samuel Nitsche explains why compassionate coding is a better way to go.
2019-06-27
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)If you run SQL Server...
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Be Wary of Data
Comments posted to this topic are about the item 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;