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...
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...
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...
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”!...
