The discussion of performance and throughput came up a few times in discussion with customers at PDC this year. Here are a few important things to understand when evaluating SQL Azure performance. SQL Azure Architecture and Provisioning Model: The details...

Hi folks, I am back and blogging again about my new cause. Your data in the cloud with SQL Azure. Here is what I have been up to the last few years I was gone; HealthVault . HealthVault is a health information database for the consumers. We shipped the...

Here is my blog post at the ISV Team blog. DEFAULT_SCHEMA setting helped in a number of cases, especially with legacy code. It could help you if have upgraded from an earlier version of SQL Server and you are not parameterizing your trivial queries. http...

Greetings, my pass talk is now available at sqlpass.org for download. The session was on some of the great hidden parts of sql server that served us well in real life imlpementations. There are quite a few I could have mentioned but I picked the top 10...

Mars and Transactions MARS (multiple active result-sets) does allow multiple commands to be active on the same connection, however there are some limitations on allowing multiple transactions to be active. I received a number of questions around...

FSG Dev. Conf. 06 is over. Thanks to the folks who attended. Here is the presentation and the Demos as promised for the SQL Server Data Integration - Turning Data Into Intelligence . "OPENROWSET BULK" and "Fuzzy Lookup" were the champions of the presentation...

ISV Advisory team is starting to blog as well. Good one to bookmark! http://blogs.msdn.com/mssqlisv/Default.aspx

As the optimizer gets more and more sophisticated, cost of optimization naturally increases. When that is the case; simple and forced parameterization comes to the rescue (much like you neighborhood plumber). These features simply allow the reuse of execution...

Well, many lines of code and 5 years later, SQL Server 2005 is out the door. I have been in the lab benchmarking with close partners lately and I am certainly impressed with the results. With all the added sophistication and new features, we are still...

I have not had too much time to blog lately but here is a great result from SQL Server 2005 x64 on Dell Poweredge 2800 with Dual-Code Intel Xeon. http://www.tpc.org/tpcc/results/tpcc_result_detail.asp?id=105092601 The $0.99 Price/Performance number...

I shared some of our experiences with financial services industry implementations in a 90 min webcast. I touched on 5 distinct scenarios where SQL Server 2005 may help financial services partners and customers. - Cost: full lifecycle of a solution - Development...

I recently came across a few good samples: Async Task Management: http://www.microsoft.com/technet/technetmag/issues/2005/05/ServiceBroker/default.aspx Very Basic Trading System: http://blogs.msdn.com/rushidesai/archive/2005/05/19/420212.aspx ...

I recently started reading about Algorithmic Trading. There is a huge potential here for computer science. According to this presentation by Carl Carrie - JPMorgan & Scott Atwell - Manager of FIX Trading and Connectivity: (http://www.jandj.com/presentations...

I promised to make the presentation and demos available here and here they are: Presentation: http://www.tsqlnet.com/downloads/fsgdevcon/fsgdevcon_presentation.zip Data Integration Demo: http://www.tsqlnet.com/downloads/fsgdevcon/fsgdevcon_demo...

Next week, I am heading out to the financial services developer conference to deliver a SQL Server 2005 presentation. The toughest part of delivering a talk on SQL Server 2005 is to find a way to fit it all into a 90 minute slot. You can talk about individual...

I don't like pointing to other blogs too much but I want to make sure noone misses these: SQLOS Caching by Slava SQL Testing from Ed Triou and Andre Milbradt Enjoy!

SQLCLR is the Swiss Army knife with 1000s of foldable parts. You cannot beat the ability to plug right in and reuse good set of framework functions from the DBMS. If your DBA is one of those that say; “no way. I am not letting C# into my database”, this...

I like this term: it describes the main objective well... and as a matter of fact, this is a very popular problem many are trying to solve. I recently spent a week in NY and had a chance to talk to a few partners and customers in the financial vertical...

If you'd like some help in going to sleep at night, try thinking about how concurrency is controlled behind the scenes in SQL Server. No guarantees however: you may wake up in the middle of the night having nightmares about blocking and deadlocking. Seriously...

This is something I came across a few times within the last few weeks so thought I’d share the findings: You probably heard about ranking functions by now. However you may have a missed this great benefit ranking functions bring to easing a complex scenario...

You probably hear about exception handling in TSQL already but here is a neat use of the feature: TSQL exception handling is very close to the top when it comes to popularity of the new TSQL features. The ability to handle exceptions without having to...

Testing 1,2,3... Quick Intro: I am a program manager in the ISV team in SQL Server development. I try to ensure SQL Server is well crafted to solve the underlying issues in the financial vertical. I've recently left the field organization where I worked...