SQL Server Stored Procedures
New & Notable
Stored Procedures
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
-
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
-
trigger
A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. Continue Reading
Manage SQL Server Stored Procedures
Learn to apply best practices and optimize your operations.
-
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
-
SQL Server source code analysis and management adds database security
Manage and protect your SQL Server databases by implementing source code analysis. Source code is the foundation of any application, and integrating methods to test and debug this code adds a key layer of security. IT security specialist Kevin Beaver explains why source code analysis should be a fundamental component of your SQL Server security measures. 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.
-
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
-
Finding your way around SQL Server data preservation
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 limitations. Continue Reading