SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: September 2012

Using a TVP instead of Dynamic SQL to pass a list into a SP

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

2 comments, 1,076 reads

Posted in SQLStudies on 25 September 2012

Master Data Services: Resources

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

1 comments, 2,345 reads

Posted in James Serra's Blog on 25 September 2012

SQL In The City: Austin

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

0 comments, 962 reads

Posted in SQL Man of Mystery on 25 September 2012

SQL Server Virtualization in Sweden

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 

Read more

0 comments, 615 reads

Posted in The SQL DBA in the UK on 25 September 2012

SQL Server || Change Batch separator

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

0 comments, 1,154 reads

Posted in MSSQLFUN on 25 September 2012

The State of Microsoft Self-Service Reporting

(article published on the MVP Award Program Blog) I really enjoy this topic.  One of the reasons, I suppose, it’s such a hot topic is that a lot of people believe that there is a perfect ad hoc reporting solution out there, just barely beyond the current set of capabilities…

Read more

5 comments, 2,669 reads

Posted in SQL Server BI Blog on 25 September 2012

SQL Server: Part 3 : Approaching Database Server Performance Issue

In the last post, we have discussed the script to list the sessions which are waiting for resource or currently running. In this post let us see how to list the blocking sessions with required information.  

CREATE FUNCTION [dbo].dba_GetStatementForSpid
   @spid SMALLINT  

Read more

15 comments, 1,067 reads

Posted in PracticalSQLDba on 24 September 2012

Interviewing a DBA

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

10 comments, 3,165 reads

Posted in The Scary DBA on 24 September 2012

TechEd Australia 2012 videos online

Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free!  Get your learning cap on.  Check them out here.

Read more

0 comments, 745 reads

Posted in James Serra's Blog on 24 September 2012

@LearningTree: Unlimited Passport

Its not often I publish two blog posts in a single day but this Monday I will make an exception. Late last week I was made aware of a great Learning Tree offer – an unlimted passport that you can purchase that will give you access to an unlimited number of training…

Read more

0 comments, 900 reads

Posted in The SQL DBA in the UK on 24 September 2012

Last Call To Register for SQLSaturday Orlando

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

0 comments, 608 reads

Posted in SQLAndy on 24 September 2012

SQL Server Virtualization and Consolidation

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

6 comments, 627 reads

Posted in The SQL DBA in the UK on 24 September 2012

The Reason I Won't Be at the PASS Summit This Year

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,425 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 24 September 2012

DMV Emergency Room!

I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 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

3 comments, 1,091 reads

Posted in Glenn Berry's SQL Server Performance on 23 September 2012

Notes from the 2012 Tampa IT Pro Camp & Some Misc Thoughts

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

0 comments, 616 reads

Posted in SQLAndy on 23 September 2012

Congrats to Jeff Walker for passing the VMware VCP5 exam

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

1 comments, 572 reads

Posted in Technobabble by Klee from @kleegeek on 23 September 2012

Welcome to Everday SQL

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

Read more

0 comments, 304 reads

Posted in Everyday SQL on 22 September 2012

2012 Fall & Winter Conference Sessions

Fall is a busy time for speaking engagements which include user groups, SQL Saturdays and the PASS Global Summit. I'm speaking at a number of events and as the schedules are confirmed, I'll update this list and upload or provide links to presentations and demo content. I hope you can…

Read more

0 comments, 682 reads

Posted in SQL Server BI Blog on 22 September 2012

Connection String from Visual Studio

Querying Microsoft SQL Server : Connection String from Visual Studio: Connection String: A connection string contains connection information need to connect with data source.You can connect your project with ...

Read more

0 comments, 772 reads

Posted in Querying Microsoft SQL Server on 22 September 2012

VMware vSphere 5.1 vCenter Data Protection Funny

VMware, why won’t you allow special characters in your root password?

Read more

0 comments, 534 reads

Posted in Technobabble by Klee from @kleegeek on 22 September 2012

Newer posts

Older posts