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.
Company Rewards
Is there something that your company could do for you that would show that they valued your employment? That you were somehow important to them? Answer this Friday's poll.
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers