Excecute SSIS package (DTSX) from C#

Standard

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. You can execute SSIS package from C# read more →

Setting up SonarQube with SQL Server on Windows

Standard

By default SonarQube comes with an embedded database, which is not recommended for production use and which cannot be scaled. This post is about configuring SonaqQube to use SQL Server instead of default database. As the first step you need to configure SQL Server. Using read more →

Error message when you open SQL Server Configuration Manager in SQL Server: “Cannot connect to WMI provider. You do not have permission or the server is unreachable”

Standard

Today while working on SQL Server configuration I faced this strange error. I was running as administrator and I know SQL Server was running. Later I found a Microsoft KB article related to this issue. This issue is because “On a 64-bit computer, you install read more →

Generate your database entities using T4 templates

Standard

Long back I wrote some post about code generation using T4 templates. This post is about generating database entities using T4 templates. This code is pretty straight forward, you are reading the app.config to get the connection string, connecting to db server using Sql Server read more →

CREATE DATABASE permission denied in database ‘master’ – SQL EXPRESS

Standard

Long back I wrote a post about Entity Framework Error – The underlying provider failed on Open. Yesterday some one told me, he is getting this error – CREATE DATABASE permission denied in database ‘master’, he is using an application pool with NETWORK SERVICE identity. read more →