Vacation Reading List
Posted by Marc Jellinek in Uncategorized on September 2, 2019
I just got back from a vacation. Sun, fun, friends and frolic. Some much-needed R&R. One of the most luxurious things I can do is to sit and read. I’ve been saving documents and ebooks in my “Stuff to Read” folder for months and I would finally have uninterrupted time to read, especially on the […]
Death of a Hard Drive: The End of an Era
Posted by Marc Jellinek in Uncategorized on August 21, 2019
Presentations from Dev Up 2016
Posted by Marc Jellinek in Azure, SQL Stuff on October 22, 2016
I had the honor of being selected to present two sessions at Dev Up (formerly St. Louis Days Of .NET). The first was about deploying a SQL Server AlwaysOn Availability Group in Azure. The slide deck can be found here: Deploying SQL Server in Azure – Configuring High Availability Cluster The second session was about Azure […]
Loading Data into Azure Storage Tables using PowerShell
Posted by Marc Jellinek in Uncategorized on June 17, 2016
Summary I had a customer looking to pump a large amount of data (millions of rows) into Azure Storage Tables. Here’s how we did it. Prerequisites If you’d like to follow along, you are going to need: Visual Studio PowerShell Azure PowerShell Azure Storage Tables Azure Storage Tables are defined this way: Table Storage stores […]
Automatically shutting down VMs in Azure
Posted by Marc Jellinek in Uncategorized on June 10, 2016
THIS ARTICLE IS NOW OUT OF DATE. Azure VMs have the built-in ability to shut themselves down on a schedule, available through the Azure portal. Refer to: https://azure.microsoft.com/en-us/blog/announcing-auto-shutdown-for-vms-using-azure-resource-manager/ Well it’s been a short time since I made the transition from DW/BI to Cloud. I’ve learned a couple of interesting things. I was trying to find/write a […]
ASUS Transformer Book T100
Posted by Marc Jellinek in ASUS, Toys on October 23, 2013
When I heard about the ASUS Transformer Book T100, I instantly knew I had to have it. (http://www.asus.com/News/2bLO0JtVTahzIwt2) Why? It’s a large tablet that transforms into a small notebook. It’s a Windows 8.1 machine with touch. It gets 11 hours of use on a single charge. When docked, it folds into a single unit. It […]
How do you calculate someone’s age in years, months and days?
Posted by Marc Jellinek in SQL Stuff on August 26, 2013
In the Microsoft SQL Server Group on LinkedIn (http://lnkd.in/qYvG5R), a question was asked: How do you calculate someone’s age in years, months and days. I gave it a shot and… well… failed. Here’s my updated code. It will take care of cases where the birth date is Feb 29th or any birthdate on the 29th-31st […]
How to create a Gantt-like Chart in SQL Server Reporting Services
Posted by Marc Jellinek in SQL Server Reporting Services, SQL Stuff on August 19, 2013
Intro and Background I was recently asked for some help with a Dynamics CRM Online engagement. The customer wanted a Gantt-like chart that showed the span of active opportunities. Dynamics CRM Online really isn’t important to my post, except in one major detail. Dynamics CRM Online doesn’t allow access to the underlying data. There is […]
Memorial Day – 2013
Posted by Marc Jellinek in Uncategorized on May 27, 2013
To all that have served and all that have sacrificed, thank you. This was sent to me and is being reprinted with permission. It’s somewhere between an essay and poetry. Written by Sahar Rohani, a 13 year old in eighth grade. Imagine. You’re in a staring contest with death, and in the painful grasp of […]
Ever needed to write a text file from within SQL Server?
Posted by Marc Jellinek in SQL Stuff, SQLCLR on December 9, 2011
Well, there are a three of ways of doing this: Extended Stored Procedures, OLE Automation and SQLCLR. While it is out of the scope of this post, Extended Stored Procedures and OLE Automation are things that have been retained in the SQL Server product in order to maintain a measure of backwards compatibility. Microsoft often […]
