SQL Connections Slow on Windows 8 and Excel

Named Pipes.  That’s the Jeopardy answer to a question that took 3Deers a month or so to answer regarding a sever slowdown in the queries from Microsoft Excel to a SQL database.  Named (freaking) Pipes. For folks that use Excel to access SQL and do great Business Intelligence Reports (like … Continue reading

Excel For Business Intelligence – SQL Presentation

July 13 was a great day at the IT Pro Camp hosted by Keiser University in Ft. Lauderdale (http://itprocamp.com/southflorida/south-florida-it-pro-camp/).  I was honored to represent 3Deers and do a presentation on utilizing Microsoft Excel as a front end tool for Business Intelligence. Many people do not realize that you can use … Continue reading