It began with an error thrown by a linked server. The linked server is on our warehouse server and connects to our SSIS server using the “login’s current security...
2021-12-03 (first published: 2021-11-23)
1,323 reads
I’ve been involved in building a solution on top of SQL Server peer to peer replication (SQL 2014 SP1) and...
2016-03-17 (first published: 2016-03-15)
4,319 reads
After a data centre power outage a decision was made to switch the start up mode of a bunch of...
2015-06-19 (first published: 2015-06-11)
1,869 reads
A colleague of mine discovered an interesting behaviour change from SQL Server 2012 to SQL Server 2014. We recently upgraded...
2015-06-02 (first published: 2015-05-21)
2,954 reads
When I first began this blog, back at the beginning of my DBA career, it was purely a place for...
2015-02-03
648 reads
The page came at a reasonable hour. All of the overnight ETL and processing jobs were just winding up before...
2015-01-21 (first published: 2015-01-15)
9,322 reads
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server.
If you don’t...
2014-11-06
1,175 reads
What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish...
2014-10-21 (first published: 2014-10-15)
8,026 reads
The Situation: I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to...
2014-10-15 (first published: 2014-10-07)
6,112 reads
Once upon a migration I would use sp_help_revlogin to migrate logins and remap the SQL server logins using sp_change_users_login. During...
2014-05-15 (first published: 2014-05-07)
8,240 reads
By Steve Jones
I was listening to the radio the other day and the hosts were discussing...
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
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...
Comments posted to this topic are about the item Learning From Breakage
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Comments posted to this topic are about the item 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