SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2009

SQL Logins For Windows Domain Accounts Limited To Pre-Windows 2000 Format

You may have noticed that when you create a login on a SQL server that's mapped to a Windows domain account you have to use the pre-Windows 2000 format [domain\login]. Did you also notice that there's a limitation of 20 characters on the login portion of this format?

Let's pretend… Read more

0 comments, 616 reads

Posted in Kendal Van Dyke on 28 July 2009

PASS Bylaws Updated

Bill Graziano just made the announcement about the changes to the bylaws being published. No sweeping changes, for the most part intended to clarify things. The remaining document that is still in progress is defining who can vote – a challenge to solve with free members and concerns about how… Read more

1 comments, 526 reads

Posted in SQLAndy on 28 July 2009

Active August - Are You Onboard?

Thanks to Mike Walsh for really getting this started. Active August is similar to Fit February where folks endeavor to make changes in their lifestyle to get in better shape. I didn't join in on the Fit February but I do plan on getting on board for Active August.… Read more

Are you looking at virtualizing SQL Servers?

I wrote an editorial for today on virtualization and some hints about how to plan a project. However I wonder if more people are actually thinking of implementing virtual servers. Drop a note in the comments below.

I have friends that have successfully virtualized SQL Servers in production, and I… Read more

4 comments, 572 reads

Posted in The Voice of the DBA on 28 July 2009

Why Make Up Test Data? Snag Some Government Data

… and by government data, I mean the mountain of data recently made available by the G-Men on Data.gov.  This site contains what must be terabytes of data on every topic from environmental measurements to crime statistics, from geographical data to labor statistics.  The Obama administration has committed to greater… Read more

3 comments, 1,275 reads

Posted in Tim Mitchell on 28 July 2009

eReaders - Barnes and Noble Application

I downloaded the Barnes and Noble eReader application the day I heard about it and synced up my iTouch immediately. I was curious to see how it compared to the Kindle application, especially across devices.

The install from iTunes is seemless. I "purchased" it from the app store (it's free)… Read more

1 comments, 930 reads

Posted in The Voice of the DBA on 28 July 2009

Closing Down SQLGroups.com

We (Brian, Steve, and I) provided hosting for SQL chapters going way back…maybe 2002 or 2003, on behalf of PASS. When we sold our interest in SQLServerCentral.com to Red Gate we had to move them off the SSC domain, and we just grabbed SQLGroups.com. We didn’t do much with it… Read more

1 comments, 503 reads

Posted in SQLAndy on 27 July 2009

SQLSaturday #16 South Florida

I'm giving a presentation at SQLSaturday in South Florida on August 8th 2009. If you haven't been to a SQLSaturday, they're free one-day events put on by local SQLPASS chapters. As an added bonus there will be two PowerShell sessions:
PowerShell MVP and prolific presentor, Max Trindad will be presenting…

Read more

0 comments, 424 reads

Posted in Chad Miller on 27 July 2009

Interested In *Free* SQL Training? Attend A SQL Saturday Near You!

Can't make the PASS summit? Or maybe you're going but looking for something whet your appetite between now and November. How about attending one of these SQL Saturday events happening soon?

Read more

0 comments, 715 reads

Posted in Kendal Van Dyke on 27 July 2009

I'm Certified, Now What?

I saw an article from Certification Magazine recently (via Trainsignal on twitter) with that title. It compared the completion of certification to that of a marathon runner. You've completed a marathon, after all the training, and now what?

I'm not sure that's a great comparison, but it does… Read more

7 comments, 1,838 reads

Posted in The Voice of the DBA on 27 July 2009

Call for Nominations – PASS Board of Directors

Sometime in the next couple weeks will mark the beginning of the 30 day period where we accept nominations for the PASS Board of Directors, see www.sqlpass.org for the details. I thought I’d write just a little bit about what it’s like to be on the Board, what qualities I think… Read more

18 comments, 942 reads

Posted in SQLAndy on 26 July 2009

Possible SQLSaturday in Tallahassee on Sep 5, 2009

Steve Lane and team from Tallahassee are hosting their annual Code Camp on Sep 5, 2009, and have asked if we could also run a SQLSaturday at the same time, probably a 1-2 track event. There is not currently a SQL user group in Tallahassee which makes it an interesting… Read more

2 comments, 613 reads

Posted in SQLAndy on 26 July 2009

Building PowerShell GUIs with Primal Forms

Although PowerShell is best suited for console applications there are times when a GUI interface just makes sense, however hand cranking PowerShell code to display a GUI seems almost anti-productive when we are used to rich IDE's with WYSIWIG development available in other programming languages. Fortunately there are several 3rd…

Read more

0 comments, 2,616 reads

Posted in Chad Miller on 25 July 2009

The effects of DISTINCT in a SQL query

Earlier today, I had a great Twitter conversation with Tim Mitchell (@Tim_Mitchell), Jorge Segarra (@SQLChicken), and Jack Corbett (@unclebiguns) about the use of DISTINCT in a SQL Server query. By the way, this is yet another example of how Twitter can be used in…

Read more

0 comments, 879 reads

Posted in Joe Webb on 24 July 2009

Learning some javascript

As part of my work I need to be a “Jack of all trades” meaning I not only need to be able to do SQL Server DBA and development tasks, but I also need to be capable of doing .NET and VFP development.  Yes, I did say VFP (Visual FoxPro… Read more

0 comments, 604 reads

Posted in Wise Man or Wise Guy on 24 July 2009

Attache/Brief Case Review

Steve Jones, through a series of comments, emails, blackmail, back-alley deals & tons of whining, agreed to let me review a brief case, the Maxpedition Hard Use Gear Aggressor Attache. The review is up over at SQL Server Central and a video I made of the bag should be…

Read more

0 comments, 526 reads

Posted in The Scary DBA on 24 July 2009

SQL Server Powershell Extensions PowerGUI PowerPack

If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is a free utility provided by Quest. It's both a script editor with PowerShell syntax highlighting and GUI builder for PowerShell scripts. The editor is a very usable standalone…

Read more

0 comments, 1,005 reads

Posted in Chad Miller on 24 July 2009

HTTP 404 Not Found with Reporting Services and Windows 7

Here are some steps to fixing an issue I ran into with Window 7 and Reporting Services 2008.  The problem was when I attempted to access the Report Server or Report Manager from my browser I received the error HTTP 404 Not Found.  I didn’t find a direct answer on… Read more

8 comments, 15,692 reads

Posted in Devin Knight on 24 July 2009

Changing Startup News Feed in Visual Studio

Are you tired of the same old Microsoft news feed when you open Visual Studio (BIDS)?  Why not go ahead and update it so you every time you load VS you get news that you’re actually interested in.  I’ve changed my news feed to display all the SQL Server Central… Read more

0 comments, 687 reads

Posted in Devin Knight on 24 July 2009

Kindle Update - The iPhone App

I have an iTouch, and I recently downloaded the Kindle app to give it a try after I broke my Kindle device. It was kind of a knee jerk reaction since I was in the middle of Team of Rivals, War and Peace, and Wicked Prey at the time. My… Read more

2 comments, 1,151 reads

Posted in The Voice of the DBA on 24 July 2009

Newer posts

Older posts