2015-10-19
7 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...
2015-10-19
830 reads
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
4 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
306 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
525 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,792 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
379 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
503 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
525 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,117 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers