Tips & Tricks
Petya/NotPetya Kill Switch and SCCM
There’s yet another WannaCry variant out there and this time it’s called Petya! I heard about a method in ZDNet from Amit Serper that will prevent this variant of WannaCry/Petya from infecting computers. In reality, this method involves creating a file called perfc...
How to Change the Page Measurements and Paper Size of a SSRS Report
I recently was sent a SQL Server Reporting Services (SSRS) report that needed to be edited and updated. One of the items that I was tasked with was converting the report’s page size from centimeters to inches. Additionally changing the page layout from A4 to 11” x...
Five Tips for Query Designer
In my previous blog post, Query Designer in SQL Server Management Studio (SSMS), I showed you how to access Query Designer (also known as Design Query in Editor and Graphical Query Designer) within SQL Server Management Studio (SSMS). With Query Designer you can...
Query Designer in SSMS
As a Microsoft Endpoint Manager Configuration Manager (MEMCM / MECM/ SCCM / ConfigMgr) Administrator we share many hats. The other day I was showing a ConfigMgr Administrator how to write a query and also how to create drill-throughs from within his reports. I began...
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...
What Is Parsename and 4 Part Version String?
In my article from last week, What Is A 4-Part Version Numbers? I showed you how Add Remove Program (ARP) versions are actually a string and not a number, like most people think it is. But how can you query the 3rd octet of a version string, if the math function don’t...
What Is Parsename and 4 Part Version String?
In my article from last week, What Is A 4-Part Version Numbers? I showed you how Add Remove Program (ARP) versions are actually a string and not a number, like most people think it is. But how can you query the 3rd octet of a version string, if the math function don’t...
Drinks
Not many people know that I took my bartender course several years back. As part of my homework for the course, I needed to create drinks unique drinks. Also, as part of this course we needed to edit existing drinks to make them used off the shelf aka “bar rail”...
How to Map OneDrive as a Mapped Drive
Like many of you I have my office OneDrive and my personal one drive. My personal OneDrive is connected to my phone and home computer. Sometimes, I need to copy files between my business personal computer and business computer. I really should say my blogging computer...