ERRORLOG records max out at 2049 characters
Stupid question… what's the schema of a table with sys.sp_readerrorlog output? Well you might be surprised if you're used to...
2017-03-02
139 reads
SSDT Deploy / Publish Performance
Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
1,268 reads
SSDT Deploy / Publish Performance
Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take minutes to hours to deploy changes depending on how...
2017-03-01
12 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
14 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
39 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
42 reads
Azure Data Factory and SSIS compared
I see a lot of confusion when it comes to Azure Data Factory (ADF) and how it compares to SSIS....
2017-03-01
454 reads
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the big four zero.... 40. A little wiser? Maybe. Despite...
2017-03-01
9 reads
Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,233 reads
SQL Browser, what is it good for? Absolutely something!
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-09 (first published: 2017-03-01)
3,699 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