Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!

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

0 comments, 75 reads

Posted in Kendal Van Dyke on 23 September 2014

Presenting At OPASS August 2014 Meeting On 8/28

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

0 comments, 127 reads

Posted in Kendal Van Dyke on 27 August 2014

Thoughts On The 2014 PASS Summit Selections

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

0 comments, 751 reads

Posted in Kendal Van Dyke on 25 June 2014

I'm A Candidate For The 2014 PASS Nomination Committee

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

Read more

0 comments, 160 reads

Posted in Kendal Van Dyke on 3 June 2014

Using sys.objects When Scripting Permissions? You're Missing Something!

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

0 comments, 254 reads

Posted in Kendal Van Dyke on 4 February 2014

How To Get The TableDiff Utility

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

0 comments, 216 reads

Posted in Kendal Van Dyke on 5 December 2013

Windows 8.1 Upgrade Deletes VirtualBox Host-Only Network Adapter

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

0 comments, 325 reads

Posted in Kendal Van Dyke on 22 October 2013

SQL Power Doc Update - Version 1.0.2.1

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

0 comments, 303 reads

Posted in Kendal Van Dyke on 17 October 2013

What Does The PASS Community Mean To You?

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

0 comments, 228 reads

Posted in Kendal Van Dyke on 11 October 2013

T-SQL Tuesday #47: My Best SQL Server SWAG

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

Confession Time

I love SWAG. I admit it. When… Read more

0 comments, 375 reads

Posted in Kendal Van Dyke on 8 October 2013

T-SQL Tuesday #47: Your Best SQL Server SWAG

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

0 comments, 1,084 reads

Posted in Kendal Van Dyke on 3 October 2013

A Tainted PASS Elections

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

0 comments, 306 reads

Posted in Kendal Van Dyke on 2 October 2013

Practical PowerShell: Merge SQLSaturday Speaker SpeedPASSes Into One PDF

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

0 comments, 406 reads

Posted in Kendal Van Dyke on 19 September 2013

24 Hours Of PASS: 2013 Summit Preview Starts In Less Than 24 Hours!

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

0 comments, 234 reads

Posted in Kendal Van Dyke on 30 July 2013

SQL Power Doc Update - Version 1.0.1.0

A quick note to let you know that SQL Power Doc version 1.0.1.0 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

0 comments, 391 reads

Posted in Kendal Van Dyke on 24 April 2013

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

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

13 comments, 2,517 reads

Posted in Kendal Van Dyke on 11 April 2013

T-SQL Tuesday #41 - Presenting Opens Doors

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

1 comments, 349 reads

Posted in Kendal Van Dyke on 9 April 2013

T-SQL Tuesday #39 - Use PowerShell To Copy A Database To Another Instance

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

0 comments, 757 reads

Posted in Kendal Van Dyke on 12 February 2013

Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications

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

4 comments, 1,284 reads

Posted in Kendal Van Dyke on 29 January 2013

T-SQL Tuesday #36 - SQL Community (Guest Post)

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

2 comments, 309 reads

Posted in Kendal Van Dyke on 6 November 2012

Older posts