Category: People and Opinions

Speaking Schedule! I’m here (and there, and there…) to help

Post author By Jen McCown
Post date July 25, 2011
Categories In Community, News-ish, SQL Saturday, sql server, SQLPASS, sqlserverpedia-syndication, SSC
1 Comment on Speaking Schedule! I’m here (and there, and there…) to help

Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable period of imparting knowledge, or (B) a wonderful opportunity to hear me speak at any of several different venues. Here’s the summary (past events greyed out): 7/27 4:45PM CST – EDMPASS. 7/29 11:30AM CST – SQLLunch.com. 7/29 […]

SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

Post author By Jen McCown
Post date July 14, 2011
Categories In Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL
1 Comment on SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server Books Online. This time, I was arrested by this little nugget: When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of the following conditions […]

T-SQL Formatting Workaround (Word Macro)

Post author By Jen McCown
Post date June 20, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
1 Comment on T-SQL Formatting Workaround (Word Macro)

Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too terribly much. Enjoy! I love a well-formatted SELECT statement. To that end, I often use Redgate’s SQL Prompt (with handy-dandy auto-formatting feature, just CTRL-K-Y!) to keep my code in line. But sometimes a job won’t […]