Number2 Blog - myITforum

SCCM Guru Webcast Q&A #5 - Indexing Tables

jnelson — Wed, 21 Sep 2011 03:00:00 GMT

This is part of the blog series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: I’ve heard you mention...(read more)

SCCM Guru Webcast Q&A #4 - Memory Capacity Planning

jnelson — Tue, 20 Sep 2011 04:54:00 GMT

This is part of the blog series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: Often, we see SQL...(read more)

SCCM Guru Webcast Q&A #3 - Troubleshooting…ConfigMgr vs SQL

jnelson — Sat, 17 Sep 2011 18:42:11 GMT

This is part of the blog series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: Troubleshooting...(read more)

SCCM Guru Webcast Q&A #2-Multiple Rows in Reports

jnelson — Sat, 17 Sep 2011 01:32:57 GMT

This is part of the series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: IPAddress or Subnet produce...(read more)

SCCM Guru Webcast Q&A

jnelson — Fri, 16 Sep 2011 03:46:00 GMT

On 9/14/2011, BDNA graciously asked me to speak at their SCCM Guru webcast on anything I wanted. I thought it would be a great time to give back...(read more)

SCCM Guru Webcast Q&A #1–MAXDOP

jnelson — Fri, 16 Sep 2011 03:40:00 GMT

This is the first in the series where I finish answering all the questions that came up during my SCCM Guru Webcast session. QUESTION: Can you explain...(read more)

OT - Keeping Lync from blinking so darned much

jnelson — Tue, 13 Sep 2011 20:33:00 GMT

THE PROBLEM We just started piloting Lync on our team, and up to this point I love it. But we noticed pretty quickly that when Lync (chat) is the inactive...(read more)

OT - Giving away 2 copies of SQL code formatter at the SCCM Guru webcast

jnelson — Tue, 13 Sep 2011 14:17:00 GMT

Hot diggity! The fine people at Gudu Software have kindly granted me 2 free licenses of their SQL formatter (SQL Pretty Printer, a $50 value) to give away...(read more)

SQL 2008 R2 - Uninstall of SQL fails with error about RsFx Driver or Common Files still being installed

jnelson — Wed, 31 Aug 2011 04:07:00 GMT

THE PROBLEM The other day I was trying to uninstall SQL on a lab server so I could start over with a relatively clean machine. The problem is, I got this...(read more)

SSRS–Reordering parameters in Report Builder

jnelson — Thu, 18 Aug 2011 07:41:00 GMT

I’ve been using Report Builder now for like 3 years and I only just learned this today… SCENARIO You have a SQL Reporting Services (SSRS) report with a...(read more)

SCCM 2007 - SMS Agent Host unexpectedly stops/restarts/repairs after running Resource Monitor

jnelson — Wed, 17 Aug 2011 19:02:00 GMT

OK, this one makes no sense, but we've confirmed it to be a problem for multiple people/machines in our environment. THE PROBLEM Sometime after running...(read more)

SCCM Guru Webcast

jnelson — Tue, 16 Aug 2011 05:07:00 GMT

UPDATED: This event has passed. For a while, the link below will still work to allow people to register for the replay, and after that, people should use...(read more)

SCCM - Flags (Updated: AdvertFlags, BoundaryFlags, DeviceFlags, ImageFlags, OfferFlags, PkgFlags, ProgramFlags, ReferenceImageFlags, RemoteClientFlags, TimeFlags, TS_Flags)

jnelson — Tue, 21 Jun 2011 18:01:00 GMT

THE PROBLEM So, you're looking at an advertisement, package, program or any number of things using the corresponding view in the database but you don't...(read more)

SQL - Fix the "There is no row at position 0. (System.Data)" error when clicking properties of a DB.

jnelson — Mon, 06 Jun 2011 23:52:00 GMT

THE PROBLEM Open SQL Management Studio, right click on any of the DBs and click PROPERTIES. An error message will pop up saying "There is no row at...(read more)

MS to release fix to 'The server principal "testuser" is not able to access the database "msdb" under the current security context' problem

jnelson — Wed, 19 Jan 2011 01:13:00 GMT

I can't really tell you what's in our security hardening baselines, but I can tell you that it's a good security idea to completely remove...(read more)