Under Appreciated Features
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.
Hyper-V Guests
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
Linqpad and StreamInsight
Slightly before the announcement of StreamInsight being available for Linqpad I downloaded it from here. I had seen Roman Schindlauer demonstrate it at Teched and it looked a really good tool to do some StreamInsight dev. You will need .Net 4.0 and StreamInsight installed.
Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)
One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...
Wait statistics, or please tell me where it hurts
How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?
We Are Not a Meritocracy
Today Steve Jones reminds us that talent and technical skills are not necessarily enough to advance your career and that you ought to remember to work on other types of skills that you may want to improve.
Do IF statements cause recompiles?
I heard this one over at SSC a while back. “Avoid IF statements in stored procedures as they result in...
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers