(Koen Verbeeck) We have deployed several Integration Services (SSIS) projects to the catalog in SQL Server. Packages are being scheduled and run daily. We would like to have an overview of all the executions and whether they were successful or not. We would also like to troubleshoot error messages.

(Brien Posey) There are two options for deploying SQL Server on the Azure cloud. Here’s a look at how they differ to help you choose between Azure SQL Database and SQL Server on an Azure VM.

(Grant Fritchey) Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas provide you with another tool to control how your database behaves.

(Pinal Dave) One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.

(Jack Vamvas) Finding the SQL Server Instance Default Path and the Instance Default Log Path in the old days (pre SQL Server 2012) was generally limited to either checking SSMS for the Instance Default Path or Log Path , and you could also use xp_regread to extract the information from the Registry.

(Chris Webb) Here’s some interesting (and borderline buggy) Excel PivotTable behaviour I learned about today from Charles-Henri Sauget, as well as the workaround for it courtesy of the great Greg Galloway.

(Nick Lopez) Often, users will want to create their SQL Logins in the user@mydomain.com format. While a perfectly valid format, this can lead to login failures if not accounted for.

(Pinal Dave) A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information.

(Arun Sirpal) Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server Management Studio (SSMS) 17.2 You now have the option to use Azure AD authentication for Universal Authentication with Multi-factor authentication (MFA) enabled, by that I mean use a log

(Pinal Dave) Have you ever wondered what does DBCC SQLPERF do in SQL Server?