Dutch Geek André Kamman's personal blog

Blog

SQL Server Container Instances via Cloudshell

S

Every now and then (actually, quite often now I think of it) I need to test code on a bunch of different versions of SQL Server. And I prefer those SQL Server instances to be fresh every time. Quickest way that works for me, fire up my Azure Cloud Shell and start a script. The script creates all containers asynchronously, takes about 15 minutes because it needs to pull them. First things first...

Invoke-DbaDiagnosticQuery

I

Gary Bargsley (b|t) is the host of this months T-SQL Tuesday #110 – ” Automate All the Things” The question he asks is easy: What do you want to automate or what automation are you proud of completing? My answer to that is simple, I’m a major contributor to the awesome Powershell library dbatools. What I’ve contributed to that library are commands that will help...

It’s been 30 years!

I

January 1st, 1989 was my first day at work for my first job in IT. You would think that everything was completely different 30 years ago. The advance in sheer computing power and the evolution of languages and frameworks had me think for a bit that this is the case as well. But actually, the difference is not that big! A “Point 4 – Mark 12”, this doesn’t exist anymore...

SQL Saturday Holland 2016

S

I’m a big fan of SQL Saturdays. I frequently speak at them and I’m part of the team behind SQL Saturday Holland.
This year (2016), the Data Discovery team from InfoSupport made a great video about our event.
I’m so proud to be a part of our event, can’t wait until we start planning the 2017 edition!

Managing Ola Hallengrens scripts with Powershell

M

I presented for the PASS Powershell Virtual Chapter on June 15th, 2016 It was an online session and it was recorded, the youtube video of it is here I figured out what was wrong with the two little demo fails. I was pressing F8 to only execute my selection but because of a CLS I didn’t see the error message. That function that I use to load a script from a relative path doesn’t work when you...

A fun way to learn about Database Corruption

A

For 10 weeks in a row now I’ve been participating in Steve Stedman’s “Database Corruption Challenge”. I’ve learned a ton of stuff and I was able to add some new scripts to my toolbelt because I needed them to solve the challenges. In the coming months I will be blogging about some of the interesting things I learned, I can’t do that just yet right now because...

Building a Monitoring System with Powershell Remoting

B

For people who have seen my presentation and are interested to play with the demo code. Please find the PDF of the presentation and the demo scripts here Pre-Requisites: Create a database called BlitzOutput and run sp_blitz, make sure it safes the result in a table called spBlitz like this: exec sp_blitz @OutputDatabaseName =’BlitzOutput’, @OutputSchemaName =’dbo’...

SQL Server 2014 PreCon at SQLSaturday Exeter 2014

S

With just a couple of weeks to go I wanted to emphasise something that is not completely clear from the title and abstract. It says that the session is for DBAs but that title is not complicated enough, it should read something like : “What’s new in SQL Server 2014 for (Involuntary) DBAs, (DevOps type) Developers, Large Site DBAs and ‘Every Other Size Site, for instance Standard...

Dutch Geek André Kamman's personal blog

Calendar

May 2024
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  

Categories