Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,130 reads
Blog Posts
Syncing your calendars
I have a desktop computer, a laptop, and a iPhone. I frequently add meetings to my Outlook calender on my...
2012-05-30
1,967 reads
Turn on Instant File Initialization for SQL Server Performance
Without Instant File Initialization turned on, each time a data file on SQL Server 2005 and above is created or...
2012-05-30
4,369 reads
Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,115 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,652 reads
Oracle Date issues with PowerPivot
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,275 reads
SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,758 reads
SSRS Performance in SharePoint Integrated Mode
I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...
2012-05-29 (first published: 2012-05-24)
4,906 reads
The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
843 reads
The Standing Desk Experiment
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,958 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