SQL Saturday #312 – Sacramento, CA

SQL Saturday #312 will be held July 12, 2014 in Sacramento CA, our third annual event.  I’ve chosen to join my Sacramento SQL Server user group board members and participate in a “lightning talk”, outlining a how to grant permissions to users through the signing of stored procedures.  It’s a great topic and can be put into use very easily and quickly, with a good bang for your buck. Mitch Bottel (B|T), Dilip Nayak (T) and Joe Simmons (T) will… Continue reading

T-SQL Tuesday #049: What’re we waitin’ fer?!?!?

Had to channel my inner Mickey for the title of the post…Rocky II is one of the first movies that I remembering seeing as a re-run on cable…but I digress. When I read Robert’s post and subject for this month’s T-SQL Tuesday, my mind immediately went to one of my first experiences with wait stats, as it was a very poignant “ah-HAH!” moment for me.  I was an administrator for several SQL Server instances and had been doing it for a while,… Continue reading

T-SQL Tuesday #047 – The stuff we all get!

My story isn’t so much about quality as it is about quantity. PASS Summit 2011 was my first time attending that most of awesome of events and I was a bright eyed noob.  I had no idea what to expect and was already a bit overwhelmed with travel accommodations, light rail rides and hotel check-in.  Walking into the Tuesday night welcome reception did nothing to ease the nerves. At the reception was my first “score”, a blue umbrella.  After the reception… Continue reading

SQL Saturday #190 – B-I-N-G-O spells “murder”

When an event like SQL Saturday #190 in Denver is announced, people listen.  Speakers such as Steve Jones (B|T), Wendy Pastrick (B|T), Tim Ford (B|T) and Tim Mitchell (B|T) draw crowds.  When I found out that I was chosen to speak, I was ecstatic. My topic was boring ol’ SQL Server encryption but I decided to try and spice it up with a variation of “buzzword” Bingo.  I created a 3×3 playing card with phrases and pieces of code from the… Continue reading

Find SQL Server services running on a remote server using Powershell

You’re given a list of Windows servers and told they host multiple SQL Server instances.  How do you find which services are running?  Use Powershell:   get-service mssql* -computername myServer   It will give a nice list of services that have MSSQL at the beginning of their names: Status Name DisplayName Running MSSQL$INSTANCE2 SQL Server(INSTANCE2) Running MSSQLSERVER SQL Server(MSSQLSERVER) Stopped MSSQLServerADHe… SQL Server Active Directory Helper Stopped MSSQLServerADHe… SQL Active Directory Helper Service A shorter version: gsv mssql* -cn myServer

SQL Saturday #190 – Dude, where’s my keys???

This weekend marks my first time attending a SQL Saturday outside of my home state of California.  It also marks my second presentation opportunity at a SQL Saturday.  Come see “SQL Server encryption 3 ways – in transit, at rest and in the database” in Denver, CO at SQL Saturday #190. I’ve given this talk a few times already but am going to put a new spin on this one: buzzword bingo. You may remember the IBM commercial where the… Continue reading

T-SQL Tuesday #046 – Rube Goldberg in order to SQL Server

My first T-SQL Tuesday post and am I excited!  My story is going to vary slightly from the original subject in that I’m going to outline a Goldberg machine that was created in order to CONNECT to SQL Server, showing how much my former employer valued the Microsoft database.  Thanks to Rick Krueger (@DataOgre|B) for a great way to tell some fun IT stories. MPE – IMAGE/SQL Flash back to the ’80s where a young man creates a general ledger accounting… Continue reading

SQL Saturday #222 – Another successful endeavor

The second annual SQL Saturday held in Sacramento was another smashing success! With an updated venue and an international speaker list, attendees were given a full day of FREE training in everything SQL Server. Enabled by our sponsors’ generosity, the Sacramento SQL Server users group was able to host a fantastic event. Led by our user group president Mitch Bottel (B|T), the planning committee took the success of year one and began to navigate through the planning process, beginning in… Continue reading

Running .sql files from within the Query Editor using SQLCMD mode

As a DBA, I have a plethora of queries that I run on a consistent basis, commands that give me information about who’s connected to the instance, how mirroring is performing, what types of permissions a user has, etc.  Early in my career I began cataloging these queries.  My first file was called ‘useful_sql.txt’ (I still have it to this day) and it grew longer with each learned action.  I’d open up SSMS, click the folder icon to open the… Continue reading

SQL Saturday #222 coming to Sacramento CA on July 27, 2013

The Sacramento SQL Server users group is happy to announce the second annual SQL Saturday in Sacramento to be held on July 27, 2013.  Our schedule boasts five tracks with six sessions in each track, adding up to 30 speakers coming from all parts of the globe.  We will be well represented with local talent, filling 20% of the speaking duties.  In addition to the all-star lineup on Saturday, Kalen Delaney (@sqlqueen) will be doing a pre-conference workshop on Friday, July… Continue reading