Database Mirroring From SQL Server 2005 to SQL Server 2008 R2 SP1 CU3
I recently ran into a production instance of SQL Server 2005 SP2 (Build 3042) that is running in a two...
2012-01-12
2,665 reads
Glenn Berry
Scaling SQL Server Presentation from SQLSaturday #104 Precon
On Friday, January 6, 2012, I got the opportunity to present an expanded version of my “Scaling SQL Server” presentation...
2012-01-12
1,168 reads
New TPC-E Benchmark for HP DL385 G7
Somewhat unnoticed during the holiday season, HP has submitted a new TPC-E benchmark for the DL385 G7 two socket database...
2012-01-04
1,631 reads
SQL Server 2008 Diagnostic Information Queries (December 2011)
Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some...
2011-12-29
2,029 reads
SQL Server 2008 R2 RTM Cumulative Update 11
On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I...
2011-12-26
1,459 reads
SQL Server 2008 R2 SP1 Cumulative Update 4
On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I...
2011-12-26
3,047 reads
CPU-Z 1.59 Released
One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is...
2011-12-12
1,230 reads
Scaling SQL Server – SQL Saturday #104 Precon
I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6,...
2011-12-04
869 reads
Tuesday Hardware Tidbits, Nov 29, 2011
Since Microsoft is moving to core-based licensing for SQL Server 2012 Enterprise Edition, with a minimum of four physical core...
2011-11-30
944 reads
Promoted to Master Group By Thomas LaRock
SQLRockstar Thomas LaRock has updated his blogger rankings this month, and I was pleasantly surprised to see that he had...
2011-11-29
785 reads
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Multi-State Payroll Tax Issues 2026
Prepare for 2026 with this essential multi-state payroll tax issues 2026 webinar from Professionals...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers