Database Doing DevOps
DevOps. It’s one of the latest buzz words in many technical communities. Database Doing DevOps This phrase, however, is NOT...
2018-03-30
456 reads
John Morehouse | Sqlrus.com
Community
Community.
In the SQL Server community, we are basically one big #sqlfamily. This is a story of how the family helped...
2018-03-23
386 reads
SSMS Output Window
In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time....
2018-03-16
782 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-12 (first published: 2018-03-02)
5,103 reads
Using SWITCH On A Single Partition
Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding...
2018-03-02
155 reads
Finding Composite Primary Key Columns
You never know when the idea for a script will make an appearance.
I had to work with composite primary keys...
2018-03-08 (first published: 2018-02-23)
3,572 reads
Backup & Restore Script with a Move
Ok, I’ll admit it. I like scripts that are handy and do things. Especially if the scripts make my life...
2018-03-01 (first published: 2018-02-16)
2,339 reads
4 Rules of Right When Running a Query
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by...
2018-02-21 (first published: 2018-02-09)
3,122 reads
4 Rules of Right When Running a Query
Last month in January, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by...
2018-02-09
132 reads
Trello – Integrations
In December I wrote about working from home in which I talked about Trello. Trello is a virtual kanban board...
2018-02-02
442 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