Shannon Lowder (Page 57)

sql

SQL 201-Table Variables

It's been a while since I've added to my SQL 201 series, so I thought I'd pick up with table variables. In an earlier post, I covered temp tables. Temp tables

career development

Another Couple Articles Over at Salary.com

I've had two more articles go live over at Salary.com. The first is The Job Hunter's Guide to Social Media I compare the big four social media sites: Facebook,

sqlpass

Don’t Miss My Session at SQLSaturday #80

That's right! I'll be speaking at this weekend's SQL Saturday event in Wheeling, WV. I'm the last speaker in track #3. I'm looking forward to Ed Wilson's

microsoft sql

SQL 201-Ranking Functions

It's been a while since I've covered a SQL 201 topic! I want to jump back into it with ranking functions. These are functions that let you represent orders in

Building Database Administration Standards for Azure

Every client environment I walked into in 2011 had a version of the same problem: a SQL Server instance that had grown organically over years, with naming conventions that reflected whoever set it up in 2004, backup policies that made sense when the server had 20 GB of storage, and

microsoft sql

Some Blogging Changes

Some Blogging Changes 2011 July 8 by Shannon Lowder You may have noticed there are fewer posts on here than there have been in several months. Well, I’ve been sitting on some news. I’m working with several new sites to publish articles. I’ve made the decision to make this site...

personal

2011 Resolutions Checkup

Earlier this morning Tom LaRock (@SQLRockstar) reminded us all the year was half over. He also suggested we take a look at our new year's resolutions. So I

product reviews

Going Paperless: Is it time to buy a tablet?

My latest article has been published over at Salary.com! Check it out. Going Paperless: Is it time to buy a tablet? Think about how much paper you use at your

Azure Active Directory as Your Identity Foundation

One of the decisions that bit the most Azure early adopters in 2011 was identity. They moved their database to the cloud and kept their authentication on-prem — SQL logins, Windows accounts tied to an Active Directory that wasn't connected to Azure. The result was a split identity

sql

70-432: Post-op

I passed the 70-432! After two months of preparations I did it! I'd like to let you know a little about my experience with SQL, so you can judge how much of

sql

Tips for SQL N00bs

Everyone in PASS and everyone following the #sqlhelp hashtag on twitter was a SQL n00b at one point. That includes me. So when I started compiling my SQL101