SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
1,215 reads
Blog Posts
Could not Register Service Principal Name
Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of...
2015-12-29 (first published: 2015-12-17)
1,575 reads
Happy Holidays
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
793 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
494 reads
Slow Running Query? Where do I Begin?
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
1,818 reads
Tabular Models, Multiple Data Sources and Unknown Members
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from...
2015-12-29
1,061 reads
Thanks Paul!
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this year Paul Randal ( b | t ), in...
2015-12-29
9 reads
Thanks Paul!
What I’ve noticed this year is that there’s really not another group of people like the SQL Community. Earlier this...
2015-12-29
890 reads
Using a Variable to Populate the Query in a Lookup in SSIS
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
844 reads
Why use a data lake?
Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch...
2015-12-29
3,344 reads
Blogs
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...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
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