Creative SPAM
SPAM permeates all aspects of our lives. Steve Jones takes a poll today about which messages might have caught your eye.
Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
Bootstrap
Steve Jones talks about starting your own business and some of the challenges and advantages.
Build Great Looking Excel Spreadsheets
Exporting data from your database and building reports is easy with Reporting Services, but sometimes you need to use other sources
SQL Server User Group in Luxembourg
A new SQL Server user group is starting up in Luxembourg. Be sure you read this if you are in the area and want to participate.
SQL Server Schema Binding and Indexed Views
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
Testing Service Pack 3
Who is responsible for Service Pack testing? Ultimately it's Microsoft, but Steve Jones reminds us we make a difference as well.
Blogs
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
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....
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