My first NuGet package: Repository and UnitOfWork patterns for EF 6.1.3

Since I've been developing software again, I've had to sharpen my skills on the latest enterprise architecture patterns and how they are used in .NET. The Repository and UnitOfWork patterns aren't new, but implementing them correctly to achieve the most benefit without going overboard is nevertheless a learning curve. I found a presentation posted on … Continue reading My first NuGet package: Repository and UnitOfWork patterns for EF 6.1.3

Why I wish Microsoft would unify Office 365 groups and Team Sites

A group in Office 365 (link to a Sway) is a very useful concept: it allows any user to quickly create a shared mailbox, document repository, OneNote notebook and shared Calendar. Compared to a Team Site, it's quick to set up and requires no special privileges. (That does create some potential governance issues, but I … Continue reading Why I wish Microsoft would unify Office 365 groups and Team Sites

Visual Studio 2015: New file marked as “checked in” instead of pending add in TFS.

I've recently started using Visual Studio 2015 quite extensively for a development project. Overall, my impression of the latest release is favorable. It feels snappier than older versions and the touch of color that's been brought back compared to 2012 is most welcome. However, I have run into an issue I believe is new to … Continue reading Visual Studio 2015: New file marked as “checked in” instead of pending add in TFS.

SQL Saturday #439 Columbus 2015 to be held at Troy University

I am excited to share that SQL Saturday #439 Columbus 2015 will be hosted by Troy University's Sorrell College of Business and the Phenix City Campus. In about one month, on October 3, 2015, make plans to attend this free, one-day SQL Server event. Not only can you pick up some new SQL skills or … Continue reading SQL Saturday #439 Columbus 2015 to be held at Troy University

ASP.NET config in Azure: Couldn’t be easier

I've started a new software development project recently, and the entire solution will be hosted on Azure PaaS resources, including Web Apps. Part of application development involves storing configuration settings for the application. Notably, this could include the database connection string(s). In the case of the app under development, there are Azure Active Directory, Azure … Continue reading ASP.NET config in Azure: Couldn’t be easier

T-SQL window functions talk summary and sample scripts

Yesterday, I spoke to the Steel City SQL User group on T-SQL window functions. Below is a short summary and links to the sample scripts and database. The T-SQL window functions came about in SQL Server 2005, but you really want SQL Server 2012, because many functions were added and also because support for PARTITION … Continue reading T-SQL window functions talk summary and sample scripts

SQL Saturday #342 in Mobile is tomorrow

Here is a summary of my session, at 3 PM in "Room 2" (that just sounds too easy...) Of course, you really want to sign up for the other speakers, but just maybe at 3 PM my session will appeal to you. P.S.: Bring your family to Mobile! Tomorrow they can get free admission to … Continue reading SQL Saturday #342 in Mobile is tomorrow