-
I see a lot of code from other developers and every now and then you see some real gems. Today I was looking at a query to see if and how it could be optimised. One of the things I did was look at the query plan to see if indexes were used for various joins. One of the items in the plan made me look...
-
In my current project, we have a tables where the primary key consists of two values. Based on the result of a query, we needed to delete a few rows from that table. The query returned the two key values and we needed to join that information in the delete statement. It's not rocket science, but...
-
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...