How do I Do Inventory?
Is Reporting Hard?
Don’t Know Where to Start?
Time to control of your MEM environment! Show MEM who is the Boss! Show your boss the value of MEM!
As MEM admin we are asked to control the world! But it is not always easy! It doesn’t matter if you are a one-man shop or the biggest MEM company in the world! There isn’t enough Jolt cola in the world to do it on your own!
Coaching / Mentoring
It can be stressful when you don’t know where to start with MEM! Worse yet MEM is so LARGE! Who can know everything about it?
But…. How can Garth help?
I’m a firm believer that it is only you that can help yourself. But, you might need a little help or push in the right direction! Ask garth what he think is a good fit for you.
Book you free 15 min chat.
Read The Latest
SQL Server Data Tools (SSDT) and RDL Versions
You built your report using SQL Server Data Tools (SSDT) which saves the RDL in the SQL Server 2016 format. That’s great, but now you need the native RDL in the SQL Server 2008 R2 format. In this blog post I will show you where to find the SQL Server 2008 R2 RDL in...
How to Set SQL Server Integration Services (SSIS) Protection Levels
I’m using SQL Server Integration Services (SSIS) to clone a database. I’m doing this for a customer in order to off-load the querying and reporting functions from their main Configuration Manager database server. When I built the SSIS package, I needed to embed a few...
Error: 40 – Could Not Open a Connection to SQL Server
I’m working on a project to create a SQL Server reporting database; basically it’s a clone of the ConfigMgr database for querying and reporting only. This server will act as a secondary database server where all reporting can be offloaded here and not affect the main...
How to Install SQL Server Integration Services Tools
I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a customer wants all querying and reporting off-loaded from the main ConfigMgr database server. Instead of using SQL Server Replication we’re going to use SQL Server...