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,333 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
7 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
525 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
680 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
415 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
353 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
609 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,593 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
418 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
531 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Execute as failure
Security has long been a problem for me. Every time I think I understand...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers