Recommended reading from mrdenny for April 04, 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. First Week As The DBA Whitepaper Published Beware the ß Waiting, waiting… Great Advice (and Free!): DBA JumpStart SQL Server 2012 Diagnostic Information Queries (December 2013) This weeks SQL Server person to […]
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. […]