Andres Aguiar's Weblog

Right here, right now

Stories

Browse by Tags

All Tags » SQL Server (RSS)
Visual Studio Tools for Database Professionals - Rename Refactoring Take II
In January 2007 I complained about the support for renaming fields in VS Tools for DB Professionals. It looks they have a good solution for it in their latest CTP (look in the Refactoring section). I did not find time to install VS2008 SP1 beta in a VM...
Synch Framework & Multi-Tier applications
I've used ADO.NET synchronization framework in an internal project and had to give a presentation about it in the local Visual Studio 2008 Launch. I'm quite impressed with it and with the whole MS synchronization story. The usual demo basically implies...
Paging in SQL Server
Frans rants about paging support in SQL Server. I obviously agree with him. The good thing is that given that MS is working in a couple of O/R mappings products, they are probably facing the same challenges we face. As that the Entity Framework is built...
Visual Studio Tools for Database Professionals - Rename Refactoring
I started playing again with VSTDB. This version only includes on 'Refactoring', the 'Rename' one. The first thing I tried to do was to rename a database column. There are 3 things to do when doing that refactoring: Renaming it in the...
ADO.NET v.next CTP is out
At last, the ADO.NET v.next bits are public! Read the announcement here . Keep an eye in the ado.net team blog for more information about it. It includes an ASP.NET build provider, so you can drop a xml file with the model definition in App_Code and you...
Posted: Aug 16 2006, 12:16 AM by aaguiar | with 2 comment(s)
Filed under: , ,
Stored Procs vs Dynamic SQL
In DeKlarit's booth at TechEd I had to talk more than I wanted about the famous Stored Procs vs Dynamic SQL debate. People still thinks Stored Procedures are faster, even if there is much evidence that shows otherwise. Fortunately, when they go and ask...
Posted: Jun 22 2006, 02:52 PM by aaguiar | with 17 comment(s)
Filed under: ,
ADO.NET Entity Framework - It's not just O/R mapping
Pablo Castro re-announced the Entity Framework . The white papers are up again. A lot of people have been referring to the ADO.NET EF as an O/R mapper. And it is. But it's much more than that. The EF lets you design your conceptual model based on updateable...
Posted: Jun 20 2006, 04:34 PM by aaguiar | with 2 comment(s)
Filed under: , ,
VS Tools for DB Professional - Does it make sense to generate test data?
The new VS for DB Professionals supports generating test data for your data model. For each column, you can specify the Generator you want to use, and you have a bunch of predefined ones (numbers in a range, strings that comply with a regular expression...
DeKlarit 4.0 Released - CAB, WSE, VS2005, SQL2005, Layouts & More!
Last week we released DeKlarit 4.0 . I won't post the new feature list here, as you can read it in the website . What I will do is tell you about my favorite new features ;). Gaston built a great platform-independent layout editor . We can now generate...
Request to Microsoft: Let us deploy SQL Server Mobile in Windows XP!
SQL Server Mobile 2005 can be run in any Win32 box, but the licensing terms only let you use in Pocket PCs and Tablet PCs. This kind of licensing stuff is quite annoying for developers, that don't like 'artificial' constraints when using software products...
Posted: Aug 23 2005, 06:54 PM by aaguiar | with 2 comment(s)
Filed under: ,
More Posts Next page »