Category: Dev

Code that writes code

Post author By Jen McCown
Post date March 30, 2018
Categories In Admin, Applied SQL, Dev, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Code that writes code

Code that writes code it one of the best productivity tips I can give you. And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries. The example I’ll give today is changing database file growth rates. If I want to change the DB file growth […]

Management Studio Shortcut – Change Connection

Post author By Jen McCown
Post date March 14, 2018
Categories In Admin, Dev, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips

One of the most common things I do within SSMS is to change connection for the current query editor window, from one SQL Server instance to another: I’m a huge fan of keyboard shortcuts (see exhibit 1, exhibit 2, and exhibit 3). So let’s create a shortcut for “Change Connection” today. The basic method for creating keyboard shortcuts is: […]

CROSS JOIN for fun

Post author By Jen McCown
Post date February 16, 2018
Categories In Dev, Fluffy Stuff, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, TSQL
6 Comments on CROSS JOIN for fun

My son, who wishes to be known as “Pigeon” for the duration of this blog, was mixing the names of Hogwarts houses over a game of chess* with his brother: “ONE MILLION POINTS TO GRYFFINPUFF!” So I said, “Hey guys, I’m going to do a nerdy thing with my database skillz and then show you, okay? […]