One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL Server to run on ARM devices which will expand the range...
2020-04-22
5,407 reads
One of the coolest new projects out there is Azure SQL Database Edge: – https://azure.microsoft.com/en-us/services/sql-database-edge/ This allows SQL to run on ARM devices, just think how many devices are...
2020-04-22
234 reads
With all the events that have been cancelled over the next few months due to the on-going COVID-19 crisis, Mark Wilkinson (b|t), Anthony Nocentino (b|t), and I wanted to...
2020-04-22 (first published: 2020-04-15)
273 reads
One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up...
2020-04-17 (first published: 2020-04-08)
391 reads
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing threat of COVID-19. As much as we wanted to put this event on, the safety...
2020-04-03
8 reads
I’ve been working remotely for just over 2 years now and my current position is my first remote post. Before joining my current company I (and them) had concerns...
2020-03-11
12 reads
When working with multiple Kubernetes clusters, at some point you’ll want to merge your kubectl config files. I’ve seen a few blogs on how to merge kubectl config files...
2020-02-21
293 reads
Recently I’ve been delving into Chaos Engineering, reading books, watching videos, listening to podcasts etc. and I find it really intriguing….I mean, it just sounds exciting, right? CHAOS Engineering!...
2021-05-03 (first published: 2020-01-29)
313 reads
2019 was a busy year for me. I presented sessions in over 10 countries, averaging speaking at two conferences per month. I also helped organise Data Relay and attended...
2020-01-23
3 reads
At Data Céilí 2020 we want to be as green as possible and one idea we’ve had is to run a Green Track that will host remote sessions from...
2020-01-08
12 reads
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
I have a table with partition on create_timestamp field. Though we're storing all data...
Comments posted to this topic are about the item Adding and Dropping Columns II
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers