Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and noticed that there are no slides mentioning the upcoming Board of Directors elections. I'm surprised because the elections are a great discussion topic for people who might not otherwise be… Read more
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS). Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working with them have been introduced and each has caveats to… Read more
The session lineup for the 2014 PASS Summit was announced today and I'm honored to be selected as a presenter. This will be my 6th year at the Summit and 5th as a presenter, and every year it's tougher to be picked as the PASS community - and the number… Read more
The 2014 PASS election cycle begins today when voting opens for the Nomination Committee (NomCom) and I'm one of eleven candidates running for three seats on the committee.
Why am I running for the NomCom?
- It's a chance to use my time and experience to do something good for PASS.…
I suspect most DBAs have a script in their T-SQL toolbelt which scripts out database permissions for a specific user (or all users). I do, too, and for years I've used it and always assumed it did the job - until recently when I found that permissions on a certificate… Read more
Tablediff is a command line utility that comes with SQL Server to compare the data and schema in two tables for differences and generate a T-SQL script to synchronize them. It's a rudimentary but useful tool that most people don't know is available and it gets the job done when… Read more
Windows 8.1 was released to the Windows Store last week and aside from having to download the same 3.9 GB update on each machine I've installed it on it's been a relatively easy and smooth update. I did, however, run into one small problem related to Oracle VirtualBox. When… Read more
I'm at the 2013 PASS Summit in Charlotte, NC, this week, and presented a session about documenting your databases using SQL Power Doc. I'm blown away that it's been downloaded over 3,000 times since version 1.0 and have received some really great feedback from people using it in their… Read more
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the 2013 PASS Summit. This year I'm excited to be co-hosting two "Get To Know Your Community" sessions with my friend Kevin Kline (Blog | @kekline) on Tuesday afternoon Read more
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic. This month marks #41, hosted by me!...and the theme is showing off my best SQL Server SWAG (Stuff We All Get!).
I love SWAG. I admit it. When… Read more
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit is just around the corner, SQLintersection at the end of the month, and SQL Server Live! in November...and that's not including all the SQLSaturdays happening every weekend as well. Read more
Another PASS Board of Directors election cycle has come and gone, and with the results now announced I'd like to congratulate the winners ...except I can't - not yet, anyways, because the elections have been tainted by the possibility of duplicate votes affecting the outcome.
On Saturday, Sept 28,… Read more
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of time and distribute them at the speaker appreciation gathering before the main event. The current iteration of the admin tools makes that an arduous task (at best) – eating… Read more
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's tomorrow!), the FREE 24 Hours of PASS: 2013 Summit Preview Edition begins. That's 24 straight hours of sessions at no cost from folks who have been selected to present… Read more
A quick note to let you know that SQL Power Doc version 220.127.116.11 is now live. This release fixes issues reported since version 1.0, adds 11 new assessment checks, and improves error handling in multiple places. The nitty-gritty details of what's changed are available in the changelog.
You can… Read more
We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on your hands and decided that today's the day you're going to get it done. You might open SSMS, connect to a server in Object explorer, start clicking around, and copying… Read more
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic. This month marks #41, hosted by Bob Pusateri (@SQLBob), and the theme is how I came to love presenting.
Presenting Changed My Life
My story starts in early… Read more
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic. This month marks #39, hosted by Wayne Sheffield (@DBAWayne), and the theme is "Can You Shell What The PoSh Is Cooking?"
For many years I made learning… Read more
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have found a permanent home in my "useful scripts" toolbox. I've provided these scripts as downloads whenever I've presented about replication...but not everyone who has worked with replication has been to… Read more
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic. This month marks #36, hosted by Chris Yates (@YatesSQL), and the theme is "SQL Community". This post is not mine, but the handiwork of Andy Levy (@ALevyInROC Read more