#sql-server

Articles tagged with #sql-server

Publishing Powershell Azure SQL VM Toolkit
A PowerShell toolkit for preparing Azure SQL Server VMS
Mar 8, 20266 min read70
Deploying Azure SQL VMs with PowerShell Azure Bastion + dbatools
Update of my older post after the breaking changes by Microsoft
Mar 29, 202510 min read85
Sql Tuesday: Azure Data Groups
Every second Tuesday of a month, there's a T-SQL-Tuesday. This is a blogging event that everyone can participate. The idea was created by Adam Mechanic, but nowadays, it's hosted by Steve Jones. For this month, Rie Merritt called for advices for run...
Mar 20, 20223 min read7
Why We Like to Recommend Dbatools
This post was first published for my employer, OneDigit AG, here. dbatools really has the ability to change a DBAs work life. It is a free, very powerful and feature rich open source PowerShell module that offers you 550+ commands that allows you to ...
Jul 7, 20214 min read6
Deploy Azure Sql Server Vm With PoSh
This post was first published on my past employers blog here. I thank OneDigit AG for the permission to publish my article also here. Especially in this time of COVID-19 caused lockdowns, working from home is widespread. Therefore, working together ...
Jan 18, 202112 min read38
Introduction Into Window Functions on SQL Server
Why window functions may come in handy Let us dive directly into a real world example. You’ve got a table with salaries of different job functions and you are asked to find out what the n-tiles (quantiles, mean etc.) are of each function within a com...
Mar 7, 20205 min read8