When installing SQL Server 2008 R2 on a Windows XP (or, according to the comments, Windows 7) development machine that has been around for quite some time, I got an error stating an unhandled exception occured in the application (see image). The error showed up directly upon startup and read: An error...
This walkthrough covers the migration of tables and primary/foreign keys that is a reasonable assumption when accessing data using ORM. Prerequisites Visual Studio 2010 (should also work with Visual Studio 2008 with .NET 3.5 SP1 applied). Devart dotConnect for Oracle (formely known as OraDirect.NET)...
We had a discussion about CQRS and event sourcing, and there was a concern raised about cost of event versioning. Yes, with event sourcing we can get rid of relational database schema on the write side of the system, saving us from the maintenance of the SQL schema, but won’t the saved effort be used...
Today I came accross a problem where nvarchar data got larger than the maximum that can be stored in a record. I had to convert to a ntext column and append the data to it. I quickly found out that I needed to use the UPDATETEXT function in combination with the TEXTPTR and DATALENGTH functions. When...
I want to perform bitwise operations on a varbinary colum. As it contains binary data I though that it would work but it didn't This example works: declare @a int declare @b int set @a = 1 set @b = 2 select @a | @b But this wont: declare @a varbinary(100) declare @b varbinary(100) set @a = 1 set...
Sometimes we have objects which have timespans in our database, such as valid dates for coupons, or say active dates of a sale, or trigger, or some other event. in searching through these, we may want to give a user the ability to see all of these objects which were 'active', or whose timespan...
Seems like I missed the announcement, almost a month ago now, that SQL Server 2005 SP2 was available. Details here: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
SQL Server CE (previously called SQL Mobile and SQL Everywhere) is a very lightweight SQL server that can run everywhere hance the name "SQL Everywhere". It is targeted to replace the XML data files in a lot of smart client apps. It's realy, realy, realy great, but the problem is that a lot of tools...
Although I found another blog about this (which is already a few months old), I thought it is worth to be mentioned again. Red-Gate introduced intellisense for SQL server . And it's free! I'm working a lot with SQL server these days and I found it extremely handy because the table and field names are...