Why SQL Server security matters: A case study
Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...
2012-12-02
832 reads
XML Support and SQL Server
Checkout my article here, in which I discussed the fundamentals of XML technologies.
This article is published on SSWUG.org.
2012-12-02
640 reads
Planning for ETL solution
Checkout my article here, in which I talked about the basic steps that are requried to plan an successful ETL...
2012-12-02
715 reads
Katie and Emil come back
We are back on SQL Server Central... This is our first post after a while; also a test to see...
2012-12-02
745 reads
SQL Server Consulting Blog–Saturday Stats 1st Dec 2012
This post is little experiment I’m trying out this weekend. The SQL Server Consulting blog has been up and running...
2012-12-01
889 reads
PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."
Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded. The Managed Add-in Loader failed...
2012-11-30
6,446 reads
Speaking at SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza
I am pleased to announce that I am speaking Thursday, December 6, at the SQLPASS Performance Virtual Chapter Winter 2012...
2012-11-30
1,309 reads
Lost in Translation – Deprecated System Tables – sysprotects
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-30
1,827 reads
Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a...
2012-11-30
6 reads
Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a...
2012-11-30
15 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