A walk-through of creating the Activity Tracking template using Extended Events.
It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...
2015-06-15 (first published: 2015-06-09)
2,326 reads
Blog Posts
Adventures with NOLOCK
Some of the beauty of being a database professional is the opportunity to deal with our friend NOLOCK. For one reason or another this query directive (yes I am calling...
2015-06-15
4 reads
Check out SIOS iQ!
I’m learning how beneficial SIOS iQ is to your virtual SQL Server environments, and you should too.
SIOS iQ is a new...
2015-06-15
523 reads
Columnstore Indexes – part 56 (“New DMV’s in SQL Server 2016”)
Continuation from the previous 55 parts, the whole series can be found at http://www.nikoport.com/columnstore/
Before starting to dive into the specific...
2015-06-15
678 reads
Marketing Materials for PASS Chapters
I brought this back with me from SQLSaturday South Florida. It’s postcard sized and laminated, and information dense in a...
2015-06-15
412 reads
Notes From SQLSaturday #379
Notes from the trip:
Made the trip down without stopping and without getting stuck in traffic – a first!Attended speaker dinner on...
2015-06-15
350 reads
Rename a database
Renaming a database isn’t something you do frequently but it does have bit of a gotcha. First of all let’s...
2015-06-15
608 reads
See Two Queries at Once in SSMS
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-06-15
2,503 reads
Sneak Preview – Podcast 008 - WaterOx Consulting
Reading Time: 1 minutesLet’s Play A Game! So, just to tickle your fancy, here is...
The post Sneak Preview – Podcast 008...
2015-06-15
417 reads
SQL Server 2016 – Stretch Databases
One of the feature I’ve been interested in that’s coming with SQL Server 2016 is the stretched database. The ability...
2015-06-15
526 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers