SQL Server, Analytics, .Net, Machine Learning, R, Python
Mitch Wheat has been working as a professional programmer since 1984, graduating with a honours degree in Mathematics from Warwick University, UK in 1986. He moved to Perth in 1995, having worked in software houses in London and Rotterdam. He has worked in the areas of mining, electronics, research, defence, financial, GIS, telecommunications, engineering, and information management. Mitch has worked mainly with Microsoft technologies (since Windows version 3.0) but has also used UNIX. He holds the following Microsoft certifications: MCPD (Web and Windows) using C# and SQL Server MCITP (Admin and Developer). His preferred development environment is C#, .Net Framework and SQL Server. Mitch has worked as an independent consultant for the last 10 years, and is currently involved with helping teams improve their Software Development Life Cycle. His areas of special interest lie in performance tuning
Sunday, July 31, 2011
New Version of VSCommands 2010
A new version of VSCommands 2010 was released earlier this month. New features include file structure, output windows highlighting (makes errors easier to spot), and friendly solution name (handy where you might be working in multiple branches of the same project).
Saturday, July 30, 2011
SharePoint 2010 Database Maintenance Whitepaper
Paul Randal, who teaches the SQL Server portion of the SharePoint MCM, has released an updated version of the database maintenance whitepaper for SharePoint 2007 (which was somewhat out of date). You can download it from here.
Friday, July 22, 2011
SQL Server Maintenance Solution
Ola Hallengren has recently released a new version of his maintenance solution scripts. He has added the ability to log to a table, which is useful if you want to analyse how your indexes are rebuilt and reorganized over time. All you need to do is to set @LogToTable = 'Y'.
EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',
It can also be used with DatabaseBackup and DatabaseIntegrityCheck.
Thursday, July 21, 2011
New 550MB/s SSDs
If you’re thinking of buying a new shiny 550MB/s SSD, there are two things you should keep in mind:
(Some motherboards specs even refer to Sata-600 and Sata-300 to try and limit the confusion)
SATA revision 2.0 (SATA 3 Gbit/s)
With a native transfer rate of 3.0 Gbit/s, and taking 8b/10b encoding into account, the maximum uncoded transfer rate is 2.4 Gbit/s, providing a peak throughput of about 300 MB/s.
SATA revision 3.0 (SATA 6 Gbit/s)
Provides a peak throughput of about 600 MB/s (Megabytes per second) including the protocol overhead (10b/8b coding with 8 bits to one byte).
My realisation came about today through a conversation I had with Hadley Willan (aka Hadders). He’s a gold mine of tech info; I wish he would blog these gems more often…
Tuesday, July 19, 2011
Visual Studio LightSwitch 2011
[NOTE: If you are planning to install LightSwitch Beta 2, and Visual Studio 2010 Express, Professional, Premium or Ultimate is installed, you must first install Visual Studio 2010 SP1]
Friday, July 15, 2011
Visual Studio 2010 Debugging Tips
Not new, but several excellent Visual Studio 2010 debugging tips from Scott Guthrie, some you probably know and perhaps the odd one you might not be aware of (or have forgotten about).
Thursday, July 14, 2011
Fixing Slow SQL Server Management Objects (SMO) Performance
Just recently I’ve been converting a small utility that uses SQL-DMO to use SQL-SMO instead (SQL-DMO is deprecated in SQL Server 2008 R2; if you really need to use it, install the Backward Compatibility Components from the SQL Server 2008 Feature Pack from the Microsoft Download Centre). Remembering all those posts saying how slow SMO was compared to DMO, a colleague mentioned this:
Server server = new Server();
To build an SMO application, you need to reference the SMO assemblies. Click ‘Add Reference’ and navigate to the folder
C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies
Add references to:
(These are the minimum files that are required to build an SMO application)
SQL Server Code Name "Denali" CTP3 Released
SQL Server Code Name "Denali" CTP3 has been released. You can download from TechNet here (I believe it requires a current subscription).
Wednesday, July 13, 2011
SQL Server 2008 R2 Service Pack 1 Released
The title says it all!: SQL Server 2008 R2 Service Pack 1
Monday, July 11, 2011
SQL Server 2008: The ultimate guide to the datetime datatypes
I mentioned Tibor Karaszi’s guide a while back and he’s updated it for the datetime datatypes added in SQL Server 2008. A great reference: The ultimate guide to the datetime datatypes
Sunday, July 03, 2011
Windows Azure Platform FAQs
Just for my reference: Windows Azure Platform FAQs contains a nice overview and description of many of the aspects of Microsoft’s cloud offering, including SQL Azure, and a list of feature differences between SQL Server versions and SQL Azure.
MSN, Email: mitch døt wheat at gmail.com