SQL Server Stored Procedures

New & Notable

Download this free guide

Free Guide: DBMS Features Overview for 3 New Popular Options

IT expert Michael Otey, explores 5 trends for SQL Server environments, what to expect in SQL Server 2019 and why it might be time to update SQL Server skills. Also, compare the key features of Google Cloud Spanner and Oracle Database 19c.

Corporate E-mail Address:
You forgot to provide an Email Address.
This email address doesn’t appear to be valid.
This email address is already registered. Please login.
You have exceeded the maximum character limit.
Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

SQL Server Stored Procedures News

November 07, 2012 07 Nov'12
Microsoft previews new SQL Server in-memory database features

Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server.
August 16, 2006 16 Aug'06
Saying yes, no or maybe to stored procedures

The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project.
February 09, 2005 09 Feb'05
Why use stored procedures?

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

stored procedure

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
Microsoft SQL Operations Studio eases SQL Server admin tasks

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
library

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.

Pros and cons of using SQL Server audit triggers for DBAs

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.

In-memory OLTP reborn with SQL Server 2016

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
Best practices for preventing a SQL injection attack

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
Top tips and tricks for SQL Server database development

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.

Troubleshoot SQL Server database performance with T-SQL

Basit Farooq provides eight tips for optimizing T-SQL code to prevent SQL Server database performance bottlenecks and to tune database applications. Continue Reading
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?

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
SQL Server stored procedures supercharged in recent, upcoming versions

Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Continue Reading