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,297 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,477 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,175 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
972 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,520 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
773 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
693 reads
Using Memory Optimized tables for reporting
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,308 reads
Survey Results: Skipping the Holidays
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
388 reads
Query Data Store–SQL Server 2016
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to...
2016-12-27
607 reads
Blogs
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers