Hi guys...I've been gone nearly a month now. I've finished the last of my classes of my last year of my BSc degree (final exams are in January) and we were having all sorts of grad parties. Add to that finishing off a freelance project and my new role as one of the moderators of http://forums.asp.net...

On Thomas Frank's blog there is an interesting post which shows how to get JSON from MySql , and I though about doing the same to SQL Server since I use it more than any other database lately. So what I did was create a stored procedure which uses cursor to format the string with our data. I'm not really...

Voow, I am almost done. On this Sunday night, at Panera, I have enjoyed writing while listening to the jazz and drinking coups of tea (3, so far). Alright, let's summarize briefly what we have done so far in these series: After giving some intro, In this complete but simple web application, we import...

Hi all. Get this great Red Gate resource for free: The Best of SQL Server Central Vols 5 and 6 and also get this one The Art of High Performance SQL . If you are not convinced, with this download you can get also this cool ebooks: 1. Brad's Sure Guide to SQL Server 2008 2. Brad McGehee's DBA Best Practices...

In order to make it easier for developers to familiarize themselves with the Entity Framework, we have put together a list of some of the available resources that we found to be most useful in getting up to speed with the new tools and technologies. You can download it from our web site at http://www...

Here are my notes on the Monday morning keynote: About 3000 attendees at the conference, over 60 countries represented. There is BI in Halo3: whenever you look at competitor stats or weapon effectiveness, this is implemented using BI tech Madison - MS has acquired DATAllegro, a company that was accomplishing...

On an other blog I found some interesting analysers like: SQL Server 2005 Best Practices Analyzer The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a predefined list of SQL Server 2005 recommendations and best practices...

Para quem não conhece, a SQLPass é, segundo o próprio site:   "uma associação independente, não-comercial, dedicada a apoiar, educar e promover o Microsoft SQL Server. De grupos de usuários locais, grupos de interesse especial (SIGs) até webcasts e o PASS Community Summit - o maior evento...

Today one of my friend installed reporting services on his machine and got this error while trying to access the report server - The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see...

Very often people who works with SQL Server database get the following error when they trying to open database diagrams after restoring database from back up: Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page...