I love Database Project, introduced with Visual Studio 2008, and with SQL server 2012 they will be replaced by the Data Tools (codename Juneau), so I have a couple of links to share about this argument. In this link you can find a table that compares all the features. As you can see, actually, one [...]
Continue reading about Some interesting links for SQL Server 2012 data tools
I’have a table with some dirty data, if you select it seems that everything is ok, but since it was imported from an external source, it happens that some string field actually ends with strange non alpha char. The symptom is that I have some strange behavior on some data, then I verify what is [...]
Continue reading about Trim all non-alpha character from SQL string
I have a database with several Gigabyte of data and query performance is usually a issue, so we need to take great care of indexes and DB optimization. Since the vast majority of data access is done with NHibernate, we have also some read-only view that we use to easy the access from the views. [...]
Continue reading about Always pay attention to uniqueness to SQL Index
Today I needed to move some SSIS packages that actually runs on the same server where the database resides, to another server dedicated to run SSIS packages. I do not have a domain and the second server is simply in the same network as the first server. I simply reconfigured a Job to run the [...]
Continue reading about Run SSIS package from another server in workspace
This morning I spent 20 minutes completely puzzled on a stored procedure in Sql Server. This stored procedure is not too complex, it moves data incrementally on a denormalized table to speed up some searches. The concept is simple, I run a series of queries to obtain a list of the ids of modified entity [...]
