Links You Should’ve Clicked Last Week – October 19, 2009
- by Grant Moyle on October 19, 2009 6:59 AM
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...
How to Access a NAT'ed Windows Server via a VPN solution
- by Grant Moyle on October 16, 2009 8:55 AM
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....
What Hard Drives Should I Use When Building a New Server?
- by Grant Moyle on October 16, 2009 8:37 AM
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...
How to Troubleshoot Data Flow Task Errors and Warnings in SSIS
- by Scott Whigham on October 15, 2009 6:17 AM
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...
Links You Should’ve Clicked Last Week: Monday, October 12, 2009
- by Scott Whigham on October 12, 2009 12:04 PM
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...
New ebook: How to Become a C# Programmer, by Scott Whigham
- by Scott Whigham on October 7, 2009 6:17 AMLinks You Should’ve Clicked Last Week: Monday, October 5, 2009
- by Scott Whigham on October 5, 2009 11:08 AM
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...
