Microsoft SQL Server in practice: installation, Always On availability groups, backup and restore, performance tuning, security, PowerShell automation, SQL Server on Linux and upgrades.
Last week, at the Pass Data Summit, they announce the new version of SQL Server Management Studio: SSMS 21 You can find the preview in here. It’s a good opportunity to test this new version before installing it by customers… After downloading the file vs_SSMS.exe (4,3 MB), start the file to doanload and install it. For the installation, you have…
I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those guys – from which I…
A customer of mine had a recurring issue with one of his business critical applications where everything was frozen and stuck for the users. The issue was caused due to a head blocking transaction which increased blocking in the database exponentially. Depending on your technical background, you may know that locking is a very important mechanism in relational database systems…
Today, we followed (with Roger Schönmann) the first day of the SQL Konferenz 2024. We will be attending this event from October 01 to 02 in Hanau. At dbi services, we are no strangers to this conference, as we have been sending members of our team for several years now.We consider the sessions to be of high quality and right…
Last night, I followed with Amine Haloui the Future Data Driven Summit 2024 from 3 PM to 2 AM This event was remote and very easy to follow. One day with 5 rooms and more then 55 speakers… Difficult to choose the session between this lot of choice and so interesting. I will share with you my experience on this…
Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about “conversion of a varchar data type to datetime data type” on this application.The error was an log4net:exception and without more explanation: For the migration, I perform a backup/restore, the collation on both servers is the same…
Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a test… The version of SSMS is 18.12.1 and it’s a version coming out the 21.06.2022… It’s the last version before…
Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the data presented by the report…
Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of SQL Server comes with certain limitations when it comes to availability groups. Here are some of these limitations However some…
Few days ago, I perform a shrink on a data file to spend a little bit space on a disk.The SQL Server is a test server and the customer does not want to expand the disk. I run the shrink like usual and waiting…. After ~15 minutes, I don’t know how much time I need to wait until it’s finished……
Few weeks ago, we had a big issue by a customer and a lot SQL Dumps was created in the SQL Server log folder. After playing fireman at the customer’s premises, we decided to set up a monitoring system for the creation of SQL dumps. The first step, is how to test it? In the latest version of SQL Server…
Following my precedents blogs on PSConfEU, I attended a session concerning how we can handle. This session was presented by Raimund Andrée and, besides confirming my conviction about importance in Naming Convention and indentation quality Raimund Andrée is a very good speaker and a passionate developer who likes to share his experience and here are what I learned from his…
