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
693 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,505 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
Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy.
But Sometimes...
2013-02-11
1,850 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,022 reads
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
943 reads
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,350 reads
Last Weeks Top 10 “Reading” Links #19
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-11
469 reads
Introduction to Microsoft’s Master Data Services (MDS) Presentation
Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at...
2013-02-11
954 reads
A Month of PowerShell – Day 11 (SMO: Databases)
Welcome to Day 11 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-11
4,773 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers