-
I had a nice setup in my BizTalk environment. I had 4 receive locations polling for data (in the same table) and it all boiled down to execute a stored procedure with different parameters. I used the WCF adapter with SQL bindings for that. For some obscure reason, I would get timeouts in the eventlog...
-
Ever tried to do a join on text columns? Like this: SELECT * from LocationAustralie la left join steps s on la.StepText = s.Value If your tables have different collations you get the error message: Msg 468, Level 16, State 9, Line 2: Cannot resolve the collation conflict between "Latin1_General_CI_AS"...
-
Wow, April 2010 proves to be a jam-packed month of releases from Microsoft. A short list, that is bound to be incomplete: .NET Framework 4 Visual Studio 2010 Office 2010 SharePoint 2010 Data Protection Manager 2010 System Center Essentials 2010 Dynamics GP 2010 Enterprise Library 5.0 SQL Server 2008...
-
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...