SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...
2015-10-19
835 reads
Blog Posts
SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour
Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...
2015-10-19
16 reads
Webinar with PernixData – Tuesday at 1PM Pacific
Join PernixData and me tomorrow at 1PM Pacific for a webinar discussing an exciting technology from PernixData!
In-memory computing is gaining...
2015-10-19
314 reads
Columnstore Indexes – part 69 (“Operational Analytics – Disk Based”)
Continuation from the previous 68 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is dedicated to one of...
2015-10-18
531 reads
Step by Step SSIS Multicast Transformation TIP #121
Dear Friends,
This is another post in the series of step by step SSIS ,Zero to hero series. In this post...
2015-10-18
2,813 reads
The Whirlwind That Is October – Part 2
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-10-18
384 reads
A New Achievement
To celebrate a recent achievement, I have decided to create a whole new section to my blog that will be...
2015-10-17
524 reads
SQL Saturday #437–Boston BI Edition 2015–You Can Still Analyze Data with T-SQL
Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and...
2015-10-17
529 reads
Step by Step SSIS–Union ALL tip # 119
Dear All,
In the series of zero to hero SSIS series this is one of the simplest transformation control which...
2015-10-17
1,134 reads
020 – A Foolish Decision - Syndication – WaterOx Consulting
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
461 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
Communication, For Incidents and Life
Comments posted to this topic are about the item Communication, For Incidents and Life
PostgreSQL psql Meta Commands: Tables
Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables
Building a Support Ticket Triage Report with IIF() and CHOOSE() in SQL Server
Comments posted to this topic are about the item Building a Support Ticket Triage...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers