Here’s a nice Wall Street Journal Online article regarding the company I work for, RBA, and our work in helping to bring the cloud to our clients:
There are times when you want to reseed or reset the value of an identity column in a table.
When you delete a lot of records from a table and then try to insert more records. You would expect the identity values to start after the max value present after delete. But it preserves the max value ever present in the table and continues from there.
Another SQL tip I've found useful lately.
Posted in SQL | Leave a Comment »
Through good luck, and I guess, good graces, my excellent employer, RBA, is sending me to Microsoft TechEd in Orlando this year to take in all the MS Techie goodness… I hope to see you there!
Posted in Other Stuff | Leave a Comment »
The Twin Cities Connected Systems User Group has been Cancelled this Month
Please join us for the Twin Cities Connected Systems User Group from 6:00 to 7:30 on Thursday May 17th 2012 at the Microsoft office in Edina MN.
The address is:
3601 West 76th Street
Suite 600
Edina, MN 55435-3019
Todd Van Nurden will be presenting on Transparent Computing
Transparent computing is the future of human machine interactions. Computing needs to evolve from its static human initiated model to a more dynamic context aware approach. Under this model computers will evolve to be more digital assistant and less a fancy brick waiting for us to do something.
Connected systems, available anywhere on any device, are critical to delivering on this promise and Azure is uniquely positioned to support this future vision.
Posted in Azure, BizTalk | Leave a Comment »
Throughout my career, I have often fallen back into the world of SQL development. I suppose this isn’t really that unusual as anyone who holds the role of Technical Architect or even .NET Developer should know a bit about SQL Server. In my case it seems that I’ve been just good enough to get the job done so as a result, it becomes part of my job for small stretches of time.
Recently, as I’ve done for nth time in my career, I find myself doing more SQL Server development. To help out, I’ve discovered a nice add-in developed by Mladen Prajdić called SSMS Tools Pack. This tool allows you to generate some pretty nice CRUD stored procedures for your tables and also has a lot of other capabilities such as keeping code snippets and its own query analyzer. Because it’s an add-in, after you install it, it just shows up as a menu item in SQL Server Management Studio.
It’s definitely worth a look if you spend time doing SQL Server development. Get it here.
Posted in SQL, Tools | Leave a Comment »
Hi Friends,
If you do not have prior knowledge for CDC Concept of SQL Server please read the following CDC blog post
Nice post on using CDC to create Audit Trails
Posted in SQL | 1 Comment »
BizTalk deploys and undeploys have, in recent times, become much easier than they were back in the “bad old days.” Especially with tools like the Deployment Framework to help us out, we can usually get through the process with only a little discomfort.
Once in a while, though, you run into something that makes things more difficult than they ought to be. During a recent application removal on one of our development servers, this lovely message appeared as I attempted to remove the application from BizTalk:
Most of the help out there for the “Delete of ApplicationNode Failed” message relates to competing resources, etc. Since, those are pretty well documented, I won’t go into it here. Here our solution is much simpler than those dealing with other flavors of the exception.
For whatever reason… someway, somehow… the event log became corrupted and our message is pretty clear on that.
As expected there are a lot of ways to get around this, but FIRST, BEFORE YOU DO ANYTHING ELSE, just try a simple clearing of the Windows Application Log. In our case, this is what fixed the problem.
Posted in BizTalk, Installation | Leave a Comment »
