A Page-Splitting Headache - Page Split Mini-Series
Page splits are a normal occurring process in an OLTP system. However, too many page splits can cause performance issues...
2014-09-03 (first published: 2013-07-08)
9,677 reads
Robert Pearl
Get SQL Server Info - Quick Tip & Script
There
are a number of ways to collect basic information about SQL Server, its
version, edition and other top-level properties. What is...
2014-07-28 (first published: 2014-07-17)
11,335 reads
Congratulations MVPs - Team USA (the other world cup)
While the World
Cup was still going on, and the folks in the USA had a real reason to root
for the...
2014-07-02
1,190 reads
SQLSaturday #294 DBA 4 Dummies - post event commentary...
Had an awesome time at #SQLSat294 in Philly (MS HQ in Malvern, PA to be exact). Was great seeing the...
2014-06-10
1,545 reads
Happy Memorial Day - Freedom is Never Free!
Well, as all folks in the United States know, this weekend we celebrate Memorial Day, Monday May 26, 2014. While...
2014-05-23
1,477 reads
T-SQL Tuesday #54 - Interviews and Hiring
Well, it's that time again! It's TSQL Tuesday #54, and its about Interviews and hiring. I'm writing this free style...
2014-05-16 (first published: 2014-05-13)
3,770 reads
Summer SQL Server & Database Events In and Around NY
Summer SQL Server & Database Events In and Around NY-
Happy May everyone!
Hope those April showers will bring us May flowers! ...
2014-05-01
2,354 reads
DBAs should be on CLOUD 9 - IT Trends
For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an...
2014-03-18
2,098 reads
Configuring Native Mode SSRS on local host
OK, so you successfully installed SQL Server and you selected to deploy SQL Server Reporting Services using the default installation...
2014-03-06
17,236 reads
Tonight: NYC Metro User Group Presents Kimberly L. Tripp & Jonathan Kehayias
Tonight: The NYC Metro User Group Presents Kimberly L. Tripp (blog) and Jonathan Kehayias (blog)!
Let's welcome them to NYC! Now at...
2014-02-25
1,213 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers