Database Health and Performance at SQLSaturday Detroit
Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my...
2013-03-16
620 reads
Scaling SQL Server 2012 in Lisbon, Portugal
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
734 reads
Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,457 reads
Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
796 reads
Reblog: March 8 to March 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
717 reads
Successful BI for Educational Institutions
Do you work for US Education? Are you interested in Learning about Microsoft BI? If so, please join me as...
2013-03-15
1,272 reads
Exploring Excel 2013 for BI Tip #3: Flash Fill
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-15
1,175 reads
Self Hosting WCF Services With Transport Security
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
207 reads
Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,688 reads
The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
906 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
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...
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