Tags » Microsoft SQL Server

Using Alias with DELETE and UPDATE

Perhaps I should just rename this blog to My SQL Blog.  I haven’t done any real programming entries in here in what seems like years. Anyway, here is the latest tidbit that I thought I’d drop in here for my future reference. 188 more words


Speaking on ETL Security

I will be giving a presentation on ETL (Extract, Transform, Load) security at two user groups in the coming weeks.

Securing the ETL Pipeline

We’re going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. 109 more words


Enforcing Mutex On A SQL Server Database - Part 2

In May I wrote about how application-level mutual exclusivity could easily be implemented on SQL Server by using sp_getapplock and sp_releaseapplock:

  • sp_getapplock tries to get a lock and returns one of a possible set of values which indicate various forms of success or fail…
  • 826 more words
Microsoft SQL Server

SQL Server specific data types

CodeFluent Entities can use SQL Server specific data types such as Geography, Geometry and HierarchyId.

The first step is to register “Microsoft.SqlServer.Types.dll” into the model: 266 more words

Developing Using CodeFluent Entities

Why am I getting a primary/unique key violation?

This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there may be more I don’t know) for seeing a primary key error. 711 more words

Microsoft SQL Server

PowerShell : Call SQL Server Query from powershell

I assume that reader of this post has some basic knowledge of PowerShell script and its environment setup.

Some days ago by boss asked me combine power of SQL and PowerShell. 148 more words


Customize the view at database diagram to manage the proper relationship between tables

Hi Folks,

when designing tables and there relationship in a database, i like to use database diagrams to define foreign key relationship. but if its only shows the column name than some time its difficult to assign foreign key relationship. 165 more words

Microsoft SQL Server