New & Notable
SQL Server Stored Procedures News
February 09, 2005
Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind.
SQL Server Stored Procedures Get Started
Bring yourself up to speed with our introductory content
A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle. Continue Reading
SQL Operations Studio simplifies routine administration of SQL Server and Azure SQL databases, making database development and management easier for users who aren't full-time DBAs. Continue Reading
In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges. Continue Reading
Evaluate SQL Server Stored Procedures Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Using triggers to capture audit information in SQL Server can be instrumental in keeping track of database use and changes. But they aren't a perfect fit for all cases. Continue Reading
Manage SQL Server Stored Procedures
Learn to apply best practices and optimize your operations.
Microsoft's in-memory OLTP needed improvements, and they are here with SQL Server 2016. Learn about the enhancements to this query-boosting feature. Continue Reading
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out. Continue Reading
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more. Continue Reading
Problem Solve SQL Server Stored Procedures Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you. Continue Reading
Need to know what a table looked like before changes were changes were made? There are several tools for SQL Server data preservation -- SQL Server change tracking and SQL Server database mirroring among them -- each with its own uses and ... Continue Reading