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

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, 152 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, 126 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, 238 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, 210 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, 171 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, 282 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, 993 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, 218 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, 288 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, 182 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, 244 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,402 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, 297 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, 619 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,193 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, 264 reads

Posted in Kendal Van Dyke on 6 November 2012

2012 PASS Elections Letter Of Recommendation From Ed Watson

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes a good candidate is support from the community that they wish to represent. During the last 5 years I have connected with people in PASS community from chapter members to… Read more

1 comments, 512 reads

Posted in Kendal Van Dyke on 11 October 2012

2012 PASS Elections Letter Of Recommendation From Stacia Misner

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes a good candidate is support from the community that they wish to represent. During the last 5 years I have connected with people in PASS community from chapter members to… Read more

0 comments, 340 reads

Posted in Kendal Van Dyke on 11 October 2012

2012 PASS Elections Letter Of Recommendation From Jes Borland

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes a good candidate is support from the community that they wish to represent. During the last 5 years I have connected with people in PASS community from chapter members to… Read more

0 comments, 342 reads

Posted in Kendal Van Dyke on 11 October 2012

2012 PASS Elections Letter Of Recommendation From Karen Lopez

I'm a candidate in the 2012 PASS Board of Directors elections and believe that an important part of what makes a good candidate is support from the community that they wish to represent. I've worked hard to connect with people in PASS community from chapter members to speakers and from… Read more

1 comments, 572 reads

Posted in Kendal Van Dyke on 5 October 2012

Older posts