Programmer's Edge

SQL Server Reporting Services 2008 R2: Lookup Fields!

Well, I promised the XRM Virtual Users Group ( website [http://www.xrmvirtual.com/] | twitter [http://twitter.com/xrmvirtual] ) and Julie Yack ( blog [http://julieyack.blogs.com/] | twitter [http://twitter.com/coloradojules] ) that I would provide them a blog of an example of using the Lookup feature in SQL Server Reporting

SSRS 2008 R2 in CRM

The webcast recording is up for my presentation to the XRM Virtual User’s Group on SSRS 2008 R2 in CRM. In it I go over some of the new features as well as some gotchas for people looking to upgrade to the newer version. http://www.xrmvirtual.com/events/

Excellent Post By Brent Ozar

I don’t normally plug too many other blog posts here as I figure you can find them on your own if they are good….BUT Brent Ozar has an excellent blog post on Why I’m Disappointed in the PASS Election Process [http://www.brentozar.com/archive/2010/08/

Databases

Fixing Transactional Replication in SQL Server

SQL Server has a very solid criteria for replication transactions to the subscribers. First it sends out a batch. If it completes then it goes on to the next one. If not, then it tries each of the transactions in the set individually to see if that corrects the problem.

Development

Webcast: Introduction to the Entity Framework 4.0

Thanks to everyone whom attended the webcast. As promised, here are the sample files as well as the information so that you can download the webcast…if you should so choose. Live Meeting Recording [https://www306.livemeeting.com/cc/8002679563/view?id=QRGB9H] Demo Files [https://www.programmersedge.com/Files/

#SQLSat50 East Iowa: Operation Hoosier to Hawkeye Begins!

That’s right people. I am heading out on the road once again for a SQL Saturday. This time it will be SQL Saturday 50 in Iowa City, IA on Sept 18th, 2010. I hear tell that there will be an awesome lineup of speakers available to get you all

#SQLSat51 Nashville Post-Mortem

Well, another successful SQL Saturday has been logged in the books. I had a single session for this one for Change Data Capture and went out of my way to ensure that it was crammed packed with information for the people attending….even to the point that when the volunteer

CRAZY! You Can Haz More Free Training in September in Indianapolis! #sql

It’s true! Come Saturday September 25th ,2010 Perpetual Technologies, my parent company, is putting on an ALL DAY free training event for both Microsoft and Oracle people in the Indianapolis area! This is our 3rd annual event and has finally been moved to a Saturday so that more people

You Can Haz Free Training Next Week!

Yes you can! It’s totally true! Besides doing #sqlsat51 in Nashville this weekend there are not one but TWO webcasts that you can get some FREE training from next week from the comfort of your climate controlled offices! The first is on Tuesday and covers EF 4.0 We

#passvotes : The Drama Continues

*** Disclaimer: Regardless of the rumors, I am not.. nor have I ever been related to Steve Jones. Just because we share the same last name doesn’t count. Jeesh people! **** There has been an awful lot of traffic bounding about because of Steve Jones [http://www.sqlservercentral.com/blogs/steve_

Webcast: Policy-Based Management in a Nutshell By @SQLChicken

SQL Lunch [http://www.sqllunch.com/Meeting.aspx?lunchid=29] this week will be on Policy-Based Management giving by none other than Jorge Segarra [http://sqlchicken.com/] (AKA @SQLChicken [http://twitter.com/SQLChicken] ). I highly recommend that you attend as Policy-Based Management is one of those gems within the SQL

#SQLSAT51 Nashville is Coming!

SQLSaturday #51 Nashville is coming up this weekend and it looks like it is going to be great. Where else are you going to get totally FREE training in the Nashville area? Slide decks are ready to go and I am just now trying to create some more awesome demos

August Webcast: Overview of Entity Framework 4.0 !

Thanks to everyone for attending last month’s webcast on Reporting Services 2008 R2. Responses were great and barring a few minor technical glitches went well for our first one. Now it is time for #2 and we will be looking at the Entity Framework 4.0 and I will

File for #PASS Virtual Group Webcast: Transactional Replication

Okay so here are the files I promised. It includes the slides and the code I talked about. Sorry if it seemed a little rushed but I was already behind the power-curve starting out on time and wanted to cover as much stuff as possible. Be sure to check out

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/

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 [http://www.sqlandy.com/archive/help-build-the-sqlrally-speakertopic-selection-process-part-1/?utm_source=feedburner&utm_medium=twitter&utm_campaign=Feed%3A+Sqlandy+%28SQLAndy%29] I like what PASS is trying to do with

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/

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

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

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

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

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

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

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

PASS 2010 Speaker Notification Day

Well, today they should be notifying speakers as to whom will be presenting at this years PASS Summit event. Good luck to everyone that put an abstract in. Hopefully, some of the 6 or so sessions I submitted made it through. I find these events are a little more closed