Gunnar Peipman's ASP.NET blog

ASP.NET, C#, SharePoint, SQL Server and general software development topics.

Sponsors

News

 
 
 
DZone MVB

Links

Social

Browse by Tags

All Tags » SQL Server (RSS)
How my company uses Windows Azure in development process
I have used MSDN Ultimate Windows Azure benefit from the day it was made available and from this day I have more and more used Windows Azure on my everyday’s development work. I’m building mostly web-based applications and services and Windows Azure fits...
Using Visual Studio database post-deployment scripts in practice
Visual Studio database projects support database post-deployment scripts you can use to make additional modifications to database or to insert some test data. In my work I use database projects and post-deployment scripts very often. In this posting I...
Using Visual Studio database projects in real life
Visual Studio database projects are good to support software development. I have successfully used database projects for years and I think it’s time to share my experiences also to global developers audience. In this posting I will introduce you how to...
Creating dynamic pivot reports on SQL Server
In one of my current projects I have some pivot reports that show count of issues in different states. Grouping depends on report. States are dynamic – admins can define new states and save them to states table. This means that I cannot hardcode names...
The selected database contains foreign keys that create a cycle
You may get the following error when creating data scripts with MSSQL 2008: The selected database contains foreign keys that create a cycle. Publishing data only is not supported for databases with cyclical foreign key relationships . This problem is...
Comparing and updating database schemas using Visual Studio 2010
During development it is possible that database schema changes and usually it changes are same sure to come as tax office and death. Later we need to reflect these changes also to live databases and it is not very easy task to do manually. In this posting...
SSAS: Using fake dimension and scopes for dynamic ranges
In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had...
Posted: Dec 11 2010, 02:21 AM by DigiMortal | with 5 comment(s)
Filed under: , ,
SQL Server: How to insert million numbers to table fast?
Yesterday I attended at local community evening where one of the most famous Estonian MVPs – Henn Sarv – spoke about SQL Server queries and performance. During this session we saw very cool demos and in this posting I will introduce you my favorite one...
Generating data for tables in table per class inheritance tree using data generation plans
I am using Visual Studio database project and data generation plan to populate my database with random data. In my database there are some tables for table per class inheritance mapping and there are some additional steps required to get these tables...
MSSQL: Copying data from one database to another
I have database that has data imported from another server using import and export wizard of SQL Server Management Studio. There is also empty database with same tables but it also has primary keys, foreign keys and indexes. How to get data from first...
More Posts Next page »