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
507 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
624 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,252 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
862 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
620 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
711 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
355 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
871 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
728 reads
Blogs
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Speaking at PASS Summit 2025
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers