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...
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...
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...
These are my bookmarks this week! Database Related Tuning options for SQL Server 2005 and SQL Server 2008 when running in high performance workloads Why Should You Convert Your Script Task into a Custom Task? PowerPivot Knowing the Relative Value of Databases SQL Server 2008 R2 gets an official due...
These are my bookmarks this week! Database Related Suggested Max Memory Settings for SQL Server 2005/2008 Donald Farmer’s SQLBits Keynote on Using PowerPivot What chart type should I use in my Reporting Services report? DTLoggedExec 0.2.3.0 beta published! Programming Related Visual Studio 2010 – a First Look An Introduction to...
Database Related SQL Server 2008 R2 New Features Efficient database queries in SQL SQL Server memory usage Entity-Attribute-Value (EAV) model SQL Server 2008 R2’s StreamInsight CTP download Playing Around with SQL Azure and SSMS Database Engine Tuning Advisor and the Query Optimizer Programming Related jQSlickWrap - Slick text wrapping for...
Went to a cabin in Oklahoma for part of last week and I didn’t think about tech too much so this week’s links are “light”! Database Related Database Mirroring Freak Show November CTP of SQL Server 2008 R2 New in SQL Server 2008 R2: Backup Compression no longer “Enterprise Only”!...
I have only a few bookmarks this week – I’ve been hard at work recording new SSIS 2008 training videos! Database Related TSQL script: Show upcoming jobs Statistics Used by the Query Optimizer in Microsoft SQL Server 2008 Microsoft to raise prices, add more high-end editions with SQL Server 2008...
