PASS DBA VC Session 25th June
It’s always an honour to be able to speak at an event, but events can be expensive to attend and...
2014-06-24
687 reads
Blog Posts
Space Used by Database Files
Retrieve data about size and space used for all the files in the current database with this script.
Some tips on...
2014-06-24
761 reads
SQL Server – Script to Configure TempDB Files per Number of Logical Processors
In order to reduce Tempdb contention one of the best practices is to maintain multiple sized Tempdb data files, matching the...
2014-06-24
1,241 reads
Exploring Excel 2013 for BI Tip #15: Locking Slicer Position
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2014-06-23 (first published: 2014-06-18)
4,292 reads
ExpressProfiler: Yet another "when and why" story.
Core of ExpressProfiler was born about 8 years ago when I worked for a company whose mission was the migration...
2014-06-23
748 reads
Introduction to Latches in SQL Server
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-06-23
2,806 reads
Last Weeks Top “Reading” Links #89
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-06-23
487 reads
Plagiarism: A Community Destroyed
Personal Thoughts
Just to be clear, I don't expect everyone to have my same thoughts. I personally fully support SQLServerCentral and...
2014-06-23
481 reads
Reading, Writing, and Riskmetic-Question of the Day
Reading, Writing, and Riskmetic is another Question of the Day, this one about how to allow developers to understand performance...
2014-06-23
539 reads
sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
689 reads
Blogs
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...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
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