Welcome to the “SQL Server” category! This is your hub for all things related to Microsoft’s premier database management system. As an experienced database administrator with years of hands-on experience in managing Microsoft SQL Servers, I’m your guide in this category. We will delve deep into the various aspects of this powerful DBMS.
In our articles, you’ll find comprehensive information about SQL Server installations, configurations, best practices, and performance optimizations. We will also explore the integration of Azure SQL, covering techniques for connectivity, secure operation, and efficiency maximization.
We’ll address critical topics such as database management, security considerations, and automation using PowerShell and dbatools. Moreover, we’ll discuss real-world challenges and their solutions to assist you in tackling your SQL Server issues.
Our content is practical and enriched with technical details. We provide references to official Microsoft documentation and offer guides and recommendations based on best practices.
Dive into the world of SQL Server with us, expand your knowledge, and stay up to date with the SQL community.
For T-SQL Tuesday #80, Chris Yates (b|t) asks “Is there something you’ve been wanting to do for a long time in SQL, but haven’t done it yet?”. Yes, of cause 😉 There are some many topics I want to learn, to talk and to present about in the (near) future. Just to give you a…
We all know it, we are to provide information on our SQL servers … either the customer or a colleague will quickly have an overview of the most important parameters of the SQL Server … What is closer than times since just quickly a TSQL statement on performing the requested server? The last of such…
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)….
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…
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 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…
