Browse by Tags

All Tags » SQL (RSS)

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

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...

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

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...

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

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...
Filed under: , , ,

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

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...
Filed under: ,

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

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...
Filed under: ,

SMS/ConfigMgr - SQL Function to Convert Integer8 (from Active Directory) to Datetime/Local Time by jnelson

INTEGER8... It's possible you're pulling a value from Active Directory for discovery like LastLogonTimeStamp which stores it's value as something...

UPDATED: SQL Function - udf_ConvertBytes - Converts any Byte-based unit of measure to any other Byte-based unit of measure (Bytes, MB, GB, TB, PB, EB, ZB, YB, BB, GeopBytes) by jnelson

Yesterday I wrote THIS article to convert between different byte-based units of measure...in it I wrote that the ideal way to convert is to have a lookup...

SQL Function - udf_ConvertBytes - Converts any Byte-based unit of measure to any other Byte-based unit of measure (Bytes, MB, GB, TB, PB, EB, ZB, YB, BB, GeopBytes) by jnelson

(UPDATE: This article has been updated HERE based on some performance testing I conducted) By far, the most popular article I've ever written is THIS...

Calculate a client's subnet mask when defining subnet boundaries (using BITWISE AND "&" in SQL) by jnelson

OVERVIEW I was recently pointed to Jeff Gilbert's blog where he has an article on determining a client's subnet mask and using them in subnet boundaries...

WQL - Using the bracket wildcard to match a range of version numbers (MNSCUG) by jnelson

At the Minneapolis area System Center User Group meeting last night, I mentioned the notion of using LIKE and the bracket wildcard [] to match a range...

SMS 2003 - Query to pull logged on user records from all sources by jnelson

I was trolling the forums lately on MyITForm.com and was reading some conversations about logged on user records. It made me think of all the sources where...
Filed under: , ,

SQL/WQL Tip - How to escape special SQL/WQL wildcard characters like % _ by jnelson

THE PROBLEM You've written a SQL query or a WQL query (like an SMS/CM collection query) and you need to look for a string that has a percent % or underscore...

UPDATE - SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

I previously wrote an article talking about the slowness we were having even after applying 939872 --> HERE There are some additional things I'd...

SMS 2003 - Selecting from v_Add_Remove_Programs still slow, even after applying 939872 by jnelson

!!!! UPDATE !!!! WHEN YOU'RE DONE, THIS ARTICLE HAS BEEN UPDATED --> HERE PROBLEM I don't know if this is a function of the massive size of...

SMS - #2's #1 suggestion - Learn to read/write WQL/SQL by hand by jnelson

My #1 suggestion after years of working with SMS/SQL/WQL and then coaching/mentoring/training people is that it REEEALLLY pays to know how to read/write...
More Posts Next page »
Copyright - www.myITforum.com, Inc. - 2010 All Rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems