Month: August 2010

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/ssrs_crm Thanks to Julie Yack et all for putting everything together!   Cheers,...

Read More

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 If you have the time, I would read it….it seriously had me rolling…. Cheers,...

Read More

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. Once in a while, even this process fails and you have a hung transaction that keeps the process from completing and, of course, the replication process just doesn’t skip over automagically. So you stuck with troubleshooting…but it doesn’t have to be that bad. This is the process you should follow. First, you need to execute a couple of stored procedures against the distribution database. sp_helpsubscriptionerrors @publisher='<publisher_name>’,@publisher_db='<publisher_db>’, @publication='<publication_name>’, @subscriber='<subscriber_name>’,@subscriber_db='<subscriber_db>’ This procedure will give you details about the error that occurred. More importantly it will provide you with the sequence no that you will need to get the command that tried to execute …..so that you can continue troubleshooting. Now that we have found the sequence number we can use the following procedure to get the exact command that was executed. EXECUTE distribution.dbo.sp_browsereplcmds @xact_seqno_start = ‘0x000734CA00003C4F000C00000000’, @xact_seqno_end = ‘0x000734CA00003C4F000C00000000’, @publisher_database_id = 24, @command_id = 1   In the example above, you can provide either a single sequence no or a range of them. You can get the database id and command id from the previous command. Now you should be able...

Read More

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 Demo Files Remember if you have any ideas for webcasts next month, then please feel free to drop me a line and we’ll see if we can get something on the schedule. Cheers!...

Read More

#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 ‘learned up’ on the latest and greatest techniques for SQL Server.   I myself will be presenting two sessions at least on the following: Monitoring Data Changes the Microsoft Way with CDC Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment. Take Control With Resource Governor and PBM A large majority of a modern DBA’s workload consists of managing their policies and resources on their system in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides both Policy Based Management(PBM) and Resource Governor, which allows the DBA to discretely manage system policies and resources in...

Read More