Lots of links this week! Database Related Brad Schultz wrote a fun “blow your student’s mind” post on indexes Paul White’s excellent post on heaps, hash joins, and index design Buck Woody walks about support for multiple monitors in SSMS 2008 Microsoft SQL Server Migration Assistant for Access v4.2 Microsoft...
One word: Don't ####### even try or you will waste a half day to a full day. What a #*$&#&*#+ nightmare. I eventually got it up and running thanks to the following resources: http://blogs.msdn.com/b/bethmassi/archive/2009/12/02/setting-up-windows-7-for-office-sharepoint-2010-beta-development.aspx http://www.sharepointings.com/installing-sharepoint-2010-in-single-server-mode-on-windows-7/ http://blogs.msdn.com/b/sowmyancs/archive/2010/04/01/psconfig-error-at-step-2-microsoft-sharepoint-spexception-user-cannot-be-found.aspxhttp://myspexp.com/2010/05/31/configuration-failed-when-installing-sp-2010-on-windows-7-failed-big-time-3/ All in all I probably visited over 50 pages in four hours. I had...
Lots of links this week! Database Related Visio stencils for SSIS packages Red-Gate’s SQL Storage Compress 5.0 has just been released SQL Azure FAQ Demo of PivotViewer for SSRS Programming Related Visual Studio Database Guide Sysadmin Related New clustering utility – the Remote Desktop Connection Manager 2.0 Exchange Server Jetstress...
I was working on a PowerPivot application today for my PowerPivot training videos in my SSAS training videos and, for whatever reason, my internet connection happened to be down when I opened it up. Uh-oh – PowerPivot won’t work (by default) unless you are connected to the internet! tl;dr solution:...
I recently went looking for the SQL Server 2008 sample databases for the fictional Contoso company and was surprised to see that Google had trouble finding it. So here goes – this is for anyone else trying to find the Contoso sample databases for SQL Server 2008 R2, Reporting Services,...
A while back, I recorded almost 40 hours of TSQL videos and I wanted to list some of them here. I’m getting ready to add in my Transact-SQL Training Course for SQL Server 2008 R2 into the list of videos and wanted to get this out of the way! SQL...
Sheesh – talk about a break! I “accidentally” took eight months off from posting :) Database Related Auto-Parameterization in SQL Server Microsoft Assessment and Planning (MAP) Toolkit for SQL Server 2008 R2 List of SSIS 2008 Training Videos The “Big List” of Transact-SQL 2005 video tutorials from LearnItFirst Programming Related...
LearnItFirst.com has just released Scott Whigham’s latest course, SSAS 2008 Training Videos. This Analysis Services training course is over 200 videos and features the equivalent of about seven days of “live” instructor-led Analysis Services training. Check it out: Free SSAS videos SSAS video tutorials...
LearnItFirst.com hosts its IT training videos over at Rackspace and, due to unknown issues, the LearnItFirst site is unavailable due to Rackspace being down. 2009 hasn’t been the smoothest year for Rackspace – this makes the fourth big Rackspace outage of the year. June 29, 2009 – power failures at...
These are my bookmarks this week! Sorry there aren’t too many – it’s getting close to the holidays and this is my last one of the year. Have a great holiday season! Database Related Design of a Reporting System Vin@yard Programming Related Search Engine Optimization Toolkit from MSFT Sysadmin Related...
