T-SQL Tuesday #025: Trick or …?

This month's T-SQL Tuesday is hosted by Allen White (blog | @SQLRunr) and is an invitation to show off a nifty T-SQL trick you use to make your job easier. Here's one of my favorites as of late: Some of the source systems we copy from shard their data across multiple similar tables. For example, instead of having 1 table named dbo.Sales, they might have 30 of them named dbo.Sales_001 to dbo.Sales_030. If there were a rhyme or reason to this sharding it might be seen as an advantage, but unfortunately neither myself nor others on the team have ever…
Read More

T-SQL Tuesday #22: Pseudo-XML

This month the 22nd T-SQL Tuesday comes to us courtesy of Robert Pearl (blog | @PearlKnows), and he's asking us to write about formatting data for presentation to end users. He describes end-users as "boss, supervisor, department head, the analyst, employees, or customers". I'm going to take the liberty of extending this to include other computers so I can tell you all about what I came to call "Pseudo-XML". Fresh out of college I didn't exactly find the DBA job I was hoping for. Nobody was really looking to trust their databases to a kid with no real work experience…
Read More