## AboutSQL Server, Analytics, .Net, Machine Learning, R, Python ## Archives- May 2006
- June 2006
- July 2006
- August 2006
- September 2006
- October 2006
- November 2006
- December 2006
- January 2007
- February 2007
- March 2007
- April 2007
- May 2007
- June 2007
- July 2007
- August 2007
- September 2007
- October 2007
- November 2007
- December 2007
- January 2008
- February 2008
- March 2008
- April 2008
- May 2008
- June 2008
- July 2008
- August 2008
- September 2008
- October 2008
- November 2008
- December 2008
- January 2009
- February 2009
- March 2009
- April 2009
- May 2009
- June 2009
- July 2009
- August 2009
- September 2009
- October 2009
- November 2009
- December 2009
- February 2010
- March 2010
- April 2010
- May 2010
- June 2010
- August 2010
- September 2010
- October 2010
- November 2010
- December 2010
- January 2011
- February 2011
- March 2011
- April 2011
- May 2011
- June 2011
- July 2011
- August 2011
- September 2011
- October 2011
- November 2011
- December 2011
- January 2012
- February 2012
- March 2012
- April 2012
- May 2012
- June 2012
- September 2012
- October 2012
- November 2012
- December 2012
- January 2013
- February 2013
- March 2013
- April 2013
- May 2013
- December 2013
- March 2014
- June 2016
- November 2016
- December 2016
- September 2017
- October 2017
- November 2017
- December 2017
- January 2018
- February 2018
## About Me**Name:**Mitch Wheat**Location:**Perth, WA, Australia
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 |
## Thursday, July 23, 2009## SQL Server 2008: Script Data as InsertsI expect many people know this already but just in case you don’t: in addition to scripting your database schema as TSQL, you can also generate data insert scripts directly from SQL Server 2008 Management Studio. Right-click on your database in SSMS, select (I’m not sure if this was also present in SQL Server 2005, as I don’t have an instance to hand). ## Sunday, July 19, 2009## .NET: Determine Whether You Are Running in a 32-bit or 64-bit ProcessSaw this excellent tip on StackOverflow today: You can use IntPtr.Size to determine whether you are running in a 32-bit or 64-bit process, as it will be 4 or 8 bytes respectively. ## ASP.NET 2.0 Security PracticesJust so I have this excellent article link to hand: ASP.NET 2.0 Security Practices at a Glance ## Tuesday, July 14, 2009## Book Review: The Computer as Crucible: An Introduction to Experimental MathematicsKeith Devlin and Jonathan Borwein. AK Peters, 2008, Whenever a book’s preface states its aims, a natural question to ask is whether it succeeds in meeting them. Keith Devlin and Jonathan Borwein, two mathematicians with expertise in different mathematical fields but with a common interest in experimental mathematics, begin this book by saying:
The sleuth-like style and lucid writing certainly make this book an enjoyable read. Many explanations are framed by relevant historical context and tales of mathematicians whose use of experimental mathematics helped them gain insights into difficult problems. Although it was never intended to be a course textbook, it could be used as a supplementary text. Many of the chapters are short, and should be viewed as aperitifs. Chapter 1 deals with the important question “What is Experimental Mathematics?”. In the authors’ own words,
Broadly speaking, it is the use of computers in mathematics as tools in their own right, not simply as numerical calculation aids, “...experimentation is regarded as a significant part of mathematics in its own right…”. What kind of experimentation? Here are some of the things described in this book: - Symbolic computation using a computer algebra system such as Maple or Mathematica
- Data Visualisation
- Integer-relation algorithms like PSLQ
- High precision integer and floating point arithmetic
- High precision evaluation of integrals and summation of infinite series
- Identification of functions based on their graph characteristics
It would be very easy to fall into the belief that great mathematicians pluck profound and deep results out of thin air, but some of the mathematical greats (Gauss, Euler, Fermet, Riemann...) were confirmed experimenters who would spend many hours carrying out calculations in order to discover new mathematical avenues worth pursuing. The 72 year old Gauss recounted in a letter to the astronomer, Johann Encke, that as a young boy of 15, armed with a table of logarithms he ‘frequently spent an idle quarter of an hour to count another chiliad here and there’ [3], which led to his estimate of the density of prime numbers; “..Gauss was very clearly an ‘experimental mathematician’ of the first order.” Chapter 2 gives a brief introduction to the PSLQ algorithm, an integer relation algorithm developed by Helaman Ferguson. Given any real coefficients a |λ or else it tells you such expression exists within a ball of a given radius about the origin. Chapter 3 (What Is That Number?) introduces Inverse Symbolic Calculators as tools to recognise numbers, and combined with Sloane’s online Encyclopedia of Integer Sequences, describes a technique for determining closed forms of sequences. I have more than a passing interest in Riemann’s zeta function, the topic of Chapter 4 (The Most Important Function in Mathematics); I found it interesting though perhaps a little short. I particularly liked the quote about British soccer player, Wayne Rooney, contrasting him with David Beckham: “There is more chance of him [Rooney] proving Riemann’s Hypothesis than wearing a sarong”! I’m certain physicists will find chapter 5 (Evaluate the Following Integral) interesting, especially given the authors’ collaborations in computing closed forms of definite integrals arising in physics. Chapter 9 (Take It to the Limit) contains 3 worked examples of finding closed forms for infinite sums, and Chapter 10 (Danger! Always Exercise Caution When Using the Computer) contains sobering stories and examples of some of the pitfalls faced by experimental mathematicians. Here is one: A computer algebra system (CAS) will discover that I On finding this, the authors suspected a bug in the CAS software. But there is no bug! The book provides tantalising examples and suggestions to whet the reader’s appetite in the form of an ‘Explorations’ section at the end of each chapter, not exactly exercises but there is a corresponding ‘Answers and Reflections’ chapter at the end of the book. Interested readers will find many of these topics expanded upon in [1]. I thoroughly enjoyed reading this short introduction to experimental mathematics. It will no doubt appeal to a broad mathematical audience, both professional and amateur alike. If I have one complaint, well more of a request, it would be a much longer chapter on evaluating definite integrals! But then, in the words of G. H. Hardy, “I could never resist a definite integral” [2].
## References[1] David Bailey [2] Macdonald, H. S. (1999). [3] Havil, J. (2003). [This review appeared in the July 2009 issue of the Australian Mathematical Society’s Gazette.] ## Saturday, July 11, 2009## Retrieve Deadlock Info with SQL Server 2008Did you know that SQL Server 2008 has the ability to retrieve deadlock information after
More info. here: Using SQL Server 2008 Extended Events ## Wednesday, July 08, 2009## ClearTrace for SQL Server 2008I blogged about ClearTrace a while back. There’s a new version available that targets SQL Server 2008 (as well as SQL Server 2005). Download here. It’s a useful tool and the improved performance loading large trace files is a bonus. |
## Contact
## Links## Favorites- Recommended Computing Books
- Visual Studio 2005 IDE Productivity Tips and Tricks
- Design principles
- Development Principles
- Reporting Best Practices
- Software Development Must Haves
- SQL Server Performance Tuning Resources
- .NET Exception Handling GuideLines
- Becoming a Better Programmer
- Debugging Reading List
- Tips for Effective Meetings
## Blogs |