Jen McCown (blog|twitter) has organized a great topic for this unSQL Friday–lessons learned while presenting. Like she mentioned in her post–these don’t necessarily have to be tragedies, just things you’ve picked up along the way while presenting. Fortunately, in my few years of doing technical presentations, I’ve never had a major demo failure, or a […]
Here is my slide deck from SQL Rally–Deploying your Application to SQL Azure. http://slidesha.re/laEEnL I’ve put out a request to Microsoft on pricing for Azure Reporting Services, I’ll post here as soon as I find out.
Tomorrow I will be speaking at SQL Rally (Thursday 9:40 AM), on Deploying your Applications to the Cloud. I’ll talk a little bit about SQL Azure, and then discuss how you can use to it to benefit your business, how not to use it, and the finally what you need to do to connect to […]
This post originated one night when John Sterrett (blog|twitter) was asking for a good place to find salary information. I was able to quickly refer him to O*Net, a government database of job descriptions, and extensive salary info based on IRS return data. I mentioned that it was one of the top five things I […]
Always use notifications on your backup jobs. Backup t-logs quite frequently.
Allan Hirt Pro SQL Server 2008 Failover Clustering Paul Randal—White Paper on HA Solutions in SQL 2008 Slipstreaming SQL Server Install Building a cluster from MS Also, in answer to the question–if you lose your private heartbeat network, in 2008 the cluster will revert to using the public network, so no outage will happen. If […]
I’m presenting at 10:15 AM Saturday, at SQL Saturday in Boston, on “Building Your First SQL Cluster”. I really love presenting this topic–if you want to learn about high availability and disaster recovery concepts, and how they apply to SQL Server.I will cover clustering concepts and hardware requirements. Additionally, I will go over who in […]
In my earlier post “Adding a New Disk to a SQL Cluster Instance“, I needed to clarify something based on a comment. Any drive that gets added to your cluster that is not a mount point, as in occupies a physical drive letter, needs to be dependent on the SQL Server service. I didn’t think […]
If you’re still on the fence about going to SQL Rally, and need more rationale for why you should go, then check out the GREAT schedule at the website. Below are the sessions I plan on attending when I’m not presenting my session—Using Data Tier Applications to Deploy Applications to SQL Azure (which I’ll discuss […]
Recently, we got a new SAN (yeah!!!), unfortunately, our SAN vendor’s migration utilities are priced at such a level, that there is no way we were going to use them. So we had to resort to manually moving the disks. Fortunately in this instance all of the directory names and data files were the same, […]