Easily Move Databases with Copy-SqlDatabase
One of the things that people have asked to be implemented for many years is an easy way to copy...
2016-12-29 (first published: 2016-12-09)
2,485 reads
Blog Posts
How we can determine table column dependencies within a SQL database?
I came a situation during some analysis where i had to figure out all dependency of a column across database....
2016-12-29
4,313 reads
Looking Back At 2016
When this blog started back in 2011 I had no idea that it would continue to grow to where it...
2016-12-29
688 reads
Analysis Services and Power BI: Time-travel, Space-warping and Teleportation
As I visit businesses, consulting clients and training classes, to teach data reporting and analytics; there is a recurring conversation. ...
2016-12-28 (first published: 2016-12-10)
1,566 reads
Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)
Continuation from the previous 92 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Given that currently the Batch Execution Mode...
2016-12-28
975 reads
DBA Resolutions
It’s said that “promises are made to be broken”. Surely database administrators don’t fall in that category? It’s that time...
2016-12-28
713 reads
ETL Error Handling
In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should...
2016-12-28
775 reads
Post TDE–Getting Unencrypted Backups
I saw a question posted recently about someone that had disabled TDE and was still having issues restoring a backup....
2016-12-28
2,176 reads
sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,521 reads
Windows Virtual Accounts and SQL Server
How SQL Server uses Windows Virtual Accounts and local groups
Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows...
2016-12-28
2,492 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
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers