SQL Server

Get the main Administration Information from SQL Server with PowerShell

In my previous blog Get SQL Server services with PowerShell, I presented you the first step of the SQL Server administration through an automated process. This blog is a follow-up of the previous one, and it will focus(…)

Get SQL Server services with PowerShell

SQL Server Configuration Manager and SQL Server Management Studio are the main tools to administrate the components of SQL Server. They are very convenient to use and pretty complete. But as soon as you wish an automated process, these(…)

SQL Server Tips: How to know if In-Memory Feature is supported by your server?

A customer asks me, how to know if In-Memory Feature is supported by my SQL Server server? An easy way is to check the edition, version etc. but now, you have directly a property for that. On msdn(…)

SQL Server – Change Management: list all updates

I am looking to have all SQL Server updates on a server including Service Packs, Cumulative Updates and other fixes like we can see in the uninstall panel from Windows. I take the opportunity of this(…)

Weird issue with sys.fn_hadr_backup_is_preferred_replica() function

A couple of days ago, I faced a weird backup issue with SQL Server AlwaysOn and availability groups at one of my customer (thank to him to point out this issue 🙂 ). After installing our DMK tool (Database(…)

A funny story with recompile hint at statement level

Last night, I had an interesting discussion with one of my MVP French friend that faces a weird situation where a query that uses a statement level RECOMPILE hint produces an execution plan that disappointed him. He told me we(…)

Venturing into bulk insert a SQL Server error log and data order

Have you ever attempted to bulk import a SQL Server error log in order to use the information inside a report for example? If yes, you have probably wondered how to keep data in the correct order in a query(…)

Analyzing easily the blocked process report

Which DBA has not yet face a performance problem issued by several blocked processes? In reality, I’m sure a very little number of them. Troubleshooting a blocked issue scenario is not always easy and may require to use some useful(…)

SQL Server monitoring with nagios: utilisation

We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and(…)

SQL Server monitoring with nagios: installation

Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation(…)