This month’s T-SQL Tuesday is brought to us by Riley Major (b | t) and he encourage us to talk about how we are helping by giving back to our community. This is the 102nd edition of TSQL2sDay - an Adam Machanic’s (b | t) brainchild. Let's go back for a moment: I have heard … Continue reading Learn, Evolve and Giving Back – TSQL Tuesday #102
Category: PowerShell
dbachecks – Going parallel – Cut off your execution times
On one of the last clients I have worked, I have implemented dbachecks in order to get the state of art and know how cool or bad the environments are before start knocking down the bad practices. This client has seven different environments with more than 100 instances and more than 2000 databases. Serial execution … Continue reading dbachecks – Going parallel – Cut off your execution times
dbachecks – Setting temporary configuration values
dbachecks has seen the light about two months ago. As I'm writing this blog post, the module counts with more than 2600 downloads just from the PowerShell gallery. The module has about 110 configurable checks that make our live easier! Today I will write about an option that I think users still do not realize … Continue reading dbachecks – Setting temporary configuration values
Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object *
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 *
dbachecks – A different approach for an in-progress and incremental validation
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
dbachecks – Using Power BI dashboards to analyse results
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
I will be speaking at SQL Bits 2018
In two weeks from now, on 23th 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
