AJAX Stock Symbol Drop-down List
A web look up of a huge list of stock symbols from an MS SQL database.
10 tips for sorting, grouping, and summarizing SQL data
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
A Discount on SQL Populator
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
CLR: 9 Reusable Parallel Data Structures and Algorithms
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
SQL Server Spotlight on Len Wyatt
Project REAL was an amazing undertaking by Microsoft to put SQL Server 2005 to the test in a real environment. One of the main people working on this was Len Wyatt, who agreed to take a few minutes and share some thoughts with us.
To Wrap or Not to Wrap
It's not a string manipulation article in T-SQL, but it is SQL Server related. Check out what Steve Jones has in store for the PASS 2007 Summit for the SQLServerCentral.com community..
XML Notepad with SSMS
XML is becoming more pervasive in all of MIcrosoft's product, including SQL Server. Jay Dave brings us a short look at how one of their lesser known tools, the XML Notepad, can be used by SQL Server DBAs.
Keep a check on your IDENTITY columns in SQL Server
Be sure you don't end up with arithmatic errors in your identity columns from a SQL Server MVP.
A T-SQL Regular Expression Library for SQL Server 2005
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
ADO.NET Entity Framework Overview
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers