Spend some quality time with your Database using Database Snapshots for testing
First let’s get things straight, this post is not an encouragement for anyone to spend more time with his/her Database...
2013-08-01
508 reads
TheSqlPro.com - Ayman El-Ghazali
Indexing Fundamentals Presentation – Pending Questions Answered
On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter....
2013-07-17
627 reads
Indexing Fundamentals Presentation
**This Session has been rescheduled for July 10th @ Noon EST (16:00 UTC)** On July 10th 2013 @ Noon EST (16:00 UTC)...
2013-06-26
1,254 reads
SQL Server Management Studio Rainbow Edition
Ever wanted to know the reason behind the Database color scheme in SQL Server Management Studio? I have always wondered...
2013-06-12
864 reads
How to Avoid a Database “Heart Attack”
For the past couple of months I have been working with Ben Weiss a Digital Marketing Strategist at Infusive Solutions (http://www.infusivesolutions.com/)....
2013-06-05
519 reads
Email Response: SQL Server 2012 Planning and Architecture
I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...
2013-05-15
623 reads
Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS
A problem I face often is not knowing the size of a new table that I’m creating. I put some...
2013-04-24
713 reads
Free SQL Server 2012 Installation Guide
Everyone’s favorite four letter word is back, FREE! Yes, it is time I gave back to the community since I’ve...
2013-04-15
358 reads
SQL Server 2012 Virtual Lab with Clustering using Hyper-V
After having a great opportunity to attend a Beta course for Hyper-V with Windows 2012 at Learning Tree, I decided...
2013-03-13
872 reads
SQL Agent and the case of the missing job owner…
One fine morning as I’m sitting at my desk doing my work I review some emails about cleaning out some...
2013-02-20
734 reads
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers