Taking control of the ‘sa’ account for SQL Server 2012
As a DBA, it is perfectly normal to forget your password from time to time. No need to hold your breath...
2014-09-25
540 reads
Blog Posts
The BaCON Debacle, or Who’s Mike?
Who is Mike in the business intelligence/analytics world?
Is it Mike White? If it is, he’s the guy I call for...
2014-09-25
1,065 reads
Why Have a Nom Com?
I don’t want to get too deeply involved in the complaints and struggles of PASS, but I also want to...
2014-09-25
697 reads
#PASSVOTE 2014
Hello Dear Reader! The PASS Board of Director elections are upon us again. We have 3 spots open and 4...
2014-09-24
602 reads
Changing configuration settings with sp_configure
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that...
2014-09-24 (first published: 2014-09-22)
7,701 reads
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error
Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server...
2014-09-24 (first published: 2014-09-22)
6,469 reads
SQLSaturday Orlando Marketing Plan-Part 46
Registration count after some cancellations now at 577, way above my goal of 500. We’ve decided not to spend on...
2014-09-24
508 reads
Still time to get a SQL Server tattoo
Not for me, and perhaps not for you, but you can still encourage Jason Strate, Gareth Swanepoel, Ed Watson, and...
2014-09-24
855 reads
Thoughts on PASS Board Nomination Process: #passvotes
Having very recently gone through the nomination process for the PASS Board, I thought I would share a few things...
2014-09-24
495 reads
What I know about batch files
For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how...
2014-09-24
622 reads
Blogs
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...
Simple Talks Podcasting in 2026
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
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