Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table
Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment...
2014-10-06
947 reads
Blog Posts
Carolina Technology Conference: Presentation Materials
For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...
2014-10-06
794 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time...
2014-10-06
756 reads
Does Full Backup contain data inserted during backup ?
Question : When you take full backup, do it capture data till the time backup start time or till the time backup end. Answer : Full backup capture database...
2014-10-06
8 reads
Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,173 reads
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
845 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
703 reads
SQL Server Days 2014 – Slide deck
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
510 reads
Thoughts on the Student to IT Pro Seminar
Miscellaneous notes as I think on this.
I’ve been reading through feedback from the students. Reading the raw feedback is interesting...
2014-10-06
758 reads
Track My Query Utility
Were you ever in a situation where you ran a query, it ran for a long time and you didn’t...
2014-10-06 (first published: 2014-10-01)
7,559 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers