Browse by Tags
All Tags »
.sqlserver (
RSS)
At work we had an issue where our sql performance (SQL Server 2005) was very slow - much slower than we needed and everything looked OK but in the production environment (to which we don't have access - rightfully) things were not ticking as they should be. We had a requirement to be able to process ~200K / hour and we were barely managing ~ 44K / day...
Believe it or not, approximately 5 months are SQL 05 went RTM, Microsoft has released the first service pack for that which includes the database mirroring functionality. You can get a list here of all the things fixed and the press release here . I have not tried this myself yet, so cannot comment, but I wonder if it would cause any issues to BizTalk and...
WinITPro is reporting that SQL Server 2005 will ship without data mirroring as they won't be able to meet the ship date in November this year. This will be a big blow as I know some people already incorporating that in their design of some solutions. What is interesting is why did it take MS so late to realise they won't be able to make the feature for RTM...
Denis has an addin to Reflector for SQL Server 2005 (Yukon). that can be used to browse .NET assemblies stored in a SQL Server 2005 (Yukon) database. You can connect your local Reflector installation to a remote SQL Server instance, list the databases and its assemblies and download them directly into .NET Reflector. Once my issues with Whidbey are resolved...
This is my second part of the SQL Server 2005 posts; you can read the first part on Hosting the .NET runtime in SQL Server. In the CLR certain conditions such as out of memory, stack overflow, etc can bring down an app domain (or process), this cannot be allowed in SQL Server 2005 when latter is acting has a host (for the CLR) as it will affect reliability...
I finally got around to trying out SQL Server 2005 (a.k.a. Yukon) and reading up a little on how it operates under the covers. I had earlier discussed SQL Server Express. This is my first of series of posts where I will be highlighting some of the new things a developer can do in SQL Server 2005 from a .NET perspective, since there are many DBA's who live...
If you don't know what Wings is, then read the earlier part of this series. There have been a number of changes since Part 1 and this part, namely the release of a new Longhorn build. For the Assemblies you will usually need the System.Storage.WinFS.dll assembly in most of your projects. It represents the basic interfaces and classes (for example, Item and...
I got a bit of time this weekend to play with SQL Server Express (SQE) and here are some more details on it. I installed this part of Whidbey 2005. By default the setup installs this under the SQLEXPRESS instance name, so to connect to it you would use something like “ machinename\SQLEXPRESS ”. The API set for SQL Server Express is the same as...
SQL Server 2005 Express Edition is a lightweight, redistributable version of SQL Server 2005 that is optimized to provide a data store for small-scale data-driven applications. Per Microsoft, “ It is designed for building simple, dynamic applications. SQL Server Express helps developers build robust and reliable applications by providing a powerful...