Right sizing your virtual machine for maximum database performance
I have a new blog post up at HouseOfBrick.com on why you should understand your workload performance characteristics. When you...
2013-02-11
941 reads
Blog Posts
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,349 reads
SQL Agent Alert System Error: [264] An attempt was made to send an email when no email session has been established
Today, I received an email from the development team complaining why they have not received any of the SQL Agent...
2013-02-11
4,502 reads
SQL Saturday #183 Albuquerque – Wrap Up
This past weekend was the first SQL Saturday in New Mexico. I had written about our trip down last week,...
2013-02-11
1,073 reads
SSIS Webinar Satisfaction Score
Our first free SSIS Webinar is over and the overall satisfaction score we got was 9.2 out of 10 so...
2013-02-11
1,016 reads
XML Support and SQL Server (Part 3)
Checkout the third part of my XML support and SQL Server article series here.
In this part, I talked about the...
2013-02-11
692 reads
Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores
My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest...
2013-02-10
1,300 reads
Day 26 of 31 Days of Disaster Recovery: The Mysterious Case of the Long Backup
Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale...
2013-02-10
1,125 reads
SQLSoldier World Tour Kicks Off in 1 Week
The SQLSoldier World Tour kicks off this next Friday when I head up to Vancouver, in British Columbia, Canada. I...
2013-02-10
1,098 reads
A Month of PowerShell – Day 9 (Getting Started with SMO)
Welcome to Day 9 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-09
6,058 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers