Early PHP applications commonly used mssql_connect, mssql_init, and mssql_bind. Those functions belonged to an obsolete extension and should not be copied into a new application.
Category: Root
Nov 10
Using C# with SQL Server: Relationships, Procedures, and Safe Parameters
C# applications typically access SQL Server through ADO.NET. A reliable design starts with proper relational constraints, calls stored procedures using typed parameters, and manages connections predictably.
Nov 10
Adding Custom Code to SQL Server Reporting Services Reports
A paginated report can often meet requirements using report expressions and dataset queries. Custom code is an advanced option for reusable calculations or formatting that the standard expression language does not conven
Nov 10
Managing Product Prices and Updates in SQL Server
Price changes require care because incorrect UPDATE statements can modify every row, break reporting, or overwrite valid historical prices. This tutorial outlines a controlled update workflow.
Nov 10
Exploring SQL Server Database Objects for Product Management
A product-management application often uses tables for products, categories, inventory, and prices. Learning how to inspect SQL Server objects helps developers understand both the data model and the application’s behavio
Nov 10
Moving SQL Server Stored Procedures Between Databases Safely
Copying a stored procedure to another database requires more than transferring its text. Dependencies, schemas, permissions, compatibility, and deployment order also matter.
Nov 10
Create and Deploy a Paginated SQL Server Report: A Step-by-Step Overview
Paginated reports are designed for precise, printable layouts such as invoices, statements, and operational summaries. A typical report combines a data source, a parameterized dataset, report layout, and deployment.
Nov 10
Data Mining with Excel and SQL Server: Legacy Tools and Modern Alternatives
Excel and SQL Server have been used together for extracting, cleaning, exploring, and modelling business data. It is important to distinguish current analytical workflows from historical SQL Server Analysis Services data
Nov 10
Learning T-SQL: Dynamic Queries, Stored Procedures, and Cursors
T-SQL extends SQL with variables, conditional logic, procedures, and server-side control flow. This hands-on tutorial connects these features to a simple product database.
Nov 10
Monitoring SQL Server with Windows Performance Monitor and Resource Monitor
SQL Server performance problems may originate in CPU pressure, memory constraints, disk latency, network delays, inefficient queries, or blocking. Windows monitoring tools help separate symptoms from their causes.
