March 2013 – Monthly SQL Server Checklist
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
820 reads
Last Weeks Top 10 “Reading” Links #22
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
596 reads
Pro SQL Server 2012 Practices: Chapter 17
I jumped at the opportunity to write a chapter for this book, Pro SQL Server 2012 Practices, because of all...
2013-03-04
1,702 reads
Notes from SQLSaturday #192
This past weekend I was back in Tampa for the sixth annual SQLSaturday. It’s a trip I always look forward...
2013-03-04
658 reads
Trust in Access
One of the minor features/quirks/annoyances of MS Access is that if you create a single macro or code module you...
2013-03-04
684 reads
What is mssqlsystemresource?
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
1,010 reads
Using Object Typed Variables in SSIS
Note: This will be the first post in a short series on using Object typed variables in SQL Server Integration...
2013-03-04
1,672 reads
Making sure your Triggers fire when they should
As some of you may be aware, triggers are not my favourite thing in the world but like most things,...
2013-03-04
1,080 reads
SQL Server – How to Rename Table/Column in SQL Server
To rename an object in SQL Server you can use sp_rename system stored procedure or you can do this via...
2013-03-04
2,030 reads
Virtualising your SQL Server?
Having just completed the latest revision of Learning Tree's SQL Server Virtualisation and consolidation course I thought I'd share with...
2013-03-04
675 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