How I Setup TempDB
How TempDB should be setup is a question that comes up a lot, mostly because there is a lot of bad information out there. So here’s how I typically setup TempDB for the bulk of my clients, and these settings will probably work for you as well. Number of Files The number of files that […]
Recommended reading from mrdenny for March 28, 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. Homeopathic remedies recalled for containing real medicine Gone Phishing ‘O’-Convertible In Three Years, Nearly 45% of All the Servers Will Ship To Cloud Providers Managed Order Management This weeks SQL Server person […]
Excel 2013 and Analysis Services 2000
So I got a strange question from a client the other day. Can I get Excel 2013 connected to Analysis Services 2000? Yes you read that correct, SSAS 2000. The answer is “it depends”. If you are using Excel 2013 x32 (the 32bit version) then yes you can connect to SQL Server Analysis Services 2000. […]
Recommended reading from mrdenny for March 21, 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. Surprise – Your Project is a Failure CLARiiON Data Erasure – DIY edition Mapping wait types in dm_os_wait_stats to Extended Events Virtualizing Exchange and Scaling Up No Spindles Bro This weeks SQL […]