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
Tuesday, April 26, 2011
When to avoid CQRS
Interesting post from Udi Dahan (who was previously an exponent of CQRS):
Saturday, April 09, 2011
SQL Server: How to Share Data Between Stored Procedures
He discusses several methods, and points out their advantages and disadvantages. [Adding here so I remember where to find it in future!]
Wednesday, April 06, 2011
SQL Server: Summary of Join Properties
An oldie but a goldie: a nice Summary of Join Properties
SSMS Table Column List Tip
On occasion, you will be at someone’s desk, looking over their shoulder when you suddenly notice something and exclaim “Hold on! How did you do that?” quickly followed by “I can’t believe I didn’t know about that!”.
I had just such an experience a few days ago. At the risk of being the last person to know this: in SQL Server Management Studio Object Explorer: open a Database, open the Tables folder, and open a Table. Left click on the Column list folder, and drag and drop to an open query window: you get a comma separated list of column names.
In the past, I had always right-clicked on the table, selected Script->Create To->New query window and then edited out the list of columns. D’oh!
Monday, April 04, 2011
Reminder: Perth .NET User Group Meeting: Thurs 7th April, 5:30pm: LightSwitch- with Andrew Coates
Join us at the Perth .NET User Group Thurs, April 7th where Andrew Coates will demonstrate LightSwitch, a new product in the Visual Studio family aimed at developers who want to easily create business applications for the desktop or the cloud. LightSwitch simplifies the development process by letting you concentrate on the business logic, while LightSwitch handles the common tasks for you. In this demo-heavy session, you will see, end-to-end, how to build and deploy a data-centric business application using LightSwitch. We’ll also go beyond the basics of creating simple screens over data and demonstrate how to create screens with more advanced capabilities
Andrew Coates is a Developer Evangelist for Microsoft in Australia. Before joining Microsoft, Andrew was an independent consultant specialising in database applications using Microsoft technologies including SQL Server, Visual FoxPro and Microsoft Office. Andrew's wide range of experience includes telecommunications, SMB inventory, dispatch and accounting systems, using both web and rich client front ends. He has developed and delivered class room training and has mentored a number of developers in Visual FoxPro and SQL Server technologies. Andrew has spoken at international conferences on Geographical Information Systems, health statistics and database maintenance and is a regular presenter at TechEd both locally and internationally. An MCPD, MCTS and MCSD, Andrew also holds a Masters degree in Civil Engineering. Andrew blogs at http://blogs.msdn.com/acoat
Get Started with SQL Azure
Want to get started with SQL Azure but not keen on setting up an account using your credit card details?
Well you can, by signing up for a 30 day SQL Azure pass for free with no credit card required (you get two 1GB Web Edition databases for one month). You can find the promo code at the Get Started with SQL Azure page.
MSN, Email: mitch døt wheat at gmail.com