DBA Education
I always consider taking seminars and technical conferences as a key component in my DBA education framework
SQL Server CLR function to improve performance of validating email addresses
I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?
Guest Editorial: And Now; a Recitation
In which Phil Factor responds to the muse and writes a poem in the style of a School Song, in which he tries to give a mention to all the top writers and forum-posters.
Creating Your Own Custom Data Collections
Continuing his discussion on SQL Server 2008 Data Collections, Greg Larsen explains how to create your own custom Data Collections.
PASS Update #3
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in one post, but I'll try to hit the highlights. The main event over the past two weeks was my first board meeting in Seattle. I arrived Monday afternoon
Semantically Controlled Any-to-Any Data Structure Reshaping
ANSI SQL can perform breakthrough any-to-any hierarchical data structure reshaping. These are transformations that are performed utilizing only the structure semantics in the data assuring correct semantic results.
The Oscars
As Steve Jones heads off for holiday, he asks a Friday poll question that should distract you from work for a few minutes.
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
Business Intelligence and a Culture of Analysis
Public sector agencies very often need to work at ensuring that their corporate cultures establish a high value on, and properly reward, a push toward analysis.
Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some changes, then begin writing the book.
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCU Menara Bidakara Telp:0821-8200-233
Telp/WA 62 8218200233 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan Lt. 1,...
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers