Using Full Text Search in SQL Server 2008
SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in a SQL Server table
No One is Safe
A funny example of SQL Injection has Steve Jones reminding us that every application needs to protect itself.
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
Connecting Your Zend Framework Application to Microsoft Azure
After years of using PHP content management systems and a variety of custom-built PHP content management solutions, PHP Guru Jason Gilmore concluded that no solution effectively offered both the fundamental features of a content management system (CMS) and the flexibility of a web framework.
More Support for Customers
A change in the support policy from Microsoft is a good thing, Steve Jones notes. Now you can still get help if you haven't been applying service packs.
New SQL Saturdays Coming
Quite a few new SQL Saturday events were announced recently in Louisville, Phoenix, and Raleigh.
Smart Virtualization
With so many people looking at virtualizing their environments, it's easy to assume it's easy to get done. Steve Jones, however, points out some advice from a very performance oriented company: the NYSE.
Light Weight Monitoring using Extended Events
Extended events provide DBAs with a new lightweight tool to monitor SQL Server performance.
TSQL Challenge 28 - SELECT TOP N articles from each category from a SQL Server 2000 database
The challenge is to write a query that returns the articles to be displayed in the home page of the website. N number of articles from each category is to be selected where N is configured in the Categories table. Each category should select the most recent N articles. ArticleID can be used to identify the most recent articles. An article with a higher number indicates a more recent article.
Clustered instance will not start after removing builtin admins
After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things.
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers