Installing SQL Server Reporting Services is just the first step in building the foundation for a solid Reporting Services instance. The second step in the process is configuring Reporting Services to conform to the particulars of your environment. These configurations are made to the RSServer.config file via the Reporting Services Configuration Tool.
The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions.
In SQL Server 2000 or any relational database, the concept of NULL can be both confusing and hazardess to your employment. Not understanding how to work with NULLs can lead to incorrect responses to queries and poor business decisions being made. New author Michael Coles brings us four rules that can help you work with NULL values in your tables.
We recently ran a survey at SQLServerCentral.com and got over 600 responses. Here are the results and some commentary from Steve Jones
As databases grow, we store more and more types of data. This Friday's poll asks what types of data you don't want to store.
This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports. It provides an overview of some Reporting Services features, answers common chart design and feature questions, and includes advanced examples of how to design better charts.
In Part 1 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
LINQ to Objects and LINQ to Entities have an arsenal of Standard Query Operators that operate on sequences to perform a wide variety of operations.
Part two of the interview looks at some design decisions in building a warehouse as well as some of the tools available.
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Spring Connections and Learning at...
Comments posted to this topic are about the item Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers