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

Archives: September 2011

How to find a string value in all the string columns of a table/view in SQL Server ?

 

Introduction

I am sure many times we all might have come across situations where we need to search/find a string value in all the string columns of a given table/view in SQL Server and return the matching rows from that table.

Unfortunately, we do not have any straight forward… Read more

0 comments, 3,595 reads

Posted in Juggling With SQL on 30 September 2011

What do you want to see from your PASS board? Me?

Many of you know recently the PASS board announced that elections will be coming up for three seats on the board for the upcoming term. I believe that the board has come a long way thanks to the efforts of some key individuals. Even so, I believe we have more… Read more

0 comments, 1,292 reads

Posted in Adam Jorgensen on 30 September 2011

Creating your first Data Mining Structure and Model

Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms built into SQL Server Analysis Services gives you this power.
The Adventure works data base comes with views that are already set up to perform data mining. Let’s take a… Read more

0 comments, 3,769 reads

Posted in Mike Davis SQL on 30 September 2011

SQL Saturday 97 Bound

Truck is loaded up and heading to the airport to make an appearance at SQL Saturday #97 in Austin TX with some awesome speakers.  Wish me luck, when I leave Austin I hope that many more TempDB’s are optimized.


Read more

0 comments, 597 reads

Posted in Tim Radney - Database Professional on 30 September 2011

Microsoft SQL Server Reference Architecture and Appliances

Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and database consolidation solutions in a very short time, with all the components pre-configured and pre-optimized.  These appliances include all the hardware, software and services for a complete, ready-to-run,… Read more

0 comments, 1,566 reads

Posted in James Serra's Blog on 30 September 2011

Re-blog – September 23 – September 30

As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts of interest that you may want to check out are:

Enjoy.

Related posts:

  1. Re-blog – September 16 –…
Read more

0 comments, 595 reads

Posted in StrateSQL on 30 September 2011

SQL In The City: LA

Just a reminder that there are a few seats left for SQL In The City: LA on the 29th of October. It’s a free event put on by Red Gate Software. I’ll be speaking there. But much better than that, you can listen to, and interact with, Steve Jones,… Read more

0 comments, 742 reads

Posted in The Scary DBA on 30 September 2011

Join the Wolf Pack at PASS Summit 2011

Quick update for all of you!

Hey there everyone! We are going to have some awesome surprises, new software features and the hottest nerds at the event in our booth at PASS! Make sure to stop by and check us out. Come say hi, get a hug, see an awesome… Read more

0 comments, 732 reads

Posted in Adam Jorgensen on 30 September 2011

SQL Saturday 89 in HotLanta!

So I am really close to Atlanta geographically, but I?m never there. I?m going to change that after this SQL Saturday. I flew in the morning of, broke several well intentioned speed laws on my way to the event and got there in time to help our sales Engineer Brad… Read more

1 comments, 786 reads

Posted in Adam Jorgensen on 30 September 2011

The power of a shirt

I love wearing all my SQL Saturday speaker shirts.  Here lately the trend has been nice golf or running shirts which look great with a pair of slacks.  Today I work my speaker shirt from SQL Saturday #81 (Birmingham AL).  I was shopping this evening at a local supermarket when… Read more

0 comments, 655 reads

Posted in Tim Radney - Database Professional on 30 September 2011

New website, exciting future for BRSSUG

Just wanted to push out an announcement that the Baton Rouge SQL Server User Group has a new website.

www.brssug.org

We've got a great few months ahead of us with our buddies at the BR .net User Group!

October's meeting is on the topic of Change Data Capture (CDC) as…

Read more

0 comments, 733 reads

Posted in SQL Tact on 30 September 2011

A Good Time to Be a SQL Server Professional

Wow!  Can't believe today is the last day of September!  Fall, here we come!  Although Summer is over, Autumn is truly an exciting and good time to be a SQL Server Professional!  So many great events coming up soon, especially the summits of all summits - PASS, the largest SQL Server and… Read more

1 comments, 976 reads

Posted in Pearl Knows on 30 September 2011

Free SQL Server in the City Event to be Held in LA

Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles, CA on October 28, 2011. It will be held at the Skirball Cultural Centre in the Santa Monica Mountains, just outside of Los Angeles.

The event will provide six hours… Read more

0 comments, 635 reads

Posted in SQL Aloha on 30 September 2011

SQL Server MVP Deep Dives: Volume II

Two years ago when SQL Server MVP Deep Dives: Volume 1 was released, I had the opportunity to contribute two chapters. In SQL Server MVP Deep Dives Volume 2, I not only had the opportunity to contribute a chapter, but the privilege of being the section editor of the Performance… Read more

0 comments, 845 reads

Posted in SQL Aloha on 30 September 2011

Presentation Files: 10 Things All BI Administrators Should Know

Presentation Files: 10 Things All BI Administrators Should Know

I sooooo remember this sign!


I was very excited to get to present to the Pensacola SQL Server User Group tonight. I lived in Pensacola for a few years when I was a kid. I have a lot of memories from… Read more

SSIS Variable and Expressions Followup

Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL Saturday.  It has been a lot of fun, so thank you to everyone who has come out and hopefully learned something from one of the sessions I have done.  So,… Read more

2 comments, 1,979 reads

Posted in Bradley Schacht on 30 September 2011

SQL Bits Training Day

By David Postlethwaite

Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing SQL Server using PowerShell

PowerShell is ubiquitous in Windows now and can be used to view and manage any part of the Windows systems, it uses the .NET framework… Read more

0 comments, 782 reads

Posted in The SQL DBA in the UK on 29 September 2011

PASS Summit 2011: My Itinerary

Here goes with what I hope to achieve the following week in Seattle, WA Oct 9-15 for my 4th summit.

I have spent about 1 hour a day reviewing what I have selected for the week with the really cool Build Your Schedule for Summit 2011.

Sunday Oct 9th is…

Read more

0 comments, 539 reads

Posted in The Smiling DBA on 29 September 2011

Slides & Samples for my SolidQ Summit Sessions

As I have announced in all of my sessions last week in Budapest at the SolidQ summit, you can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions J

-Klaus

Read more

0 comments, 714 reads

Posted in Klaus Aschenbrenner on 29 September 2011

Slides & Samples for my SQLdays Sessions

As I have announced in all of my sessions this week in Rosenheim/Germany at the SQLdays conference can find here the Slides & Samples for download. Enjoy it and thanks for attending my sessions J

-Klaus

Read more

0 comments, 695 reads

Posted in Klaus Aschenbrenner on 29 September 2011

Older posts