Tag Archives | Networking

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

This is my first time to participate in the T-SQL Tuesday so take it easy on me. I really do come in peace.

It’s funny to me that this is one of the key things that drove me into the SQL world. I blogged about this last year explaining how I “Cheated on SQL Server”. Things have kept going uphill from that point and there are no regrets, but I don’t guess I will ever go from Jack blogger to Master blogger. Sounds like I should be in a guild or something.

Seeing Argenis Fernandez (Blog | Twitter) post on Leaving DBA-Land it resonates with how I feel about the leaving the SysAdmin world. I’m not sure if you ever really leave it all behind. I find myself needing to know more than ever about storage (like SANs) and how it pertains to SQL. I find myself needing to learn more about networking and the bandwidth that matters when you are discussing how SQL talks to its friends (or enemies).

I hate code by the way, never will I specialize in writing code. I will leave that to other Jacks and Masters because I really don’t want anything to do with it. Some people’s minds just don’t work as well when it comes to that. I’ll just stick with beating you in the 40-yard dash (based off my high school time of course). I tend to gravitate towards the Database Administrator side of things with Performance and Standards. It’s kind of cool to be dogmatic about at least one thing in your career, so master the “art of saying NO” to those developers who want too much access, that way you can sleep at 2am.

What is wild is that while we are always talking about specialization, the DBA certifications are trending more towards the developer (at least they were in 2008). Crap…I don’t want to be a developer. Anyway, hope you have fun getting just a little bit closer to being a Master or Jack of some trade so that you can pay the bills.

Comments { 1 } Posted on March 13, 2012 in Blogging, Networking, SAN, SQL General, SQLServer, SQLServerPedia Syndication, Tech

Why do I have two profiles in Windows?

I hadn’t noticed this until today, but someone asked me why some computers had a profile for user01 and a profile for user01.domain. This got me to scratching my head because it seemed to be a good question for me and I usually dig until I find the answer out. This one wasn’t too hard to come up with, but it’s something that I hadn’t heard verbatim before. If there is already a profile folder with the same name as the user that you are logging on with, it will create the folder as user01.ComputerName or user01.DomainName. I’m still looking for how it decides that or what order it comes in, but that’s enough info to at least know what is happening.

Here’s a quote from wikipedia on user profile creation (windows xp but still seems applicable:
“At first logon, a folder will typically be created under “Documents and Settings” (standard folder on English version of Windows 2000, XP and Windows Server 2003) matching the logon name of the user. Should a folder of that name already exist, the profile-creation process will create a new one, typically named username.computername, on workgroup computers, or username.domainname on Active Directory member computers.”

Other Resources:
Fix a corrupt user profile in Windows 7

Update: Just found out a little more info about the possible order. If anyone has different experiences please post it in the comments.
Dave Patrick suggests the following order:
“On a newly-joined-to-the-domain PC if you logon to the pc first, then to the
domain you would end up with two profiles.
%username%
and
%username%.%userdomain%
Else if you logon to the domain first, then to the pc you would end up with
%username%
and
%username%.%computername%”

Comments { 0 } Posted on April 25, 2011 in Active Directory, Networking, Windows, Windows 7

Move Computer to New OU Using PowerShell

I’m going to assume you have some tool you are using for PowerShell if you are reading this. PowerGUI is the one that I like the best currently. Once you’ve installed that, you research and download the Quest AD cmdlets. You should be set up at this point.

I had run into this issue in the past, albeit learning the hard way when I move “just a few” computers into the wrong OU. So this time I thought I would ask more questions and do more testing before I pulled the trigger. You can find where the journey begin by looking at this Forum Thread over at powergui.org.

To summarize, I wanted to get a list of computers and pipe it into PowerShell to move the computers to a new OU if the name matched exactly. The code that I had used before would move both Computer1 and Computer12. So I decided to ask the experts in the field and through a little trial and error I found a working solution. Here’s how it ended up working.

csv file looks like this:
object,target
computer1,red.bird.net/Red Computers/Big Building/Windows XP SP2 Test Group

PowerShell looks like this:

#take the -WhatIf off when you are ready to actually do it
$csv = Import-Csv C:\ps\PSTextFiles\yourFile.csv
foreach($computer in $csv){
# Display QADComputer for each item in the CSV object
Get-QADComputer -Identity $computer.object | Where-Object {$computer.object -eq $_.name} | Move-QADObject -To $computer.target -WhatIf
}

Dmitry Sotnikov (Blog|Twitter) goes even further to blog about how we should be explicit in what we are asking for.

Poshoholic (Blog|Twitter) mentions the post in his PowerGuide – PowerGUI Weekly News.

Comments { 0 } Posted on April 19, 2011 in Active Directory, Networking, PowerShell

Make Windows 7 find search results for a Mapped Drive

I got this shiny new WDShareSpace 4TB Network Storage System with RAID so that I could pull my files down to it to get organized. I would like to review the device in the future, but for now I want to use it as an example on showing how I was able to fix my problem.

So after I setup the device with a static IP on the network and configured it, I mapped the drive locally on my Windows 7 workstation. Whenever I performed a search, from the start button or from the search bar in windows explorer I could never get results to come up from the mapped drive. I did a little research and found that one option was to make the drive available offline. Obviously, that is a terrible option because I would have stored them on my local drive in the first place if that’s what I wanted to do. After looking at a few more sites, I found a combined solution that worked for me although it isn’t the perfect solution I had hoped for. So here’s what I have done to fix my issue:

  1. Download and install this Microsoft Hotfix (kb228596). Mine needed a reboot.
  2. Open RegEdit, Navigate to HKEY_CURRENT_USER\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\SearchPlatform\Preferences and add a new DWORD Value titled EnableSearchingSlowLibrariesInStartMenu with a binary value of 1. Exit Regedit.
  3. Download and install the Windows Desktop Search: Add-in for Files on Microsoft Networks.

After I performed these three steps, my Windows 7 x64 workstation was returning search results from my mapped drive. I’m working on the indexing part, but I wanted to get this info out here before I forgot.

Sources:
http://www.thewindowsclub.com/how-to-search-un-indexed-libraries-and-network-location-files-from-start-menu-search-box#ixzz1FkVG7ax6
http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/windows-7-wont-index-a-network-drive/a085298d-94d1-45d3-877e-f84df3ae091b

Comments { 2 } Posted on March 7, 2011 in Networking, Windows, Windows 7