Phil Factor on the rewards of learning the zen-like skill of writing, reading and understanding IT documentation.
Identifying a need for better collaboration between teams is only the first step to introducing DevOps workflows into your organization. You also need to define a common DevOps goal,...
Today we have a guest editorial from Andy Warren that talks about auditing your organization.
Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
This time we will work with the sqlcmd to handle our Azure SQL Data Warehouse
Steve Jones says you should treat your database servers like cattle. It makes life easier.
If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
i have sqlexpress on rds, is there any way i can get notifacation that...
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers