LenniProfile200.jpg

Leonard Lobel

Leonard Lobel is a SQL Server MVP and cofounder/CTO of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. Programming since 1979, He is also a consultant, trainer, author, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, SQL Bits, CodeCamp, and other industry conferences worldwide. Lenni is also lead author of the MS Press book “Programming Microsoft SQL Server 2012.” He can be reached at lenni.lobel@sleektech.com.
http://lennilobel.wordpress.com http://lennilobel.wordpress.com/rss

This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.

Blog posts RSS

Just Published: Microsoft Azure SQL Database Step by Step 13 Jul 2014
I’m extremely pleased to announce that my new book on Microsoft Azure SQL Database has just been published! The book, part of the Microsoft Press “Step By Step” series, is designed for readers to quickly get productive with Microsoft Azure SQL Database — the cloud version of SQL Server. ...

Observations of a SQL Saturday Speaker 01 Jul 2014
I enjoy speaking at SQL Saturday events every chance I get. I’ve spoken at well over a dozen of them by now, both in the U.S. and abroad. Every SQL Saturday is different, and that’s part of the charm of course. Organizers (all volunteers) work hard to make sure everything runs smoothly. Still, on ...

Using PowerShell to Manage Windows Azure SQL Database 11 May 2014
PowerShell is Microsoft’s modern scripting language for system administration that supports a wide variety of tasks by executing commands (known as cmdlets, pronounced command-lets) from the PowerShell command line. Microsoft has also developed PowerShell cmdlets for managing Microsoft Azure, ...

Downloading SQL Server Express Edition 18 Apr 2014
I’m often asked how to install SQL Server Express Edition, and what the different download options are. So I finally decided to explain it all in this blog post. There are several SQL Server Express Edition downloads available on the Microsoft site, and they are available in both 32-bit and ...

Creating a New SQL Database on Windows Azure 22 Mar 2014
In my previous post, I showed you how to sign up for a Windows Azure subscription. Once you’ve got your subscription, it’s easy to create a SQL Database, which is very much like an ordinary SQL Server database hosted in the cloud. In this post, I’ll show you how. Essentially, you ...