Welcome!

Steven Mandel

Subscribe to Steven Mandel: eMailAlertsEmail Alerts
Get Steven Mandel via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Steven Mandel

Murach's SQL Server 2012 for Developers by Brian Syverson and Joel Murach is an introduction to SQL Server 2012 and to developing key T-SQL (Transaction SQL) skills to become a successful developer. T-SQL is the language used by SQL Server to communicate with SQL Server databases. This book continues the Murach philosophy of using twinned pages to enhance the learning experience by repeating and enhancing the information on the first page with information on the facing page. I like this approach as it helps to reinforce the concepts being presented. The book contains 23 chapters that are divided into five sections. There are also three appendixes that cover installing the examples used in the book and presenting suggested coding standards. The book also highlights changes made to SQL Server starting with SQL Server 2005. While the changes made to each new SQL Serve... (more)

Book Review: Teach Yourself Windows PowerShell in 24 Hours | @DevOpsSummit #DevOps

While this book was designed to be used by Windows System Administrators, any developer who has ever needed to write a batch (.bat) file will welcome with open arms the flexibility and power provided by Windows PowerShell. This book is up to date covering all the way through PowerShell version 5. There are 24 chapters that cover a wide array of topics. In addition, any developer who has worked with the .NET framework will enjoy PowerShell, which is a command-line interface built on the .NET Framework. Teach Yourself Windows PowerShell in 24 Hours Publisher: Sams Publishing; Pape... (more)

Book Review: Murach’s SQL Server 2008 for Developers

Murach's SQL Server 2008 for Developers is an upgrade from an earlier version that was written for SQL Server 2005. It employs the Murach approach of dual pages that repeat and enhance the concepts being presented on each page. As the authors have done with previous releases of SQL Server, this book serves as a good review and as an introduction to the new features added to SQL Server 2008. In addition, because of the relative newness of SQL Server 2005, they also point out features that were added with that release as well. The book has 22 chapters that are divided into five sect... (more)

Book Review: Professional ASP.NET MVC 1.0

In recent years there has been a growing interest in applying design patterns to various aspects of programming. One of the more well-known patterns is the Model-View-Controller pattern or MVC. This pattern has a great deal of appeal in the web design environment because it offers the developer more control and a greater separation between the major aspects of web design - the presentation layer (View), the business layer (Controller), and the data layer (Model). In fact the pattern should probably have been called MCV as the controller portion really serves as the glue that hold... (more)

Book Review: Expert T-SQL Window Functions in SQL Server | @CloudExpo #API #Cloud #TSQL #SQLServer

There is an old saying that good things come in small packages. This saying definitely applies to this book, which focuses in on a set of functions that most people are not aware of that are available in SQL Server. To start off with we need to answer the following question: What are T-SQL Window functions? These functions have nothing to do with the Microsoft Windows API. They are in essence a way to create a window into your data as you process each line in a query. Their strength lies in the ease with which you can solve tricky queries. The authors also point out that these fu... (more)