Category Archives: Data

Upgrading to SQL 2016 (and 2017) and Windows Server 2016

A lot of engineering work has gone into easing upgrades for SQL Server and Windows at Microsoft. In general, a lot of breaking changes no longer happen especially around the database engine. But what about other components? What about Windows? … Continue reading

Posted in Business Intelligence, Data | Tagged , , , | Leave a comment

SQL Saturday! Albany July 29, 2017 – Come and learn Databases and BI!

SQL Saturdays are free training events, put on by volunteers who deliver great content to you, the audience, all around Microsoft SQL Server, and surrounding technologies. Continue reading

Posted in Azure, Business Intelligence, Data, Uncategorized | Tagged , , , , , | Leave a comment

Power BI: Pro Versus Premium

I have been sharing Power BI with customers for some time now.  A quick tour is here. At a high level, Power BI lets you pull together one or more data sources, and create visualizations that are interactive. With our … Continue reading

Posted in Business Intelligence, Data | Leave a comment

Why migrate from Oracle to SQL Server? Especially in a hybrid scenario?

There are reasons why customers ask to get off of Oracle, and onto Microsoft SQL Server. This article has a few links to help educate you. Continue reading

Posted in Azure, Data, Security | Leave a comment

Compliance and Security in Microsoft SQL Server 2012-2016

I present often to user groups and SQL Saturdays.  One topic which seems popular is the ability to secure and gain compliance in SQL Server. This presentation is best delivered by myself or someone from Microsoft, with authority on the … Continue reading

Posted in Data, Security | Tagged , , , , , | Leave a comment

Azure (and SQL) Patterns and Practices

Customers ask for, and NEED, guidance and patterns for deploying into Azure (And SQL). Patterns and Practices are written down, and created by the AzureCAT team, who help customers do cutting-edge deployments on Azure! Feel free to use this link, to help … Continue reading

Posted in Architecture, Azure, Data | Leave a comment

SQL 2016 SP1! Do you ever need SQL Enterprise again? (tl;dr, yes)

With much fanfare, SQL 2016 SP1 was released!  (Please read these release notes in depth before testing and deploying!) The original blog post talks about PROGRAMMABILITY features and post RTM+CU2 enhancements added in. “SQL Server 2016 SP1 also includes all the … Continue reading

Posted in Architecture, Data | Tagged , , , | Leave a comment