Here’s a dump of last week’s links and then it’s back to recording my new 2008 Integration Services video tutorials! I had a ton of links this week and, since this past week featured the public launch of Windows 7, many of my links are related: Database Related Stop Calling...
Small group of links today… Database Related Performance consideration when using a Table Variable RML Utilities for SQL Server Another row concatenation example We Loaded 1TB in 30 Minutes with SSIS, and So Can You Programming Related Microsoft names Visual Studio 2010 dates Sysadmin Related Windows 7 Resource Kit PowerShell...
I received an email from LearnItFirst user, Armand, today asking about Windows Server training on using VPNs and Windows Server: If you have a training video(s) on how to access a NAT'ed Windows server via a VPN solution (via Cisco or any 3rd party tunneling tool), that'll be greatly appreciated....
Today I received an email from one of the LearnItFirst.com users, Donny, who had recently viewed my Windows Server 2008 training videos and had a follow-up question. After watching the Windows 2008 video course, I have learned that Grant suggests 2 hard drives for a basic server, 1 for the...
SSIS has its quirks, no doubt, but one of the more frustrating things that I’ve seen newbies struggle with in class is how to troubleshoot the various validation and conversion errors and warnings in Data Flow Tasks. Do these look familiar? Of course these look familiar – you see...
Database Related How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Rebuilding Indexes vs. Updating Statistics Things you might not know about SSIS Precedence Constraints No more support for SQL Server 2005 SP2 and SQL Server 2008 RTM Programming Related Visual Studio Open Source...
I just finished my first ebook for LearnItFirst: How to Become a C# Programmer, which you can get for free here. This free ebook download requires no registration and is in PDF format. This book is my first in a new series: “How to Become a ___________”. This series is...
Quick dump and then it’s back to recording my new 2008 Integration Services training videos! Database Related Top 5 Free SQL Server Tools Using a Managed Service Account for SQL Server in Windows 7 Keep track of all SQL Server hotfixes and service packs SQLSTAT2005 – a data collection/warehouse using...
Quick dump and then it's back to recording my new 2008 Integration Services training videos! Database Related Glossary of Data Quality terms - hint: if you are an SSIS junkie, you need to know many of these New Cumulative Updates (CUs) now available for SQL 2008 Free SQL Server tools...
I had trouble just picking a few this week - I still have a backlog of 100+ links plus this week I added another 30+! Database Related How can SQL Server help my evaluate and manage indexes? - lots of great DMVs for monitoring index usage stats How to update...
