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,525 reads
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
406 reads
Inside My PASS Summit
As you read this, I’m in Seattle for the PASS Summit 2017. I have four roles that I satisfy at...
2017-10-30
587 reads
DevOps Basics – Ignoring Files in Git
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-30
1,519 reads
Quick Model Database Tidbit
Are you using your Model Database to its full potential?
I am finding more and more that Database Admins are not...
2017-10-30
748 reads
Haunted SQL: The ghost of Management Studio
Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results?...
2017-10-30
678 reads
What’s that SSIS Password
From time to time it is necessary to find a way into an SSIS package that is password protected. This article will help you find your way in to...
2017-10-30
52 reads
What’s that SSIS Password
A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that...
2017-10-30
1,366 reads
It’s All About The Joins
One of the most common mistakes I see made when creating tables (and I’ve been guilty of this myself too...
2017-10-29
541 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
720 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers