Month: June 2011

#SQLSat82 Indianapolis: Post-Mortem

Well, another SQL Saturday is in the books. This time I was speaking at our own SQL Saturday #82 in Indianapolis, IN. Being our first SQL Saturday event the pressure was on to produce a top-tier event for both speakers and attendees alike. Luckily, my parent company Perpetual Technologies, Inc ..AKA PTI ( web | twitter )  allowed us to leverage our expert event coordinator Caroline Bailey  to help coordinate everything.. so luckily she took care of a lot of the ground game of getting possible venues …possible caterers…etc…etc…. she really did a fantastic job. Caroline…. English Event Coordinator Extraordinaire!   I was giving three sessions this time around ….. Introduction to Service Broker Take Back Control with Policy Based Management Reporting Services Greatness Slide Decks and Examples Everything went pretty smoothly…. we were a little late getting the morning keynote/welcome message out so that kind of cut into my time a little bit…so I was a little rushed. That was okay though. The crowds seemed really interested in the topics and all sessions had pretty decent attendance. The event venue was totally AWESOME! University of Indianapolis totally rocked as it was a gorgeous campus and the weather was perfect enough for people to go outside to have their lunch or just take a breather in between sessions. AJ: Why does he ALWAYS have coffee? So I thought I...

Read More

#Telerik: Mastering the WPF RadWindow Dialog Boxes

RadWindow within the Telerik toolkit is an awesome resource for creating stylish windows. However, it also has the added benefit of providing you with some out-of-the-box implementations of dialog boxes. Specifically it comes with three separate ones.. Alert Confirm Prompt These are useful because they are already templated out with an image and everything. So I thought it would be nice to pick one of them, the Confirm prompt, and go over how you can go about using it in your projects. So starting with a similar version to our previous projects. A simple window with two ListBoxes in it…one for ‘Selected’ and one for ‘Non-Selected’ people. When we double click on one it sends it over to the other. Easy-Peasy. Now we want to introduce a prompt into the mix so that when we double-click it automatically prompts us to make sure that we want to do that…. should be pretty straightforward. To get the basic prompt we merely have to introduce a couple of lines of code. 1: public void MoveToSelected(Person person) 2: { 3: var parameters = new DialogParameters(); 4: parameters.Content="You sure you wanna do that?"; 5: RadWindow.Confirm(parameters); 6: NonSelectedList.Remove(person); 7: SelectedList.Add(person); 8: } 9:  10: public void MoveToNonSelected(Person person) 11: { 12: var parameters = new DialogParameters(); 13: parameters.Content = "You sure you wanna do that?"; 14: RadWindow.Confirm(parameters); 15: NonSelectedList.Add(person); 16: SelectedList.Remove(person); 17: } Now...

Read More

Code Smarter Not Harder #3: #CodeRush Property Setter Template for #CaliburnMicro

In our third installment, we will look at the latest version of CodeRush and how we can implement a custom template for Caliburn.Micro that takes care of a custom property setter for us. Now in the latest version of CodeRush there is already a template created fro MVVM implementations that creates a setter routine for a property complete with the wire-up for the INotify call. However, if you are working with a base viewmodel class like the IScreen implementation of Caliburn.Micro then this kind of gets in the way…because we already have a nice lambda expression based call for NotifyOfPropertyChange. So in our basic setup when we would type pb <spacebar> to create our property stub, we would end up with this… Now this is okay if the form is pretty simple and I have to retype the PropertyChanged call but if I am working on a complex set of windows/screens this just gets downright annoying. So what we want to do is to create a custom CodeRush template that will enact the proper call to NotifyOfProperyChange but not interfere if we happen to be using a project that is not using Caliburn.Micro. Luckily, Caliburn.Micro uses IScreen as its base for the screens and windows so all we have to do is to check if the current class we are in inherits from IScreen. So first off, we need...

Read More

#SQLSat82 SQL Server Troubleshooting & Performance Tuning : DON’T Miss a Golden Opportunity!

SQL Saturday #82 is having an all day pre-conference event at Perpetual Technologies, Inc headquarters building. This is a once in a lifetime opprotunity for you to get a full day of training given by one of the premier SQL Server experts in the field, Kevin Kline of Quest ( blog | twitter )  for only $99 bucks! Do not miss out on this opportunity. Kevin has been working diligently on this presentation and is coming armed with all kinds of things to hand out to the attendees! See the details below and be sure to get signed up! If you know friends in the Indianapolis area that would be interested then please Tweet about this or send them a link! Event Sign-up Page   Event Details Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2 Presenter : Author, expert  and Microsoft MVP Kevin Kline                         (http://KevinEKline.com) This full day seminar will teach you introductory, intermediate and advanced techniques for troubleshooting and performance tuning using SQL Server’s built-in Dynamic Management Views (DMVs), Performance Monitor, Profiler, Wait Stats, and Extended Events.  In troubleshooting, you’ll learn how to detect, diagnose, and resolve problems on SQL Server using the native tools, as well as how to determine where SQL Server is experiencing bottlenecks that prevent it from achieving optimal performance. Bring your laptop with SQL Server 2008 R2 and AdventureWorks R2 to work...

Read More

Change Data Capture: Restoring A Database

Change Data Capture (CDC) is an awesome feature available in Enterprise Edition of SQL Server 2008. It enables tracking of changes all the way down to the column level and is a really great time saving feature if you are building complex data models that have the need for this type of thing..such as required by some regulation FISMA, HIPPA, DITSCAP, etc… However, what happens when everything goes down hill and you need to restore from a backup…What then? Fortunately, Microsoft has thought of a lot of different angles on this one. So if you are restoring a CDC enabled database you just need to keep in mind the following points. If you are restoring to the same instance with the same name….NO PROBLEM. All your CDC settings and associated data is intact. Since the setting is per database and your CDC meta data and associated tables are kept within system tables of the database you are safe. If you just detach and reattach the database…whether it is the same instance or not then by default CDC will remain enabled and all your meta data is preserved. If you restore a database from backup on the same server and change the name of the database … CDC will be disabled by default.. which will result in you LOSING ALL YOUR DATA concerning CDC. If you restore a database to...

Read More