Warming up Analysis Services with Preallocate
With Windows Server 2003 many people found that Analysis Services (SSAS) was slow to get going sometimes. So a preallocate...
2009-09-03
1,745 reads
Blog Posts
24 Hours of PASS was an Adventure
On July 21, just a few short weeks ago, I got an e-mail from Rick Heiges, who is on the...
2009-09-02
654 reads
Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
745 reads
Building a Better Blog
I had a great session for the 24 Hours of PASS on Building a Better Blog. Not sure how well...
2009-09-02
639 reads
Data Type Synonyms
Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...
2009-09-02
629 reads
Finally Migrating from SQL 2000
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
420 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,445 reads
How To Get Table Row Counts Quickly And Painlessley
Just a quick note to call out that I've had an article posted on SQLServerCentral that shows how to retrieve...
2009-09-02
444 reads
Nice Discounts On Microsoft Certification Exams From Prometric
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
600 reads
SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
633 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers