Best practices for Database Programming

1. All the tables in the database have properly defined relationship using primary keys and foreign keys . 

2. Indexes should...

Between function in SQL Server

This function is used to select the values within a specified range. These values can be of Int type or...

Building The SQLSaturday Orlando Marketing Plan-Part 32

I just paused our first LinkedIn campaign, the one that was based on a functional area of IT in the...

Building The SQLSaturday Orlando Marketing Plan-Part 33

More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...

Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In the past I have been writing quite a lot on the...

Do We Care?

Today’s editorial at SQLServerCental is entitled: We Don’t Care about Data and IT Security. It’s by Brian Kelley (author, blog,...

ExpressProfiler - new release

Just released new build of ExpressProfiler.
No major changes, just cosmetic improvements - shortcut here, confirmation dialog there, new captured events (SQL:StmtStarting/Completed,...

Guest Editorial Live on SSC

My guest editorial is live on SQLServerCentral.com. My argument is a simple one: we don’t care about data and IT...

Intersection command in SQL Server

This function is used to returns distinct values that are returned by both the query on the left and right...

Last Weeks Top “Reading” Links #96

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...