Bare Metal
Today Steve talks about bare metal servers and virtual machines. He wonders if any of you still run bare metal.
Get the Most Current Row From a Detail Table
This article compares the performance of finding the most recent row in a child table for updates, looking at four possible solutions.
Enterprises that adopt Database DevOps save an average of $4.3M per year (Video)
If treated well, the database can be a major accelerator in your business’s efficiency. It can be the star performer in your migration to the cloud, in your move to micro services and other change initiatives. Find out how the database can be the hero in your digital transformation or change initiative.
Influencing Successful Cloud Transformational Change
By developing a strong business case, building key relationships, using budgeting and forecasting tools, and providing training and support, tech leaders can effectively sell the benefits of the cloud and influence change.
The Data Professional Social Graph
Two weeks ago, I had the opportunity to hear a keynote by Vik Fearing at Swiss PGDay 2023. He talked about Property Graphs and the Graph Query Language (not to be confused with GraphQL), a recent addition to the SQL:2023 standard. The discussion was mostly theoretical in nature because only Oracle has a current implementation […]
Creating an Azure SQL Database Using Azure Cloud Shell
This article will show how to use the Azure Cloud Shell and PowerShell to set up a new Azure SQL Database.
Starter Metadata T-SQL Query Examples for Databases and Tables
SQL Server provides lots of information about various aspects of server and database objects and this data is referred to as metadata. Understanding what is available and how to use this metadata can greatly enhance and streamline how you can work with SQL Server.
Storing Credentials Securely on a Windows-based Flyway Installation
This article demonstrates how to use PowerShell to fetch your login credentials from Windows Credential Manager and pipe them securely to Flyway without ever saving them in any form, such as in a file or environment variable.
Fitting Into RAM
Will your database fit into RAM? Steve Jones asks you to think about the possibility.
Blogs
Who’s the Winningest Coach (with AI Help)
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
Learning from Mistakes: T-SQL Tuesday #194
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
Stupid Things I Did With AI: ASCII Art
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
Forums
Learning From Breakage
Comments posted to this topic are about the item Learning From Breakage
Python in Action to Auto-Generate an Optimized PostgreSQL Index Strategy
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Adding and Dropping Columns I
Comments posted to this topic are about the item Adding and Dropping Columns I
Question of the Day
Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers