A New Year, A New Company and A New DenverSQL Chapter
2016 was a great year, both personally and professionally. Personally, our family is well and the kids are growing into...
2017-01-30
644 reads
Blog Posts
Altering Data Length of a Primary Key Column
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
954 reads
Azure quick start
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
685 reads
Creating a connect entry.
I recently wrote a blog about how to tell why your SQL login isn’t working. There were a lot of...
2017-01-30 (first published: 2017-01-23)
1,126 reads
Enabling Remote Access to the Dedicated Admin Connection
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
3,071 reads
Monday Coffee 2017-01-30
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday...
2017-01-30
577 reads
Parse Dynamics AX Context Info
In this article I will only be discussing the AX product and an easy tweak to make troubleshooting that product much easier from the perspective of the database administrator....
2017-01-30
23 reads
Parse Dynamics AX Context Info
Dynamics AX and SQL Server
More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of...
2017-01-30
2,129 reads
Transaction log shipping in SQL Server on Linux
SQL Server on Linux has been out for a bit now and I’ve played around a little (see here) but...
2017-01-30 (first published: 2017-01-25)
2,127 reads
Warning: Not a valid checkpoint file name
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,882 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers