Category: Tips

N Things Worth Knowing About SELECT

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 can go into the SELECT statement, of course, but the basic structure is:  WITH […]

Tip: Change Multiple Field Formats in SSRS

See the companion tutorial video, Format Multiple SSRS Table Fields Edit: I have been proven wrong! Which is a good thing! Mark Bradbourne points out that there IS a way to format multiple fields within the dialogue, using the Properties dialogue (instead of Textbox Properties), and he has provided this handy video.  I love the hivemind. […]

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: Select Native OLE DB\Microsoft Jet 4.0 OLE DB Provider . […]