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

Archives: August 2010

SELECT, Deconstructed

Today let’s expand on the logical processing order of SELECT that I mentioned in last week’s N Things Worth Knowing About SELECT blog.

We’re looking at the SELECT statement clauses in the order that the SQL engine logically processes them…we’ll even write it that way – it’ll look weird, but… Read more

10 comments, 2,543 reads

Posted in SQL Awesomesauce on 31 August 2010

N Things Worth Knowing About CTEs

If you haven’t messed with them yet, you should know that CTEs (Common Table Expressions) - new in SQL Server 2005 – are actualy pretty #awesomesauce. A CTE is, in essence, a temporary view attached to your SELECT statement.  They’re good for a number of uses, not the least of… Read more

5 comments, 1,280 reads

Posted in SQL Awesomesauce on 26 August 2010

N Things Worth Knowing About SELECT

SELECT is this kind of Swiss Army Knife

SELECT is our bedrock, our foundation, our now-and-forever T-SQL multitasker…and it’s one of the most complicated structures available to us.  Here are a few things worth knowing about it, from the basic to the obscure. 

More-or-Less Basic Structure

There’s tons more that… Read more

0 comments, 1,205 reads

Posted in SQL Awesomesauce on 23 August 2010

Random Fun – Password Rules Cheatsheet

Piggybacking tangentially off of Tim Mitchell’s (blog, Twitter) SSC editorial Turn a Bad Job into a Good Experience…yesterday I got some user questions about the department’s new password policy.  The policy is admittedly complex, especially considering half the place had been using the “kid’s name and… Read more

0 comments, 655 reads

Posted in SQL Awesomesauce on 17 August 2010

Tip: Change Multiple Field Formats in SSRS

One of the things about SSRS that irritates me is that in the graphical editor, you have to set the text box properties (say, to format numbers as currency) for each individual text box…unlike Excel, where you can select multiple fields, hit CTRL-1 and format them all at once. Read more

0 comments, 1,147 reads

Posted in SQL Awesomesauce on 13 August 2010

Tip: Connect to dBASE files in SSIS

This has come up several times in the course of the last TWO jobs, so I’ll put it here for my reference (and yours).

To use a dBASE file as a source in SSIS (and I know you want to), in your new connection manager:

  1. Select Native OLE DB\Microsoft Jet…

Read more

2 comments, 736 reads

Posted in SQL Awesomesauce on 12 August 2010

24 Hours of PASS: Like Bacon for Chocolate

24HOP: Like Bacon for Chocolate

24 Hours of PASS is hip, it’s new…it’s serialized.

The September 15-16 24HOP is a sneak peek at the 2010 PASS Summit, divided into two segments of 12 hours each. You can take a look at the schedule here, noticing first and foremost… Read more

0 comments, 674 reads

Posted in SQL Awesomesauce on 11 August 2010

How to Attend a Tech Conference

I’m absolutely positive that I’m not the first to blog on this topic, but I haven’t seen anyone else say exactly what I want to say. So.

Hi! So, you want to come to a tech conference, like SQL Connections, TechEd, a free SQL Saturday, or the… Read more

0 comments, 921 reads

Posted in SQL Awesomesauce on 4 August 2010