Kubernetes is Cool, But ...
Steve has a few thoughts on Kubernetes and how much data professionals should care about the technology.
2024-05-20
227 reads
Steve has a few thoughts on Kubernetes and how much data professionals should care about the technology.
2024-05-20
227 reads
Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential.
2024-04-22
Learn about various PowerShell commands that can be used to administer virtual machines on Amazon AWS.
2023-12-04
Today Steve talks about bare metal servers and virtual machines. He wonders if any of you still run bare metal.
2023-07-10
362 reads
Mercedes has taken advantage of containers and Kubernetes to build knowledge in their staff. This investment helps them adapt and change their technology to meet the needs of the business.
2022-08-19
273 reads
Kubernetes production clusters are typically run on cloud platforms. However, running and deploying Kubernetes applications on cloud platforms such as Google Kubernetes Engine is costly. These high costs can restrict the Kubernetes learning process for beginners. However, running Kubernetes clusters locally helps you efficiently test applications without disrupting the production environment or paying for cloud services.
2022-06-22
2021-10-06
320 reads
In this article we look at some of the things you should be aware of when building a VM to run SQL Server, such as vCPUs, disks, memory and more.
2021-09-27
This short article explains how to quickly run SQL Server in a Docker container, for both Windows and Linux.
2021-08-13 (first published: 2021-08-11)
40,525 reads
2021-05-14
405 reads
If you spend your days tuning queries, managing pipelines, or keeping a production database...
I’ve been rebuilding my three-site SQL Server demo lab, and I ran into something...
By SQLPals
SQL Server gMSA: Why DBAs Still Aren't Using It in 2026 ...
Comments posted to this topic are about the item Never is Not the Policy
Comments posted to this topic are about the item Automating SSAS Multidimensional Security Audits...
Comments posted to this topic are about the item Rebuilding All Indexes
I have added a few indexes to one of my tables in SQL Server 2025:
ALTER TABLE dbo.CustomerContact
ADD CONSTRAINT PK_CustomerContact
PRIMARY KEY (CustomerID);
-- Create index on CustomerEmail
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (CustomerEmail);
CREATE INDEX IX_CustomerContact_CustomerEmail
ON dbo.CustomerContact (phone);
I then do this to disable one index:
alter index IX_CustomerContact_CustomerPhone on dbo.CustomerContact disableI see this when I check the index status:
I decide to rebuild all indexes with this command:
ALTER INDEX ALL ON dbo.CustomerContactAfter I do this, what will I see for the index status? See possible answers