When connecting to an Azure SQL DB endpoint (somename.database.windows.net), your IP must be listed in that endpoint's (server's) firewall: If you're connecting to your Azure SQL DB from SQL Server Management Studio 2016 and your IP address is not in the list, SSMS will offer to add it: You'll need to sign in with a … Continue reading Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401
With the release of SQL Server 2016, SQL Server Management Studio (SSMS) is now a stand-alone tool. It requires no licensing and can be downloaded without as much as registering. Because it is a separate download, it requires a separate installation. The computer labs I manage have SQL Server installed, including Management Studio. Prior to … Continue reading Performing a Silent Install of SQL Server Management Studio (2016)
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
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
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.
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
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