Tags » Microsoft SQL Server

The clustered index columns are in all of the non clustered indexes.

Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes on the same table? But don’t take my word for it. 1,130 more words

Microsoft SQL Server

Using SQL Server datetime2 data type

CodeFluent Entities supports DateTime2 since the build 714. A datetime2 defines a date that is combined with a time of day that is based on 24-hour clock. 215 more words

Developing Using CodeFluent Entities

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