Archive | July, 2010

Kendra Little is Psyched About #SQLSAT51 in Nashville

Check out Kendra’s post here to see how cool you could possibly feel just by attending this free event! Plus, it’s a good introduction to the plethera of culture that is available in the Nashville area. ……Well, and I will be speaking there too 🙂 http://littlekendra.com/2010/07/28/sqlsat51_nashville/ Cheers! AJ

Read more

Help Build the SQL Rally Selection Process.

SQLAndy blogged about the possible selection process which you can read about from the link below: SQLAndy’s Blog Post I like what PASS is trying to do with adding events and trying to make PASS more relevant to the DBAs that are out in the field. However, there are a couple of suggestions that seem […]

Read more

Transactional Replication Deep Dive Webcast for PASS DBA Virtual Chapter

I will be giving a presentation to the PASS DBA Virtual Chapter on Aug 11,2010. Be sure to attend as they are giving away $50.00 Amazon gift card! The details are below so be sure and sign up! Event Link:   http://www.sqlpass.org/Events/ctl/ViewEvent/mid/521.aspx?ID=457   Date: 8/11/2010 Start Time:     12:00:00 PM End Time:     1:00:00 PM Timezone:     (GMT-07:00) Mountain […]

Read more

SSRS 2008 R2 Webcast for XRMVirtualUserGroup ( @xrmvirtual )

Okay, so I will be presenting another webcast on SQL Server 2008 R2 Features….this time specifically with a slant towards CRM for the XRMVirtualUserGroup on Aug 26th,2010. SSRS in CRM with Arie Jones Join Arie Jones, Principal Technology Manager of Perptech, as he shares with us what’s new in SSRS 2008 R2. This session will […]

Read more

SQL Saturday #51: Nashville ( #sqlsat51 )

Well, I will be seeing everyone in Nashville at the SQL Saturday #51. My session will be on Monitoring Data Changes With Change Data Capture so I am already checking into trying to do some kind of really crazy type of demo to really underpin the technology and the speed and resourcefulness that it brings […]

Read more

What’s New in SSRS 2008 R2: Webcast

Well, our first PTI webcast is complete. Except for a few technical glitches everything turned out okay in the end for a first run through. Got a lot of emails post event thanking me for the presentation so it was well worth it. Now I just have to figure out what I will do for […]

Read more

SQL Server 2005 T-SQL: Mimic MERGE with OUTPUT

Following up on my previous post a couple of people have asked me how they could accomplish this same thing because MERGE is not available in SQL Server 2005. So let’s take a look at how you can use the OUTPUT statement which is available to produce sort of the same affect. So first we […]

Read more

SQL Server 2008 T-SQL: MERGE

In 2008 SQL Server finally provided the developer with a simple way in which to do what is commonly referred to as an ‘upsert’ with the MERGE statement. So the basis of the MERGE is that you have a base table that you want to perform updates on and a set of data that you […]

Read more

Upcoming Webcast: New Features of SQL Server Reporting Services 2008 R2!

We are having our first webcast at PTI in the month of July. This month’s topic will be SSRS 2008 R2 so it should be filled with some very fun stuff. The last presentation I gave on this subject one guy told me that he hadn’t been this excited about reporting since RPG! We’ll be […]

Read more

SQL Server 2008 R2 Hosted Trial

For those of you whom haven’t the time or resources to load a copy of SQL Server 2008 R2 yet to play around with it …they have a set of virtual labs set up that you can sign up for and be able to kick the tires out a bit. SQL Server 2008 R2 – […]

Read more