SQL Maestro Offers SQLServerCentral.com Members a Discount
SQL Maestro, maker of tools for a variety of database platforms, is offering a 20% discount on their tools to the SQLServerCentral.com
community.
Analysis Services Performance Tuning Whitepape
A whitepaper on getting the best performance from your system.
Robyn Page's SQL Server Cursor Workbench
The topic of cursors is the ultimate "hot potato" in the world of SQL Server. Everyone has a view on when they should and mainly should not be used. By example and testing Robyn Page proves that, when handled with care, cursors are not necessarily a "bad thing".
A Review of Typhon III
Maintaining SQL Server security is fast becoming a big part of a SQL Server DBA's job. Longtime security expert Brian Kelley takes a
look at a security scanner: Typhon III
Using Fuzzy Lookup Transformations in SQL Server Integration Services
This article shows how the Fuzzy Lookup Transformation in SQL Server Integration Services (SSIS) can be used to make matches.
Product Review: SQL Refactor
Danny Lesandrini reviews SQL Refactor, a SQL Server Add-In that works with the new SQL Server Management Studio.
SQL Server Spotlight on Bob Dorr
We continue with our look at the people behind SQL Server with a very interesting interview from one of the senior support
engineers, Bob Dorr.
SQL Server 2005 Command Line Tool "SQLCMD" – Part I
This series will illustrate the various ways of using the SQL Server 2005 command line utility “SQLCMD”.
Introduction to message-based applications in SQL Server 2005
Tim Chapman discusses the concept of message-based applications, and the new foundation for building these applications included in SQL Server 2005.
Using Indexed Computed Columns to Improve Performance
I recently read a blog post on doing case-insensitive text searches on SQL Server 2005. The post said that an index on a computed column might be used even if the computed column itself wasn't used in the WHERE clause. I was curious to test that and see how far I might take it.
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