New Years Aspirations – James Rowland-Jones – PASS
Thanks for agreeing to do this James; I know as you run your own company your time is billable!
Before we...
2013-01-17
1,533 reads
Richard Douglas
New Year Ambitions – Brent Ozar – Consulting
You are of course someone who needs little introduction in the SQL Server community. A prolific blogger, tweeter, speaker, Microsoft...
2013-01-16
1,880 reads
New Year Aspirations – Chris Webb – SQLBits
SQLBits holds a special place for me as it was the first technical conference that I had ever been to....
2013-01-15
933 reads
New Year Aspirations
Every year millions of people around the world decide to make new years resolutions. In these resolutions they promise themselves...
2013-01-14
655 reads
#SQLMaiden 2013 dates
Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...
2013-01-09
696 reads
Yesterday I was hacked
That’s right, for all my years in IT yesterday I was the victim of a vicious and deeply distressing incident....
2012-09-13
1,045 reads
As one door closes another one opens
Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...
2012-07-27 (first published: 2012-07-23)
2,520 reads
Cycling is good for you
It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...
2012-07-22
1,092 reads
Wish you were here
When I was growing up, we used to sit round the t.v. (families only had one in those days) and...
2012-03-21
758 reads
#SQLThursday is here
Struggling to source quality free content on SQL Server? Finding it difficult to fill the void between #TSQL2sDay and Un-SQL...
2012-01-17
411 reads
Blogs
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
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...
Forums
Basic Always On Groups Randomly Stop Synchronizing
In one of my environments I have 3 pairs of Always On SQL 2022...
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...
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