Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: August 2011

Tribes: We Need You to Lead Us

I’ve finished my 3rd book as part of my year long commitment to read and review professional/personal development books. I read one of my favorite authors this time, Seth Godin and his book, Tribes: We Need You to Lead Us .

I’ve either been very smart or very lucky in… Read more

0 comments, 282 reads

Posted in The Scary DBA on 30 August 2011

Creating Facebook page for blog

Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm and I am very glad. Many users are also waiting for SQL Server 2005/2008 support (2008 R2 is only supported version now) and I will release it soon. I received… Read more

2 comments, 273 reads

Posted in SQL Treeo on 29 August 2011

SQL Saturday #90–Oklahoma City recap as chauffeur and speaker

I’d never been to Oklahoma City, and when Kristin Ferrier asked me to come to SQL Saturday #90 and do the keynote, I was happy to accept. It’s a short flight from Denver, and not much further from Austin, so I was surprised Friday morning to find Wes Brown sitting… Read more

0 comments, 369 reads

Posted in The Voice of the DBA on 29 August 2011

Time Flies When You're Having Fun

I've done it; I've violated one of the rules I give to people who are interested in blogging: I went dark. It was unintentional, of course, but I'm still guilty nonetheless. The reason? Life's been really busy - both personally and professionally - and I let blogging fall to the… Read more

1 comments, 329 reads

Posted in Kendal Van Dyke on 29 August 2011

Applied SQL: Server Side Traces

It’s time to get your server side trace on, with a little practical application!

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.

Prerequisites: basic T-SQL, basic experience with SQL Profiler

Reading:

Read more

0 comments, 353 reads

Posted in SQL Awesomesauce on 29 August 2011

Women in Technology: A Quick Observation and a Quick Straw Poll

A bit of background:  Those aren’t grand daughters of the Clampetts in the picture at right.  Those are my three daughters and three stepdaughters, all of whom I want to inherit the world – as little or as much as they want to take hold of.  (I already talked a… Read more

2 comments, 212 reads

Posted in Kevin E. Kline on 29 August 2011

When to use T-SQL or SSIS for ETL

When doing ETL, you have the choice of using T-SQL or SSIS.  What things should you consider when deciding which one to use?  Here are some of the major design considerations to think about:

  • Performance - With T-SQL, everything is processed within the SQL engine.  With SSIS, you…

Read more

9 comments, 4,628 reads

Posted in James Serra's Blog on 29 August 2011

The Basic Security Model in SQL Server – Skill #3

This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for a few deliveries in 2011.

Users and Objects

The basic security model diagram that I use is the one below. It’s not fancy, but it conveys the basics of… Read more

3 comments, 1,358 reads

Posted in The Voice of the DBA on 29 August 2011

SSIS For Each Loop over files with Date in Name

A common request I have received over the years is to move or copy files from one directory to another based on the file name.  This can be accomplished in SSIS without using any script task. You can do this with a for each loop, an empty sequence container, a… Read more

3 comments, 4,221 reads

Posted in Mike Davis SQL on 29 August 2011

Notes From The 2011 Jacksonville Code Camp

In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a leisurely lunch with my family, and then had them drop me off at the University of North Florida about 1:30 pm. It’s definitely different to arrive in after lunch, all… Read more

0 comments, 269 reads

Posted in SQLAndy on 29 August 2011

SQL Saturday #90 OKC

This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first ever SQL Saturday event.  I have to say that this was one of the best SQL Saturday events I’ve attended, which is especially notable since it was their first such… Read more

0 comments, 257 reads

Posted in Tim Mitchell on 29 August 2011

SQL Saturday #90 OKC

This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first ever SQL Saturday event.  I have to say that this was one of the best SQL Saturday events I’ve attended, which is especially notable since it was their first such… Read more

2 comments, 365 reads

Posted in Tim Mitchell on 29 August 2011

Inserting Records AND Getting The Identity in SSIS - Part 2

Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for that problem I didn't know back then.  Check out that previous post for the business problem, then come back here…

Read more

1 comments, 1,626 reads

Posted in Todd McDermid's Blog on 29 August 2011

Code Camp New Zealand 2011

I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It was a one day free event with 4 different tracks of 6 sessions each. I attended all of the SQL sessions and learned some good stuff.

The… Read more

0 comments, 553 reads

Posted in SQL Sandwiches on 29 August 2011

SQL Server Hardware Choices Made Easy

Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a compilation of the month long series I wrote in April 2011, called A SQL Server Hardware Nugget A Day, along with additional content from my SQL Server Hardware Read more

2 comments, 1,212 reads

Posted in Glenn Berry's SQL Server Performance on 29 August 2011

JAX Code Camp 2011 Review and Slide Deck

Yesterday, my wife (twitter: @sherrilmcdonald) and I spoke at JAX Code Camp 2011 in Jacksonville, Florida. The event was well organized and gave me the idea that a lot of time was spent in making sure that nearly all of the 300 attendees (approx.) were well taken care of.… Read more

0 comments, 488 reads

Posted in BrianKMcDonald on 28 August 2011

SQL Saturday #91

This weekend I attended my 5th SQL Saturday, SQL Saturday #91 in Omaha.  Every SQL Saturday I have attended has been fantastic, but each is unique in its own way.  If I had to come up with one word to describe this particular SQL Saturday, then I would say “smooth.” Read more

3 comments, 710 reads

Posted in Advice from Aunt Kathi on 28 August 2011

How to write data from user-defined function

Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL Server. My colleague recently needed to log something from within function so we were searching for solution how to do that with least work. There is one option to call… Read more

0 comments, 521 reads

Posted in SQL Treeo on 28 August 2011

Answer to the Quiz

Hi Everybody,

Congratulation to Yair Gutman who won a free ticket to the Advanced Programming in SQL Server 2008 R2 Course !

Here’s the answer to the Quiz:

Let’s first analyze the query without DATEADD:

<span style="color: #0000ff;">SELECT</span>


Orders.Id ,


Orders.DateAndTime ,


OrderStatusId


<span style="color: #0000ff;">FROM</span>


Sales.Orders <span style="color:…

Read more

0 comments, 4 reads

Posted in Noam Brezis on 28 August 2011

New Dell Precision M4600 Mobile Workstation

After a very long wait, I finally received my new company laptop this past week, which is a very fast Dell Precision M4600. This particular unit has the 2.3GHz Core i7-2820QM quad-core processor, with 8MB of L3 cache. It uses Turbo Boost 2.0 to increase the clock speed to… Read more

1 comments, 749 reads

Posted in Glenn Berry's SQL Server Performance on 28 August 2011

Newer posts

Older posts