Archives: September 2012
A couple of days ago I read Steve Jones’ blog on creating a user defined table type. This reminded me that I had just recently been reading about TVPs (Table Valued Parameters) which require user defined table types. Steve wondered about how useful the concept of user defined table… Read more
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful add-ons for SQL Server Master Data Services, including utilities for generating an MDS model, loading the model, writing a custom UI for model data and integrating the model… Read more
So, No SQL Saturday in Austin This Year.
I know a lot of folks were disappointed that we (POSSE) weren’t able to pull together in time for a SQL Saturday in Austin this year. We are shooting for a spring date and I’ll be posting more about that in the… Read more
Another date has been added to my schedule for the delivery of 2109 SQL Server Virtualization and Consolidation. Come and join me in Stockholm for this three day course starting 9th January 2013. Start the new year with some great SQL Server training
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is a keyword or command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code.
Customizing Changing the Batch separator in SSMS
Steps to customize the batch separator… Read more
CREATE FUNCTION [dbo].dba_GetStatementForSpid
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order to immediately eliminate the completely unqualified applicants. Even those types of questions, in my opinion, need to be focused on concepts and not syntax. The reason we have the Books… Read more
This coming Saturday (September 29th) we’ll be having our sixth annual SQLSaturday at Seminole State College (our site partner since the beginning) with 7 great tracks of free learning. Pay the lunch fee of $10 and you’ll get a knock your socks off BBQ lunch plated up by the speakers,… Read more
December this year will be a great month for me. I am scheduled to deliver my new Learning Tree course 2109 SQL Server Virtualization and consolidation Hands-On in both New York and London this December and I’m very much looking forward to both events.
This course runs in New York… Read more
We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier than expected, but mom and baby are both doing fine. Her siblings are ecstatic, especially her oldest sister (now 7 years old). With her birth, the balance of power has… Read more
7 comments, 1,215 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 September 2012
I had a nice, full room with about 40-50 people, which is pretty good for a local event. I want to thank the organizers and volunteers for putting together a very… Read more
I drove down Saturday morning to do a beginner presentation on SQL Security. Event was hosted at Rasmussen College, great venue. Good rooms, good parking, easy access, I think the two challenges with the site are the hallways aren’t big enough to put the sponsors there, so they had to… Read more
Jeff Walker (blog), a great coworker of mine at House of Brick Technologies, passed the VMware Certified Professional for vSphere 5 (VCP5) exam this past week. Jeff, congratulations! You have gone from a zero experience on VMware to very good in less than a year. We have… Read more
My name is Patrick Keisler and I have been a Microsoft SQL Server DBA for over 12 years. During that time I have been working for Wells Fargo Securities. I have gained considerable knowledge over this time in various production support duties, including performance tuning, database design, database maintenance, monitoring,…