-
I really can't wait for the BizTalk Adapter pack. Finally we get a good SQL adapter capable of almost everything. I had concurrency problems in the past cause the Adapter always has a transaction level Serializable. Now with the new SQL Adapter the transaction level is settable. Have a read of the...
-
Since Team Foundation Server (TFS) uses SQL Server Analysis Services (SSAS) as its repository for all kinds of info, people are interested to expose the data through Excel or SQL Server Reporting Services (SSRS). SSAS doesn't expose itself through the HTTP protocol by default, but this can be configured...
-
Microsoft SQL Server finally gets a logo! Check out the revamped homepage of SQL Server 2008 . We have just released the Release Candidate 0 for download . I say "we", because I work for Microsoft since May 1, 2008 ;)
-
Just found this on Dan''s Blog , the SQL Server 2008 CTP is available for download. If you're interested in the latest version of SQL Server, then follow any of the links below. The download can be found here If you want to know what's new in this CTP, look here Product information, marketing...
-
In my current project, we calculate the status of tasks that a user needs to do and store the status in a table. This happens on a daily basis. Once every week, we calculate which items are overdue and inform the user by email to take appropriate action. However, sometimes our users complain that they...
-
Well I am not going to say what's better or what I prefer, but I can only give my view of things. What everybody seems to forget is that an external person with very good understanding of SQL ( commonly know as a DBA ) can solve performance problems when stored procedures are used. And I totally...
-
When looking to the Stored Proscedures debate, there is always those three factors you should measure by. Productivity - Span code base over multiple staging environments is a pain and harder to maintain. - Versioning sp code is way harder than versioning application code. - Minor change to the design...
-
I was confronted with a slow performing stored procedure in SQL server this week. The procedure was to retrieve one row from a table. But before that row could be retrieved, an update procedure was called to make sure all rows in that table had the correct status. That update procedure first checked...
-
I just came across this nice little gadget that Microsoft offers to be used on your Vista desktop. It counts down the number of days until the "2008 Global Launch Wave" which will start on wednesday February 27th 2008. Windows Server 2008, Visual Studio 2008 and SQL Server 2008 will then all...
-
A couple of weeks ago I posted a post about creating a couple of data generators for DataDude . In mine first data generator I used aggregation extensibility. Microsoft divided each form of extensibility in another section. Since I created one or more instances of the standard data generator classes...
-
On June 11 and 12, I attended a 2-day Visual Studio Team Edition for Database Professionals workshop at Class-A . This event was hosted by Gert Drapers (also aka DataDude), see his blog post announcing the event. Gert discussed all the important features of the tool and some of my fellow attendees complained...
-
First a pre requisite: You need to have asp.net Ajax installed. Get it at: http://ajax.asp.net Then we need to set up the database, there are some scripts included with the startersite. These are located in: SubSonicStarter\App_Data\Scripts To be able to execute these scripts you will need to create...
-
Microsoft is planning to release the next version of its SQL Server database, which is codenamed "Katmai," in 2008 . Everybody is waiting anxiously what this version will bring us. Like everybody I've a personal wish list for SSRS and it seems MS is working hard to fulfill this list. Rich Text support...
-
I had this annoying error when trying to add new database diagram to SQL Server 2005 i received the error Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION...
-
I was looking for a quick way to calculate the last day of the month in T-SQL and bumped into an article written by Gregory A. Larsen on DatabaseJournal.com . The article describes a number of T-SQL methods to calculate different date and time values. I used information from that article to create a...