SQL University: Basic Tools Pt. II

Posted on

In Tuesday’s class we covered the different authentication methods as well as did a quick walk-through of the SQL Management Studio interface. In today’s lecture we’ll continue looking at SSMS. Some of the things we look at include how to create a query against a database, brief intro to the Profiler tool as well as […]

Share

SQL University: Orientation

Posted on

Ok everyone, please take your seats. Thank you. Welcome to SQL University, my name is Jorge Segarra and I’ll be helping you start on your journey to SQL Server. You’re here because you either are curious about SQL Server and wish to start down that path or you’ve become an accidental DBA in your organization […]

Share

Upcoming Talks:Orlando SSUG and SQL Saturday #21

Posted on

It’s going to be a fun month! Next week I’ll be speaking at the Orlando SQL Server User Group on Policy Based Management 101. I also got confirmation that not only was my PBM presentation accepted for SQL Saturday #21 on October 17th but I’ll also be doing a MINI session on SQL & Twitter:A […]

Share

SQL University: A Primer for SQL Server Beginners

Posted on

Recently I was thinking about my experiences with all of the SQL Server learning events and while they have all been absolutely awesome I realized one thing: they’re that awesome for me because I know what’s going on. By that I mean I’ve been around SQL Server for awhile now so when I attend the […]

Share

24 Hours of SQL PASS – Review

Posted on

So the inaugural event for 24 Hours of SQL PASS has come and gone. In its wake its left hundreds of eager minds reeling from absolutely amazing content overload, bleary and blood-shot eyes around the globe and one worn-down rock star. First off the staff at PASS and all of the presenters deserve a standing […]

Share

Policy Based Management: Against All Databases Condition

Posted on

Recently after one of my presentations a Twitter-buddy of mine, Argenis Fernandez ( Blog | Twitter ), showed me something interesting. By default when you create a new policy the against targets default says ‘Every Database’ (see screenshot below). Well this is a tad misleading as it apparently means “every” in the sense that it […]

Share

Database Mirroring Freak Show – SQL Quiz from Chris Shaw

Posted on

Chris Shaw ( Blog | Twitter ) started another great web chainpost. He tagged Brent Ozar, Brent tagged Thomas LaRock and Tom tagged me. This particular quiz is a two-part question and here are my responses. Excuse my lack of wit and charm. It’s late, my caffeine supply is running low and my cat is […]

Share