Four Things PASS gets Right
PASS has taken a lot of heat recently. A few folks have pointed out that you only seem to hear...
2014-09-29 (first published: 2014-09-24)
6,777 reads
Blog Posts
How to Make Sure Your Clients Can Connect to a Multi-Subnet Cluster
When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to...
2014-09-29
958 reads
Making Better Presentations–Organize Things
This is part of a series of tips for speakers on how to make your presentations better.
Organization matters, and it...
2014-09-29
1,386 reads
SQL Server 2008 R2 Service Pack 3 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for...
2014-09-29
1,248 reads
SQL Server 2008 R2 Service Pack 3 Is Now Available !
Finally after a long waiting period, Microsoft release SQL Server 2008 R2 Service Pack 3, Same is now available for download at the Microsoft Support site. SQL Server 2008...
2014-09-29
10 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server...
2014-09-29
23,779 reads
SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be
Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the...
2014-09-29
186 reads
SQLSaturday Orlando Marketing Plan–Part 48
This past Saturday we held our eight annual SQLSaturday. I’ll write some notes about the event and post today or...
2014-09-29
1,007 reads
SQLServer 2008 R2 SP3 released, Now its testing and deployment time!
As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and...
2014-09-29
1,437 reads
What PASS is to me #sqlpass
I found out about the Professional Association for SQL Server (PASS) in 2008 when I attended my first PASS Community Summit “SQL...
2014-09-29
1,631 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