by Vatsana Kongtakane | Jun 22, 2017 | Azure, Blog, Microsoft SQL Server
As more users are starting to move their SQL workloads to the cloud, one of the common questions is how to setup user authentication with their Office 365/Azure Active Directory tenant. There is of course some limitations. At this time, Azure AD authentication can…
by Eric Isaacs | Jun 6, 2017 | Azure, Blog, Microsoft SQL Server
When scripting out SQL Server objects in earlier versions of SQL Server, you’ve historically had the option to do so with “CREATE”, “DROP and CREATE”, or as “ALTER” scripts. Each option has advantages over the others for…
by Eric Isaacs | Feb 20, 2017 | Azure, Microsoft SQL Server
In Transact-SQL (T-SQL) there are two ways to comment SQL code that are similar to comment options in many programming languages. First, there’s the “slash star” (/*) comment block that allows you to comment out multiple rows of SQL. Second,…
by Vatsana Kongtakane | Nov 30, 2016 | Azure, Blog, Microsoft SQL Server
In September, Microsoft finally announced Azure encryption support for data at rest, a long awaited feature by many companies which are bound by regulation and requirements. The great thing about this is you can easily enable encryption by toggling it to…
by Michael Philbrick | Mar 13, 2015 | Blog
Frequent monitoring of server status is a critical DBA task. This is compounded when there are multiple servers running many jobs through the SQL Server Agent. Recently we were faced with assessing the job load on multiple servers, particularly the number and…