Recommended reading from mrdenny for April 18, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. TechEd Europe 2013 videos online Retail Stores Plan Elaborate Ways To Track You Buffer Pool Extension to SSDs in SQL Server 2014 The SQLAndy Rules for Storing Credit Card Numbers Interval Queries […]
Naming Drives
I’m a DBA (shocking I know), so I plan everything possible that I can to the servers that I’m setting up for clients. In this case that includes thinking about what’s going to happen when the server (or VM) totally fails and they need to rebuild the OS from scratch and get everything back up […]
Recommended reading from mrdenny for April 11, 2014
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. SQL Server 2014 In-Memory OLTP: Nonclustered Indexes for Memory-Optimized Tables The 411 on the Microsoft SQL Server 2014 In-Memory OLTP Blog Series Smart, Secure, Cost-Effective: SQL Server Back Up to Windows […]
Viewing Maintenance Plan Logs
For many of my customers I’ve got them setup to use maintenance plans because they are small shops without a DBA and the maintenance plans give them something visual which they can easily tweak later on if needed without having to have me come in to make a small change to their reindexing or backups, […]