SQL Saturday #409 Rheinland

SQL Saturday #409 – PASS Rheinland – Speaker List announced

The official speakers list for the next SQL Saturday # 409 of the SQL PASS Chapter Rheinland has been released. The organizers had selected a great mix of interesting topics for each track, I think it’s very high sessions quality and I would like to participate too (but will not be able for personal reasons)….

Backup Button

SQL Server Backup throws Error Message – Msg 3201 Level 16 State 1

Here I want to share my experiences with you regarding SQL Server Backup and a backup error message “Msg 3201 Level 16 State 1”, sometimes the simplest things becomes the hardest;-) But even for the simple things in life there will be always solutions which I would like to show you. Customer order: “Please copy…

Backup Button

TSQL #66 – Monitoring Backup Solution – Backup History

From multiple occasion I also want to write something on the subject of backup history, first of all because Catherine Wilhelmsen has hosted the TSQL Tuesday # 66 and secondly Thomas Larock has introduced a similar solution just today. We DBAs knowing the vexing issue of backup monitoring … did it run or did not…

Microsoft Business Intelligence and Analytics

New data visualization capabilities in Excel 2016

Microsoft has announced the further expansion of their BI tool environment at this year’s MSIgnite. Within the new Office 2016, especially Excel 2016 comes with new business analytics features and possibilities of graphical representations. Excel at least since the version of 2007 is one of the business analytics tools in Power BI with Microsoft SQL…

Now Letters in Frame

Servicepack 1 for SQL Server 2014 available again

After Microsoft published Service Pack 1 for SQL Server 2014 on 15 April 2015 and recalled it very quickly, Microsoft also quickly reacted, improved and revised Service Pack 1, and now it is republished again. As you can read in the corresponding MSDN-Post, steps have been taken to resolve those problems and issues with the…

man in green and black stripe shirt wearing black hat

Which SQL user has got which role and access on my SQL Server – analysis of roles & rights

Analyzing SQL Server User Roles and Permissions: Who Has Access? We often receive inquiries from our customer service team regarding needing an overview of all configured SQL users and their permissions on an SQL Server. When acquiring new servers, relying solely on scripts from experts like Brent Ozar may not always suffice. To address this…