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
513 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
629 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,258 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
876 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
521 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
631 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
720 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
361 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
873 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
737 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers