Category Archives: Script

Update for Baseline Collector Solution (V1.1)

This update “is just” a bunch of bugfixes plus a new collector: sp_CollectInstanceInfo Stay-tuned! Bigger update is coming very soon… 😉 Download Comprehensive Baseline Collecting Solution V1.1 Change History Changes in V1.1 – 2015.04 Collectors New collector: sp_CollectInstanceInfo New Schedules … Continue reading

Posted in baseline, Script | 2 Comments

Comprehensive Baseline Collector Solution get published on SQLServerCentral

My free Comprehensive Baseline Collector Solution has been published on SQLServerCentral.

Posted in baseline, maintenance, Project, Script, SQL | Leave a comment

Project No. 2. – Restore Script Generator

I think it is not the first time you hear that how important is to have a restore script which helps you in DR (Disaster Recovery) scenarios. In a DR scenario one of your main enemy is the time. You … Continue reading

Posted in Disaster Recovery, restore, Script | Leave a comment

Real life scenario for collecting data using linked servers get published on SQLServerCentral

My real life example how you can collect data from SQL Server instances using linked servers has been published on SQLServerCentral (When the reporting team needs an assist…). It is also a good example for practical usage of sp_uforeach (additional link) … Continue reading

Posted in Publication, Script, sp_uforeach, SQL | Leave a comment

sp_uforeach get published on SQLServerCentral

You can find my sp_uforeach script on SQLServerCentral as well: Universal foreach aka sp_uforeach

Posted in Project, Script, sp_uforeach, SQL | Leave a comment

Project No. 1. – Universal foreach aka uforeach

Hi Everyone! This is the first post of SQLApprentice.net. In this post I would like to introduce my universal foreach script. So, here is the story: There is a very good blog post about removing duplicated indexes posted by Kimberly … Continue reading

Posted in Project, Script, SQL | Tagged , , | Leave a comment