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

Archives: June 2014

SQL Saturday #316, MVP’s, MCMs and a baby.

G’Day,

Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).

We learnt a lot from running our first SQL Saturday back in August 2013 – which was SQL Saturday #252

For the second year in a row we hosted… Read more

1 comments, 1,137 reads

Posted in measure twice, cut once. on 27 June 2014

Deck & Demo's Live & Thank You AZSSUG & OPASS!

Hello Dear Reader!  Just a quick post to say Thank You to the Arizona SQL Server User Group and to my home town nortth Orlando user group OPASS!

This week I was very lucky to present Inside the Query Optimizer to the AZ SSUG and Performance Tuning, NOW! to OPASS.…

Read more

1 comments, 597 reads

Posted in SQLBalls on 27 June 2014

Microsoft Azure Portal Preview looks promising !

This is one of those posts which is pending for a very long time. I was pretty excited when Azure Portal Preview was announced during BUILD2014. This portal will deeply enhance developer experience.

As a SQLServer person I was interested to explore more within the portal to see what in… Read more

0 comments, 740 reads

Posted in SQLSailor.com on 26 June 2014

T-SQL Window Functions – Part 2: Ranking Functions

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

This is part 2 in my series on SQL window functions. In this post, we will explore using ranking functions. SQL… Read more

0 comments, 1,057 reads

Posted in DataOnWheels on 26 June 2014

Worst Day As A DBA

I remember the day pretty vividly, it was in the summer months and I was as green as green can be coming into the technology field. Walking through the doors to the start of my career  I was ready to tackle the world. The training for new hire sessions had… Read more

0 comments, 297 reads

Posted in The SQL Professor on 26 June 2014

Why Is your datetime saved as a bigint anyway?

Yet another issue I had never seen before - thankfully this time I was able to find a relatively quick answer.

On a client system their primary database had grown to throw disk alarms on the DATA drive, so I was alerted.  I signed onto the system and found that…

Read more

0 comments, 582 reads

Posted in Nebraska SQL from @DBA_ANDY on 26 June 2014

T-SQL Window Functions – Part 1: The OVER() Clause

This is a reprint with some revisions of a series I originally published on LessThanDot. You can find the links to the original blogs on my Series page.

SQL Window functions were introduced in SQL Server 2005. At the time, only a small set of functionality was available. Window… Read more

0 comments, 2,361 reads

Posted in DataOnWheels on 26 June 2014

It's not Business, It's Personal

Hello Dear Reader.  I find myself at this late hour unable to sleep.  Yesterday the slate of speakers for the PASS Summit was announced.  What should have been a happy moment was quickly darkened by the words of people that I know well within the SQL Server Community.

I would…

Read more

11 comments, 673 reads

Posted in SQLBalls on 26 June 2014

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using CHECKDB. Not only does CHECKDB check the health of important internal pages of your database like PFS, GAM, IAM and many more, it also check for errors in your data…

Read more

0 comments, 2,381 reads

Posted in DotNine SQL Server and more on 26 June 2014

Finding the last successful CHECKDB

One very important part of your SQL Server maintenance procedure should be running consistency checks on a regular basis using CHECKDB. Not only does CHECKDB check the health of important internal pages of your database like PFS, GAM, IAM and many more, it also check for errors in your data… Read more

0 comments, 360 reads

Posted in DotNine SQL Server and more on 26 June 2014

Passion

I know I tend to be overly passionate. It’s something that has gotten me into trouble in the past. It’s also probably a huge factor in the things I’ve been able to accomplish in life. I’m bringing it up at this time because I think passion is causing some conflict… Read more

10 comments, 653 reads

Posted in The Scary DBA on 26 June 2014

PASS Summit – What Does It Mean To Me?

PASS Summitwhat does it mean to me? So listen, I’m not perfect. I will never claim to be and you will never her me utter those words. I make mistakes every day, but I try to learn from those mistakes as much as possible.

I was asked… Read more

2 comments, 291 reads

Posted in The SQL Professor on 26 June 2014

SQL Server 2014 – How to add features to existing instance ?

SQL Server 2014 – How to add features to existing instance ? :-

1) Start installation center

2) Run Global Rule, You need to fix if any failure occur

3) Microsoft update option (Enable windows updates to search & install SQL updates as well)

4) Include product update with installation,… Read more

3 comments, 9,582 reads

Posted in MSSQLFUN on 26 June 2014

SSIS Parent-Child Architecture in Package Deployment Mode

This is the second in a series of posts about SSIS parent-child architecture.  You can find the index page here.

In my first post in this series, I covered the essentials of SSIS parent-child design patterns, including discussing a number of advantages for using such patterns.  In this… Read more

10 comments, 4,400 reads

Posted in Tim Mitchell on 26 June 2014

Speaking at PASS Summit 2014

Achievement unlocked.

I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014 in November of 2014 in the beautiful city of Seattle.
Every Microsoft Data Platform professional, every Microsoft Employee doing technical presentations can only dream of delivering a session at… Read more

2 comments, 57 reads

Posted in Niko's blog on 25 June 2014

PASS Summit 2014 – I’m speaking!

On June 25, 2012, I set a goal for myself.  It was this:

In the next 3 years, I want to present at the PASS Summit.

Today I am thrilled and honored to say that this November I will achieve that goal (got it in just under the wire)!  Drawing… Read more

3 comments, 556 reads

Posted in Cleveland DBA on 25 June 2014

Speaking at SQLSaturday Oslo, Norway 2014

I am extremely delighted to announce that I was selected to present a Deep Dive session on Clustered Columnstore Indexes at the very first SQLSaturday Edition in the beautiful city of Oslo, Norway. This event is to be held on the 30th of August of 2014, and given the… Read more

0 comments, 73 reads

Posted in Niko's blog on 25 June 2014

Final Summer Precon for Me – Portland Maine

This coming weekend is the SQL Saturday #293 in Portland, Maine with my precon on Friday. I am really looking forward to attending this event. I have never been to Maine but have always wanted to go.

I am very excited to be presenting two sessions at this event! Read more

0 comments, 362 reads

Posted in Technobabble by Klee from @kleegeek on 25 June 2014

Thoughts On The 2014 PASS Summit Selections

The session lineup for the 2014 PASS Summit was announced today and I'm honored to be selected as a presenter. This will be my 6th year at the Summit and 5th as a presenter, and every year it's tougher to be picked as the PASS community - and the number… Read more

0 comments, 1,153 reads

Posted in Kendal Van Dyke on 25 June 2014

“A good DBA is a lazy DBA”

I’m borrowing from Andy Leonard (blog | twitter) who says all the time, “Good engineers are lazy.”

If you’re thinking, “Why would I want (to be) a lazy DBA?” let me explain. There’s a lot to be said for hard work. However, have you ever seen someone who… Read more

7 comments, 1,711 reads

Posted in Databases – Infrastructure – Security on 25 June 2014

Newer posts

Older posts