Archive for the ‘SQLServerPedia Syndication’ Category

I’m Calling You Out

Posted: November 12, 2012 in SQLServerPedia Syndication

I just came back from Starbucks… I pulled up to the window, and the barista smiled at me, and it was not because of my incredibly good looks. She announced in a loud commanding voice… The guy behind you said, “Buy the Marine a drink”. My brain was filled with all the stuff I have to do today, and that guy made my day. I wish I had more time to put this post together. Expect a better organized one from me next year. But here is what I am thinking…

Many people say they support the troops, so many people show the kindness. But they put their life on the line for you, for you to vote, for you to have the ability to sleep safe at night, the ability for you to have and share your own opinions without the fear of repercussions. So today I am calling each and every one of you out. If you see a Vet, buy them a drink. Coffee, beer or lunch, it does not matter. Help a stranger feel the way that someone just made me feel. I would love to see comments on this blog, or tweets with the hash tag #TYVet. Let’s show the world we are not just a military, not just a government and policies but we are a country, and we support those who support us.

This is not a political statement, this is a chance to stop talking, and take a chance to Thank a Vet.

Welcome to the 2012 PASS Summit.

So you made it, and you may have even gone to the Frist Timers meeting, or you might not even be a first timer (no matter how long you have been here, what suggestions do you have). Now that you are here, make sure you make the most of your time.

Bring business cards…

Hand them out, and make sure you ask for them. Take it one step further, bring a pen. As soon as you walk away from meeting someone new, jot some notes on the back of the card. There are so many people to meet that notes can help you remember who they are.

Read what others have said, these are just a few I grabbed really quick

http://www.mssqlgirl.com/first-timer-experience-at-pass-summit-2011.html

http://wcompute.org/2012/01/22/first-time-pass-summit-2011-attendee-so-how-was-my-experience/

http://markvsql.com/2011/10/pass-summit-2011-top-ten-list/

http://professionaldevelopment.sqlpass.org/Blog/entryid/393/Summit-First-Timer-Follow-Up.aspx

http://clarkcreations.net/blog/2011/11/14/post-sqlpass/?utm_source=dlvr.it&utm_medium=twitter

Twitter

Really? Do we really need to talk about why? It is so cool to have this community. Follow #SQLPASS

Meeting People

Pick  just a few names out of the people that you want to meet, speakers or authors and even Microsoft guys and Gals. Force yourself to go shake their hand, I challenge you to not just go meet them, but tell them why they are on your list. There is so much work that goes into speaking, writing and well it is not very often that as a presenter, or as an author has the honor of knowing what we did to help individuals. I can tell you that the people who have shared with me how I helped them encourage me, and motivate me to do more. Tonight someone mentioned they went to a session I did a while back, and the applied what they had learned in one of my sessions and their salary increased because of it. The way he told me about it was, hey… you made me $14,000.00.

Most speakers have hobbies or interests outside of SQL Server. This is a great way to talk with people that you may feel odd going up to and talking with, watch what people tweet about that is outside SQL Server. Do you have something in common, and if so use that as a way to strike up a discussion. You can always ask me about my friend, sparky…

If we have meet in the years past, and I don’t remember your name I am so sorry. It does not indicate that I didn’t enjoy talking to you, but I do try to meet as many people as I can and well I never was really good about matching names and faces. But if you remind me of past discussion I bet I will recall.

The More you Put Into It

The more you will get out of it. Get involved, and step out of your comfort zone. Is it scary? Yes it is, I was a first timer once, and I was nervous about many of the things you may be. I still am… But today I bought a Kilt and I even went out a cut a rug a little, very little but I did it. Will stepping out of your comfort zone always turn into a great experience, maybe I can’t tell you, but you won’t know until you try.

Stop taking notes

Go ahead give it a try. OK maybe this is a little drastic, take very few notes. The idea I am trying to pass along is that there is so much more to most topics than what will fit into the time slots. Chances are if you are going to move a new technology into production and you are using the conference to give you a little information on it, then you are going to be doing some more research before you roll it out. If this is the case, is your time better spent focusing on the speaker and what the talking points, or is it better to take as many detailed notes as you can? Don’t miss the big picture because you are so focused on making detailed notes.

PASS TV

Posted: October 30, 2012 in Events, SQLServerPedia Syndication

Have you seen PASS TV yet?

It is a YouTube channel that has a lot of really great information on it. I recommend you check it out.

This year, I have the honor of presenting a session from the 2012 PASS Summit that will have a live stream to the channel if I understand it correctly. One of the reasons that I am so excited about this opportunity is because I know there are a lot of SQL Server Professionals that really wanted to be at the Summit this year, but for one reason or another are not able to make it. PASS TV gives those people the opportunity to get touch of what is going on at the event.

At the same time there are many people looking at becoming a SQL Server Professional and this might help them see how we as a community support each other and the value of coming to the Summit. As I get more information on how this is going to be played over the internet, I will be sure to pass it along to you.

As of now, here is the information that I have, I know there are other sessions that will be on PASS TV, but I am unable to find a schedule just yet.

My session is going to be Thursday, November 8th 4:25 PM PST to 5:00 PM PST

I believe the feed will be located here – http://www.sqlpass.org/summit/2012/

And the Session that I will be presenting on is “The Not SQL skills you need

The motivation behind this topic comes from my years of studying how to be a better DBA. I always thought the skills I needed would all be in SQL Server, such as working with the language, or maintenance of servers. What I have found to be true is that I spend almost as much time (if not more time) outside of SQL Server completing tasks that will lead to work in SQL Server. In other words I have spent a lot of time learning how to do what I want with SQL Server, and not enough time in learning how to manage what I need to get done in SQL Server.

Right now I plan on the discussion to be focused on technical and non-technical Skills that SQL Server Professionals need. Skills like:

  • How to market yourself
  • Why you should get involved in networking and social community
  • Tools that make life easier that you might want to consider using
  • Technology areas that you might want to focus on

I hope to see you there at the Summit, but if I can’t… I hope you have the time to check out this session.

— I have updated the live feed link.

Big Data?

Posted: October 24, 2012 in Career, SQLServerPedia Syndication

This time of the year, a common question that I am asked not only at User Group Meetings, but over email and such is why I am such a big fan of the PASS Summit and why I believe this is a must attend event for everyone. This year I even have the opportunity to have an answer posted on the TechNet SQL Server Blog, that I think is being posted later this week. There are so many reasons as why to attend PASS, but a big one for me is the opportunity to have visibility into SQL Server features that I haven’t had the opportunity to work with. If you are at all like me, my time researching is spent looking at things that will make my current or known future projects even better. I am not spending time like I should learning about features that don’t impact me today, I would love to but I just don’t have all that time.

One of the really neat things about the PASS summit is the ability to attend sessions, make notes on features that I use for reference at a later date, when that information is more relevant to the projects I am working on. Here is a great example; I am really looking forward to attending this session by David DeWitt. A great speaker with a lot of good information, this session will give me some great insight that I might be able to use in the near future.

Big Data Meets SQL Server [DBA-410-S]

During my “Big Data” keynote at the 2011 PASS conference, I introduced the concept of an “enterprise data manager” – a new class of database systems capable of executing queries against both traditional structured data stored in a relational DBMS and unstructured data stored in HDFS, Hadoop’s distributed file system. In this talk I will describe the progress we have been making on this concept at the Gray Systems Lab. Extending the Query Processor in SQL Server Parallel Data Warehouse by adding a new table distribution type for data stored in HDFS, we give it the ability to query data stored in HDFS without first having to load the data into PDW. By leveraging a database QP, we can perform real optimization – transform selections, projections, aggregates and other operations on HDFS files into MapReduce jobs and execute them on the Hadoop cluster as part of the query execution plan it generates.

So anyway, this is just one other reason why I really believe the PASS Summit is a can’t miss event. I hope to see you there.

The New Book

Posted: October 18, 2012 in dbUtilities, SQLServerPedia Syndication

A number of months ago Oracle Ace Kellyn Pot’Vin (T|B) had talked with me about being an Author to an upcoming book about SQL Server Best Practices. After a number of discussions with the editors, and a lot of deliberation on my part on what I should write about I joined the team of authors. I got to tell you that this is a great team of Authors and I honored to be even mentioned in the same discussions as them. Here is the list that I pulled from the Apress site. Bradley Ball , TJay Belt , Glenn Berry , Jes Borland , Carlos Bossy , Louis Davidson , Ben DeBow , Grant Fritchey , Jonathan Gardner , Jeremy Lowell , Jesper Johansen , Wendy Pastrick , Kellyn Pot’vin , Mladen Prajdić , Herve Roggero , Gail Shaw , Jason Strate and then there is me… Chris Shaw.

One of the biggest challenges for me to committing to work on a book is the amount of time that it takes to complete the task. There are a number of authors who can write complete books, and continue with other commitments and still do a great job. For me, I think it is difficult to make sure that the information I am trying to pass along is clear and easy to read. I end up re-writing so many parts of it that I think it takes me much longer than other authors. This is why a book like this is so attractive to me; I get the opportunity to work on one chapter that is focused on something I am passionate about without the stress of many more chapters after that to complete is not looming over me.

So I am proud to announce that the Pro SQL Server 2012 Practices book is complete. If you have pre-ordered it I image it will not be long before you get your copy sent over to you. The book is described as:

“Expert SQL Server Practices 2012 Edition is an anthology of high-end wisdom from a group of accomplished database administrators and developers who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.”

I hope you like it, and I look forward to hearing your comments about it. If you haven’t ordered it yet, I think you can do so on Amazon here. If you like this style of book with many Authors working on topics they are passionate about, I also worked on the SQL Server MVP Deep Dive Vol. 2 book. All the profits of the Deep Dives book are donated to Operation Smile.


 

Nick Haslam (T|B) is hosting the T-SQL Tuesday question for this month. Nick makes a reference to an older Sci-Fi movie that well to be honest, I am not sure I have ever heard of. I will take his word for it, and assume it is a great movie. It must be a good movie if it got him thinking about the question that has been prompted to us for the month. This month’s question is:

“So, what I’d like to know is, what is your most horrifying discovery from your work with SQL Server?”

It did not take me long to come up with the answer on this one, sure I have a number of stories about different situations that I have been in with SQL Server, here is a few of the notable ones, before I dive deeper into what I think is the most horrifying.

  • At one point in time in my career, a long, long time ago… I was asked by the CFO of the company that I worked for to grant him direct read access to our client table, rather than him having to use stored procedures for the website. For some reason this made me raise an eyebrow, and well end result was I denied the request. I leaned an important lesson that day, do the right thing even if you know it will be over ruled by someone else, or make you look foolish by not cooperating. The CFO when to the President of the company and requested the same access, the President hurried right over to my office and made sure that I carried out the exact permissions. Well, this is a long story, the end result? 6 months later we found out that the CFO passed the list to his wife, and they formed a company in her name. The new company, then directly solicited our customers. Sometimes I really hate it when I am right.
  • I could tell you about company I worked with that ended up building the server room under the water main. Here in Colorado it is not unheard of that we have these break on occasion, well… it did.
  • One of my first “real jobs”, I was working on tracking down an audible alert one weekend. I called my manager, the guy who set up the hardware and when he got there it determined that it was one of the drives in the RAID 5. He pulled the drive to force a rebuild over to the hot spare, but when the noise didn’t go away he determined he pulled the wrong drive, there was another one that was not flashing green as much as the others so he determined to pull that one as well. He had plenty of space on the RAID so he could lose that potential storage. If you don’t know what happened then I will let you in on a little secret. Don’t pull 2 drives of a RAID 5. Because it will turn into a RAID nothing, and your data goes down. What makes a stupid mistake like this approach the top of my list? Well.. He said, “The only mistake I made here was hiring you”. He had a long outage; I had a long weekend (and a new job within 3 hours), and a learning experience that has impacted me 15 years later. Don’t guess at solutions or problems. Develop an educated theory, confirm it to be true, and then test the solution.

So, what is my number 1?

One of my first clients was with a company who had paid for a consulting firm to come in and do a DR plan for him. The quoted him $500,000 for a system that that could be down a week, and had very few data changes. The data was less than 3 gigs, and rarely changed. He and I developed a backup rotation plan, and a way to get new hardware at the local electronics store, for less than 5k. What makes this just sick to my stomach was during the review of his back up process, I noticed a lot of transaction log backups but not a single full backup. When I asked the client, he mentioned that the company that configured the server, made a full backup, gave him the backup on removable media and then told him all he would need from that point was t-log backups. That was 4 years before I reviewed the system, so I checked and he was spot on, there were close to 14,000 transaction log files sitting on the hard disk. I mentioned it looked like we were missing a few (about 16,000), and if he know where they were. He replied yes, he needed some added space so they had been deleted.

Here is a client who things his system is recoverable and how paid for that service. Yet there was no way I could recover it without all the files, and even if I had them no telling how long it would have taken to restore 35,000 T-Logs. I felt a lot of satisfaction in helping my first client. This was all done remotely and I had a chance to meet him in person a year later. He and his employees thanked me for my help with a card and took me to dinner.

Remote Desktop Manager Product Review

Stating the obvious:

As a SQL Server Professional, I spend most of my time working within SQL Server.

What about the not so obvious:

There are so many aspects to my professional life that have nothing to do with SQL Server, things like email, managing tasks or to-do lists, creating power points, and keeping all my remote connections secure and organized. Think about the large amount of sensitive information that you have to retain to just simply connect to the servers that you need to work on;

  • Server Name (not always as obvious and friendly as you might like)
  • User Accounts
  • Passwords

And those are just for starters. There are service accounts, administrative accounts, dev accounts and the list goes on and on. A couple years ago I found a tool that Microsoft had called the Remote Desktop Connection Manager; this tool allows me to save all my remote connection information, and access it from one place. There are a number of basic functions that make life a lot easier for me, however as I added more and more to it, and wanted it to do just a little bit more I found the tool to be lacking in what I needed it to do. That is how my search started.

Before too long I ran across a product by Devolutions called Remote Desktop Manager. A couple inquiries on twitter were giving me more information than I could ever want. It did not take long for me to be off and running. There are a number of features that I like but some of them make my management of connections so much easier, for me I like the ability to tie into KeePass to save my credentials or I can just save them to my local machine, and the ability to group my connections in folders and sub folders.

The more that I work with the tool, I am finding places where I can store personal information for my own use, or there is the ability to use a central repository where I can share connection information with other people that I am working with. The first question that comes to mind is how secure this is, but there is the ability to set default credentials and then over ride them for Individual users.

The flexibility in how I organize my servers in the User Interface help me find and narrow down what I am looking for quickly, each one of the sessions (connections that I make to a server) that I start, uses saved information such as server name, user account and password all ready to go.

The purpose of this post is to share what I have been using as a tool to help me navigate around the servers and connections that I use when I have so much information to keep track of. This is so much more secure than the many options that I have used or seen used in the past, and the speed to access the information or the servers is incredibly fast and easy.

There is so much more to this tool that I cannot do it justice with a simple product review. After I installed the tool, I was connected to servers using VPN and remote desktop in an organized fashion in just minutes. Remote Desktop Manager was so easy to set up and configure that I was back to working on the many needed task before I could take the time to look at all the features.

Heavy Heart

Posted: September 24, 2012 in Career, News, SQLServerPedia Syndication

About 12 years ago I sat down with a couple of the guys that I work with. We had an in depth discussion about starting a User’s Group in Colorado Springs, I am not sure if we knew how big it would get, or what we really expected. But we knew we wanted to give people who do the same SQL Server work we did the opportunity to learn and share ideas, experience’s and just overall network together. Over the course of time I have been a leader of this group, for all but a year or two, I have been the President and the Vice-President of events, most recently a Co-President. I can tell you I have gotten just as much from the group as I have given it. If you have ever considered starting a group or joining a group I cannot tell you how much I recommend it.

My wife and I have always dreamed of living in our 5th wheel full time. There is nothing like waking up with the deer hanging outside your door when you get up each morning and going to bed each night after I hang out with the Foxes. About 6 months ago, we were able to make this dream come true. The other aspect to our dream is to stop dealing with the snow, and for me the pain that comes along with the snow. As of October 15th this year we will be spending our winters in warmer weather. Seeing that we will be out of state close to 6 months a year, I do not feel like I can contribute as much to the group as voted in board member. I will not be seeking reelection for the Colorado Springs SQL Server Users Group.

Does this mean I won’t be back? No.

Making a decision like this has been really difficult for me, I am so vested in the group but I can rest assured knowing that the current leadership is some of the finest I have ever worked with and I have a lot of hope with the group and the group’s future.

What about being a Regional Mentor?

I have not been doing a very good job on keeping up with posting everything that is going on, here on my blog. I have accepted a role to be one of two RM’s for PASS for Canada. I am really excited about this and many aspects of it are well under way. This will continue, and there is no plan for it not to as we complete our travels.

What is coming my way?

  • In November I will be at the PASS summit, and I think this one is starting to look like this one will be the best yet.
  • In October I will be headed over to the SQL Saturday in Nebraska.

     

As a new chapter starts and an old chapter closes I can’t help but reflect on friends, events and all the great people and things that we have done with the group. There is more to come and I am really looking forward to the new focus and the future.

 

 

 

Another awesome discussion for T-SQL Tuesday, and big thank you to Mike Fal. The question is what sort of tips and tricks you use with SQL Server. The first thing that came to mind for me was how I track the history of Windows cluster failovers. I am not a big fan of having to dive into error logs, events and emails to just find the history of my servers. Recently I ran into a situation where a Clustered SQL Server Install was performing better on one node of the cluster than the other node. I have a history of the performance, but I did not have a quick easy way to look at the history of what node was hosting when. The solution I came up with was to use my dbUtility database to track when a node was hosting. This way, I don’t have to go looking around error logs, or emails looking for any failover events. The solution is quite simple.

First I created a table to host the information that I wanted to track.

Simple enough? Below is a small version of the information that I track.

CREATE Schema CLU

GO

CREATE TABLE [CLU].[ClusterLogging](

[ClusterLoggingID] [int] IDENTITY(1,1) NOT NULL,

    [ClusterName] [sysname] NOT NULL,

    [PrimaryHostName] [sysname] NOT NULL,

    [ReadingDate] [datetime] DEFAULT getdate() NULL,

CONSTRAINT [PK_ClusterLoggingID] PRIMARY KEY CLUSTERED

    ([ClusterLoggingID]))

GO

Once the table and the Schema are there, I created a stored procedure that will check and find out the host is that is currently running. This information can be pulled from the Server Property Function without much difficulty, once I have that information, I checked to see if this is a new host, if it is a new status and log the information if it is new. This is the procedure that I use.

CREATE PROCEDURE CLU.Log_Cluster_Status

AS

Set NOCOUNT ON

DECLARE @PrimaryHostName SYSNAME

DECLARE @ClusterName SYSNAME

DECLARE @CurrentStatusID INT

SET @ClusterName = CAST(SERVERPROPERTY (‘MachineName’) AS SYSNAME)

SET @PrimaryHostName = CAST(SERVERPROPERTY (‘ComputerNamePhysicalNetBIOS’) AS SYSNAME)

— Is this a new entry? If so insert seed.


If Not Exists (Select ClusterName, PrimaryHostName From CLU.ClusterLogging

            WHERE ClusterName like @ClusterName

            AND PrimaryHostName like @PrimaryHostName)

    Begin

        Insert CLU.ClusterLogging (ClusterName, PrimaryHostName)

        VALUES (@ClusterName, @PrimaryHostName)

    END

— What is the ID of the current Status

SET @CurrentStatusID = (Select Max(ClusterLoggingID) From CLU.ClusterLogging

            WHERE Clustername like @ClusterName

            AND PrimaryHostName like @PrimaryHostName)

— Does the current hostname match the most recent status?

If @PrimaryHostName not like (Select PrimaryHostName From CLU.ClusterLogging

            WHERE ClusterLoggingID = @CurrentStatusID)

    Begin

        Insert CLU.ClusterLogging (ClusterName, PrimaryHostName)

        VALUES (@ClusterName, @PrimaryHostName)

    END

GO

All that is left is to schedule the execution of the stored procedure, I imagine it could be triggered as a startup procedure, but I just choose to run it on a schedule basis. I know that the times may be off a little depending on how often I run it however; it gets me in the ball park. Now I know that I can query the CLU.ClusterLogging table in my utility database and I will have a decent idea of what happened and when. Much more efficient than digging through large error logs that only go back so far.

Over the last few months I have been tossing this exact question around. I have been debating posting about it, and I have even talked with a couple people about it.  But today, I saw this blog post on UTest that got my brain churning.  The hesitation that I have had about posting this comes from a couple different thought points, but most of all I am not interested in creating some sort of development methodology war (you would not believe some of the flame wars I have seen just over naming conventions). I want to make sure that I expressed my paradigm, so my statements might be understood correctly.

·      I have only worked in an Agile methodology for a few years, and in one organization.

·      I am not a student of the Agile methodology so what I am seeing just might be a morphed version.

·      My opinions are based on my experience.  I would love to hear what you see with this methodology, and what your opinion is.

·      I am an administrator by practice, I have done development, but not in this methodology. 

·      I am not in the same chain of command as the developers, although we do have a common VP.

What is it?

I debated even including this section, but I felt it fair for everyone to understand how I am seeing the processed used. 

·     Every 2 weeks is a Sprint.

·     Each Sprint is preceded by a meeting where the group looks at the tasks, and determines how long a  task might take, and how high of a priority it is.  At that point they determine if the task is going to be included in that Sprint. People included in this are developers, management and a few other key players.  The visibility is very transparent.

·     Each day at the start of the day a stand up meeting is held.  This is so the resources can talk about what is getting in the way of completing tasks and to update everyone on how well the task progression is going.

·     If a task is going to take longer than 2 weeks, then it is broken up into pieces to fit in measurable smaller tasks.

·     I believe anyone can add items to the task list.  However, just because it is on a task list it does not mean that the task is going to get done.

My View of the Pros

I am really impressed by how fast the developers that work with this are. This group is an outstanding group of very talented developers.  The amount of work that they are able to accomplish and the quality of the work is impressive for organizations twice the size.  The process allows the developers to commit to an amount of time a task is going to complete, and I imagine that with the daily stand-up meetings, they don’t feel Micro-Managed. I have been in roles where each day managers want an accounting of how you spent each minute. For me, this is not a good way to be productive, so I see the daily stand-ups as a true positive. Developers have an input on the priority of tasks.  So if there is a bug in an application, and it is not impacting anyone, they can make sure that the correct priority is set to the fix. My overall impression is that this puts a lot of control in the developer’s hands and I think this is also a good thing.

My View of the Cons

As an administrator, much of my job is getting ready for the future; this could mean that I am looking at information for 2 weeks down the road, or 2 years down the road. Tasks such as forecasting storage requirements, planning for future upgrades, outages and many other tasks of the like.  The other aspect of DBA work is that I am a working on break fix issues, so normally I spend most of my time working issues today or down the road a bit. 

·      If there is a task which requires the assistance of a developer, and they are required to submit a task item for it, I have to wait until the next Sprint. This does not happen often, but it can happen.

·     When a developer might need me for a task item, the time frame is also applied.  This has never really become an issue, but it does go both ways.  If I am in the middle of a big project and it is different than a project they are working on then we might not always be able to commit the same amount of time.

·     One of my biggest concerns working in this methodology is the amount of time before new tasks are reviewed.  If I take a new database design into consideration, there could be a bit of time that needs to be spent on evaluating if I use one method or another. The review method I decided to follow is to take a step back, look at the future plans as I understand them, test potential solutions and then execute on the decisions. Maybe it is just me and my personality, but I look at things from a long term perspective.  It could just be the nature of my work in comparison to the nature of development work.

·     Priorities are set based on what is most important at the time of planning. From first look, why would you not do it any differently?  If you wait until everything is the top priority then isn’t that working in a re-active mode?  For example:

o    If you wait to quit smoking until the Doctor says you have COPD, then isn’t it a bit late?

o    I have a son.  He just finished his first year of college and is well on his way.  When he was younger, and he would have a paper due then we would try to do a little each day, however as other school work would appear, or a friend’s birthday party would come up it was easy to prioritize the paper under something else.  If it was not the pressing issue, it can be done a little later.

·     I am not sure if this is related to the Agile method, or would be just as much of a concern with any shop.  If, as a task submitter, I am not part of the planning meeting, then there is an impression that a “Sales” job needs to be done.  Is this a drastic way to look at it?  Sure – I guess, but end result is that with a number of people reviewing and prioritizing, then many people have to understand the importance of a  what could be a pretty technical discussion. 

Like I mentioned before, these are really just some thoughts,  I wonder if they are just related to the implementation I have seen, or if others see these as well.