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,733 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,337 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,199 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,484 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,772 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,356 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,100 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,281 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,214 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers