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
834 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
12 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
313 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
530 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,806 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
383 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
515 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
526 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,125 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
460 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers