30 day countdown to 1.0 starts today!
Today marks the 30 day countdown to dbatools 1.0, which we will be debuting at Data Grillen in Lingen, Germany! These next 30 days are important and I’m writing...
2019-05-20
PowerShell
Scripting SQL Server objects with dbatools – Beyond default options
Probably you had the need to script out some objects from a SQL Server instance/database and this is quite easy. You just need to right click on the object...
The...
2019-05-15
Is there a UNION in PowerShell
It has been a while ago since I’ve blogged so it seems fitting that this post will be about a question that was asked of me a while ago....
2019-05-10
Public Preview of PowerShell in Azure Functions 2.x
Over the last six months, Microsoft have been hard at work integrating PowerShell Core with Azure Functions 2.x.
2019-05-03
48 reads
Automatic gathering of SQL Server configuration by using PowerShell
Through this guide, you’ll learn how to capture a few SQL Server configurations and manipulate the data by using PowerShell.
2019-05-03
Call SQL Server Stored Procedures with PowerShell using Parameter Objects
In this tip we look at how we can use PowerShell to validate input values into SQL Server stored procedures prior to execution of the stored procedure
2019-04-29
When does a Failing Pester Test return Green?
I’ve been working more with different people in different departments more and more lately at work.
2019-04-26
Building an inventory view of SQL Servers with dbatools
The situation Hey all, I am Andreas Schubert and I am working as a Principal Consultant and Database Reliability Engineer for SQL Server & Azure for multiple national and...
2019-04-26
Reporting on the Status of Clones During Database Development
Phil Factor uses SQL Clone, PowerShell and Visio to build a live 'clone network' diagram showing when there was last activity on each clone, and the number of object changes made to each one, alongside useful metadata such as the clone and image sizes, who created them and when.
2019-04-26
Automating Command Line Sessions with Powershell
James Livingston shows us how to redirect the standard in flow with .NET, using Powershell as the example language: Command Line Interface (CLI) tools can be very useful for...
2019-04-16
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers