RSS

Monthly Archives: July 2012

SQL Server 2012 New Feature – The Sequence Object

SQL Server 2012 New Feature – The Sequence Object

One of the cool new features with SQL 2012 is the Sequence Object.  One of the worst parts of this feature is that whenever I mention it’s a cool new feature a lot of people say “that has been in Oracle forever.” Patience is a virtue!!

Anyway, so I like to consider the Sequence Object as a “Global Identity” that can be shared by many objects in the same database, or even across databases on the same server (I have not tried it via Linked Servers because I only have one test SQL 2012 server). You can take values from the Sequence Object and insert them into tables or you can have a column in a table default to a value from the Sequence Object. A warning to the wise: If you assign a default value for the table as a Sequence Object then you cannot drop it because of dependencies. That is actually a pretty good security measure.

I have included a code snippet so that you can play around with this new feature and I’ve put a few screen shots to show how you can manage it via the GUI. Make sure you run the code section by section; I have included a lot of comments to let you know what to expect while running it.

Read the rest of this entry »

 

Tags: , , ,

Deploying a SQL Server 2012 Multi-Subnet Cluster


Excellent write up on how to deploy a SQL Server 2012 Multi-SubNet Cluster (GeoCluster).

- Microsoft technologies and what I do for fun -

I’ve been wanting to write a series of articles on deploying a SQL Server 2012 on a multi-subnet cluster for quite some time now. This was driven by the fact that my series of articles on SQL Server 2008 Failover Clustering had been in the Top 10 Tips for more than 2 years since being published three years ago. I guess more and more systems administrators and SQL Server DBAs are being tasked with deploying failover cluster instances. Ever since I had my hands on the beta version of Denali (codename for SQL Server 2012) last year,  I’ve been testing some configurations for the multi-subnet clustering feature. I think I’ve built like 3 test environments prior to Denali going RTM just so I can wrap my head around the concepts (plus the fact that Windows Clustering Experts like Microsoft MVP Allan Hirt (blog | Twitter) have been gracious…

View original post 107 more words

 

Tags: , ,

Open Heart Surgery Lessons Learned for IT Part 4 – Learning Beyond the Job Title

Open Heart Surgery Lessons Learned for IT Part 4 – Learning Beyond the Job Title

Finally we have come full circle to the final post on this lessons learned segment. In case you have not been reading the news lately, the healthcare market is booming especially with those that are lucky enough to be in the IT field.  It is a big industry here in the U.S. and will continue to grow.

As IT workers we need to step up to the challenge and not stop where our job title does. Being a developer, programmer, DBA, QA Tester, or whatever you may be is not an invitation to ignore the business side of things. Rather, as IT practitioners we should strive to understand and seek purpose in what we are doing. We also need to be innovative and find new solutions to existing problems as well as increase our skills sets and learn new technologies when possible. A career is a life long learning process, it’s not just about getting the job you want and sitting at your desk doing the same thing over and over and claiming it as gained experience. One of my good colleagues told me the other day “doing something for twenty years doesn’t mean you have twenty years experience, maybe you did the same thing 200 times!”

As you can see, the entire experience for me was a learning experience beyond the job title yet it helps me perform better at my work because I understand more about the data that I am working with.

Read the rest of this entry »

 
Leave a comment

Posted by on July 19, 2012 in Other

 

Open Heart Surgery Lessons Learned for IT Part 3 – Monitoring Health and Disaster Recovery

Open Heart Surgery Lessons Learned for IT Part 3 – Monitoring Health and Disaster Recovery

One of the biggest issues we have in health is poor monitoring.  This is also the case in health of many of our systems.  As a DBA, I’m always concerned about the health of my database servers; mainly because I would like to keep my job and not get the 3am call that something has gone terribly wrong. However, with that said, no matter how careful we are there is always the probability of something bad going wrong.

This is part three of my lessons learned and will have more of a focus on Database monitoring and Disaster recovery.

Read the rest of this entry »

 

Tags: , , ,

Open Heart Surgery Lessons Learned for IT Part 2 – Standards and Quality Control

Open Heart Surgery Lessons Learned for IT Part 2 – Standards and Quality Control

Welcome back to part two of my series on Lessons Learned. This time I want to talk about quality control.  Everyone knows that it is tough to become a surgeon. It is not that there is a height, weight, race, or whatever else requirement. Rather, there specific qualities and knowledge that are needed of doctors to be able to get a license to practice.  This is one way how standards and quality control is established in the medical field. Now to make it more specific to my experience.

Read the rest of this entry »

 
Leave a comment

Posted by on July 17, 2012 in Other

 

Open Heart Surgery Lessons Learned for IT Part 1 – Collaboration and Agility

Open Heart Surgery Lessons Learned for IT Part 1 – Collaboration and Agility

Last Friday (July 13, 2012) I got to see open heart surgery.  It is technically called Coronary Artery Bypass Grafting (CABG) and it was a triple bypass; which means that three coronary arteries were by passed due to blockage.  As a SQL Developer and DBA at the American College of Cardiology I felt like this would be an excellent opportunity to learn about the data I am responsible for collecting and protecting. I learned a lot, and although this post isn’t going to be very technical it’s still something every DBA, Developer, or anyone who works in IT might learn a little from. Of course I will be giving it a DBA twist to keep it in line with the purpose of this blog 🙂

So let me break down some of the things I observed and relate them to how things work in IT or how we can use some of these strategies day to day to make our jobs better. I will separate the posts across the next three days so that people don’t get bored reading one long post.  This is the first of four parts, enjoy.

Read the rest of this entry »

 
Leave a comment

Posted by on July 16, 2012 in Other

 
 
%d bloggers like this: