SQLServerCentral.com has now launched it's third Resource Center. This one focuses on giving the reader everything they need to know about licensing SQL Server. All links in this area are user contributed.
Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!
LockwoodTech announces release of Auto-Audit 2.0, an entirely redesigned upgrade to it's popular SQL Auditing tool. Version 2.0 supports plug-in, customized audit architectures, scriptable trigger templates, a trigger and data management module, real data reports, and online analysis of audit data with grouping analysis.
The second part of Steve Jones's series on programming and manipulating strings in T-SQL.
In this article by Randy Dyess he shares with you the script on how he audits his environment and outputs reports of the permissions that users have.
SQLServerCentral.com this week launched its second Resource Centers. This time, focusing on DTS. The DTS Resource Center focuses on tracking bugs, articles and books from throughout the Internet.
The Microsoft® SQL Server™ 2000 Driver for JDBC™ is a Type 4 JDBC driver that provides highly scalable and reliable connectivity for the enterprise Java™ environment. This driver provides JDBC access to SQL Server 2000 through any Java-enabled applet, application, or application server.
If you haven't changed the SA password on your SQL Server, you may be soon paying the price. Beginning last week, an old worm has come back in full force, infecting about 100 SQL Servers an hour. Reports of heavy port 1433 scanning began in early may but by the 22nd, the virus really began to take its hold on systems with no SA password.
Here's a general overview for creating and editing stored procedures. Head over to the discussion forum for this article and present your creative ideas for using this powerful feature of SQL Server to the SSC community.
Andy did "Under the Covers" last week, what the heck will it be next week? Read this article to see how maintenance plans update statistics, rebuild indexes, and remove free space from your databases. Add your comments to the article, maybe even a suggestion or two for better titles!
Yes, you’re reading that right, we’re going to download a report that cannot be...
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Comments posted to this topic are about the item Poor Name Choice
Comments posted to this topic are about the item Getting the Indexed Columns
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers