Can’t Connect to Analysis Services – Invalid Connection Information
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried...
2017-10-30
1,521 reads
Koen Verbeeck
Error Installing SQL Server 2017
A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for...
2017-10-20
5,581 reads
dataMinds Connect 2017 – And The Winner Is?
Last week I had the privilege to host a little contest to give away one free ticket to dataMinds Connect...
2017-09-25
405 reads
dataMinds Connect 2017 (win a ticket!)
Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...
2017-09-18
327 reads
Error Processing Tabular – Method Not Found
Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...
2017-09-15
376 reads
CALCULATE and FILTER: A Love Story?
There have already been many posts/articles/books written about the subject of how CALCULATE and FILTER works, so I’m not going...
2017-09-13 (first published: 2017-09-06)
2,006 reads
The Wait Is Over – SSIS 2017 Is Here!
UPDATE: recent builds of SSDT for VS 2017 can break TFS integration. Read more about it in the blog post...
2017-08-23
1,124 reads
Fix for Blurry SSMS in Windows 10
I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a...
2017-08-14
7,517 reads
Two Small Tips for Working with Azure
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up...
2017-08-10
499 reads
SSIS – Error while deploying package The locale identifier (LCID) is not supported by SQL Server
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local...
2017-08-08
3,508 reads
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
How Do I Choose the Best Bike Transport Service in Gurgaon?
Choosing the best Bike Transport Service in Gurgaon requires careful comparison and user discussion....
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
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