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

Archives: July 2011

Do You Work for #1?

Someone recently asked me if I would work for a company if I didn’t believe in their products or services (to the point that I would consider them the best). It’s an interesting question because it reflects the trade offs many of us make when selecting jobs, and there is… Read more

1 comments, 240 reads

Posted in SQLAndy on 28 July 2011

Bad Admins: Non-Production Servers

This is part of a series of tips on how bad/rogue admins can get access to the data in your SQL Servers.

We all know we shouldn't do it: don't put production data in non-production. The main reason is because we don't treat non-production like production. If we did, we'd… Read more

Lookup functions in SSRS 2008 R2 - II

 Introduction

In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to fetch the first matching value from the other DataSet. Now, what if we want all the matching values from the other DataSet. Here, the LookupSet() function comes handy.… Read more

0 comments, 4,123 reads

Posted in Juggling With SQL on 27 July 2011

SQL Server does not script indexes by default

Here is a got-ya that happened to me.  In SQL Server I want to generate a script of all the tables in case I need to re-create them.  This is usually the case in a development environment when I’m building a database.  So in Object Explorer I click on the… Read more

10 comments, 4,029 reads

Posted in James Serra's Blog on 27 July 2011

Preparing for #sqlsat81

SQL Saturday 81 is coming up this weekend in Birmingham AL.  This will be my 5th SQL Saturday to speak at.  So far I have spoken in Tampa FL, Columbia SC, Jacksonville FL and Pensacola FL.  I still get nervous getting up in front of some many people to speak,… Read more

0 comments, 194 reads

Posted in Tim Radney - Database Professional on 27 July 2011

SQLSaturday #85 Orlando: Pragmatic Works BI Pre-Con!

I’m very proud to announce that Pragmatic Works will be presenting a Business Intelligence Workshop pre-con for SQLSaturday #85 in Orlando on Friday September 23rd! In this session you’ll have not one, not two, not three but FOUR Pragmatic Works consultants walking you through how to develop a full business… Read more

1 comments, 357 reads

Posted in SQL Chicken on 27 July 2011

Exceptional DBA of the Year 2011 - Please vote for Jeff Moden

Every year Redgate has a competition to find the most exceptional DBA of the year. This year too they are conducting. One of the prize for the winner is a fully paid Sql pass summit. The best thing about this is that it is the community that votes for the… Read more

5 comments, 958 reads

Posted in RumblingDBA on 27 July 2011

What is the hardest part of planning a SQL Saturday?

For me so far it has been the speaker selection.  Getting sponsors didn’t prove to be difficult, we have a great market being we are Atlanta GA.  Locating a venue to hold the event presented a few challenges but again we are a large area so there are several venue… Read more

0 comments, 256 reads

Posted in Tim Radney - Database Professional on 27 July 2011

Searching for Wild Card Characters

I got asked an interesting question recently, I was demonstrating how you can use wild cards in a WHERE clauses when someone asked ‘How do you search for a wild card character when using a LIKE based WHERE clause fro string comparisons. I must have looked stumped for a minute… Read more

1 comments, 458 reads

Posted in The SQL DBA in the UK on 27 July 2011

Some Common Disk Drives Compared

Since I talked about how wonderful the newer Western Digital Black 6Gbps SATA III hard drives are a couple of days ago, I thought I would run CrystalDiskMark on a couple of different models in that line, along with a couple of other drives I had easy access to.… Read more

0 comments, 625 reads

Posted in Glenn Berry's SQL Server Performance on 27 July 2011

Strengths Finder 2.0

I’ve made the commitment to read and review 12 books over 12 months as a part of continuous personal development. This is my second book.

While this is a book review, the first thin you need to know is that the Strengths Finder 2.0 book is actually just a written,… Read more

0 comments, 523 reads

Posted in The Scary DBA on 27 July 2011

NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature

Quick update.  This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP Linchi Shea will give a presentation and practical application on SQL Server 2008's Audit Feature.  Come to take a close look at the SQL Server 2008 server audit feature!

Don't be misled… Read more

0 comments, 887 reads

Posted in Pearl Knows on 26 July 2011

Fastest row counting method

SELECT COUNT(*) is most common method (and exact) how to find out how many records is in table. There is also another method which is not exact but is way faster especially when you are expecting zillion of rows to be counted. This method is based on fact that SQL… Read more

23 comments, 2,774 reads

Posted in SQL Treeo on 26 July 2011

Projects – Win Early

Project plans should try to plan for some unknowns. For large projects they include known risks, vacation time, maybe even the loss of a key person or a parallel business crisis. For smaller projects it’s just x percent of slack time that can be used as needed. You do what… Read more

2 comments, 272 reads

Posted in SQLAndy on 26 July 2011

My upcoming speaking engagements

A few days ago I had an interesting conversation on Twitter about my upcoming speaking engagements. I really realized at this time that I have a lot of different SQL Server conferences in my pipeline where I'm speaking over the next months. Here are the conferences where you can meet… Read more

0 comments, 312 reads

Posted in Klaus Aschenbrenner on 26 July 2011

SQL Server, Chennai and Me

It's near to 6 months since I started blogging in SSC and started giving sessions for my Organization on Internal and tuning topics.

While seeing lots of blog post on pre/post SQLSaturday events, I am bit curious to know is there any active SQL Server user group in Chennai so that I can be part of it. Read more

0 comments, 557 reads

Posted in LivingForSqlServer on 26 July 2011

Optimize a query by thinking out of the box

Recently I had to create a simple query to lookup a single row in a table containing ranges that do not overlap. Consider this table design and example data:

CREATE TABLE MyRanges (
    id         INT IDENTITY(1,1) PRIMARY KEY,
    RangeFrom  INT NOT NULL,
    RangeTo    INT…

Read more

0 comments, 354 reads

Posted in SQL Server Notes from the Field on 26 July 2011

Leaked Information About AMD Opteron 6200 Series Processors

CPU World has a post about some leaked info regarding the upcoming Opteron 6200 series “Bulldozer” processor line. Here are the specifications of the four models that the story describes:

Opteron 6220       8 cores, 3.0GHz base clock speed, Turbo CORE to 3.5GHz

Opteron 6234      12 cores, 2.4GHz base clock speed,…

Read more

0 comments, 624 reads

Posted in Glenn Berry's SQL Server Performance on 26 July 2011

Columbus GA SQL Server Users Group Webinar Tomorrow

I found out last week from a good friend and President of the Columbus GA SQL Server Users Group, that they needed a speaker and would love to have me talk about SSRS. Since I have given SSRS presentations for the past two years, I should be able to whip… Read more

1 comments, 591 reads

Posted in BrianKMcDonald on 25 July 2011

Get count of folders using Power Shell

More on my recent PowerShell project.  I recon I have taken on the challenge to handle this entire request using Posh.  It started out just moving folders based on the folder name that included the date in format MMDDYY.  Next was having to stop services before moving the folders.  After… Read more

0 comments, 258 reads

Posted in Tim Radney - Database Professional on 25 July 2011

Newer posts

Older posts