Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2
Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup.
Creating Inferred Dimension Members with SSIS
This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.
How Do You Find a DBA?
Looking for a new DBA can be a daunting process, and a lot of work as the resumes flood in. Steve Jones talks about a better way that might work for some of you.
Reporting Services Performance and Optimization
This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.
Creating A SQL Server 2008\2008 R2 Failover Cluster
Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance
It’s About the Journey, Not the Exam
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
Terrifyingly Accurate Technology Predictions for 2014
The end of a year is a time for reflection, but it’s also a time for running full-pelt at the new year with some ill-thought-out predictions under ones belt. It’s with this in mind that I fire up my 100%-accurate Criswell-Brand crystal ball, and peer into next year’s world of technology.
Next-Level Parallel Plan Forcing: An Alternative to 8649
The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.
Infographics
Today Steve Jones has a poll that asks about the visualizations or infographics that you find to be most effective.
Recognizing community leaders
Voting is open for the Tribal Awards finalists. Choose which community warriors you think went above and beyond the call of duty with their blog, presentation, advice, user group, and more.
Blogs
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...
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...
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