Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command. For instance, someone was using the Get-Service command to query what was the "Startup Type" of WinRM service. For that the person used the following command: which produces the following output: As you can … Continue reading Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object *
I’m currently working on a SQL code migration from Firebird to SQL Server and I hit an error that I haven’t seen for some time. The error message is the following: Msg 206, Level 16, State 2, Line 4 Operand type clash: datetime2 is incompatible with int This ringed the bell right away! Somewhere on … Continue reading Did you know…you can’t do arithmetic operations with datetime2 like with datetime?
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't know dbachecks, we have released a good amount of blog posts that will help you: Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances by Rob Sewell introducing dbachecks - a new module from … Continue reading dbachecks – A different approach for an in-progress and incremental validation
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called dbachecks. This open source PowerShell module will enable you to validate your SQL Instances. Today it is released for you all to start to use 🙂 dbachecks launch - the blog posts series Here you … Continue reading dbachecks – Using Power BI dashboards to analyse results
In two weeks from now, on 23rd of February, I will be speaking at SQLBits 2018! It’s my first time on the largest SQL Server conference in Europe for data professionals. I will deliver a session about SQL Server Reporting Services and PowerShell titled - "Administrating SSRS without boring web based clicks". You can check … Continue reading I will be speaking at SQL Bits 2018
One of the main DBA's duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service Packs, Cumulative Updates or Security Updates). Recently, dbatools added a new command that turns this validation a piece of cake. Thanks to Simone Bizzotto (@niphlod) for baking up the command that Shawn Melton (@wsmelton) and … Continue reading Using dbatools to verify your SQL Server instances version compliance
Last night, I received Adam Machanic's (b | t) newsletter "Announcing sp_whoisactive v11.20: Live Query Plans". For those who don't know about it, sp_WhoIsActive is a stored procedure that provides detailed information about the sessions running on your SQL Server instance. It is a great tool when we need to troubleshoot some problems such as … Continue reading New version of sp_WhoIsActive (v11.20) is available – Deployed on 123 instances in less than 1 minute
Today I will write just a short blog post to do a quick reminder! I still hear a lot of people suggesting CTEs because they think it works like a temporary table (you populate the table and then it can be/is reutilized). It doesn't! From de documentation: Specifies a temporary named result set, known as … Continue reading Using Common Table Expression (CTE) – Did you know…
This month’s T-SQL Tuesday is brought to us by Ewald Cress (blog | twitter) and is all about "folks who have made a difference" in our careers.
Before I complete my question let me provide context. I've received an alert saying that a specific database could not allocate a new page (disk was full) The message that you will see on the SQL Server Error log is: Could not allocate a new page for database '' because of insufficient disk space in … Continue reading DELETE data on SQL Server HEAP table – Did you know…