More Results
-
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. Tip | SearchSQLServer.com
-
T-SQL analytic functions in SQL Server can help solve problems quickly
With the help of T-SQL analytic functions, we can quickly solve complex analytical tasks. Learn more from SQL Server expert Basit Farooq. Tip | SearchSQLServer.com
-
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. Tip | SearchSQLServer.com
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer | SearchOracle.com
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Editor's note: This is the first in a three-part series that will examine three popular versions of Microsoft SQL Server, along with the pros and cons of each. Check back next week for the second installment.
Deciding... Series | SearchSQLServer.com
-
Stored procedures vs. functions
In many instances you can accomplish the same task using either a stored procedure or a function. Both functions and stored procedures can be custom defined and part of any application. Functions, on the other hand, are designed to send their... Tip | SearchSQLServer.com
-
Managing linked server security in SQL Server
SQL Server allows you to connect to external data sources through a feature called linked servers. You can connect to other SQL Servers on the network, or even many different heterogeneous sources such as Microsoft Access, Oracle Database or IBM... Tip | SearchSQLServer.com
-
Best practices for preventing a SQL injection attack
A SQL injection attack continues to be one of the biggest threats to SQL Server. A database can be susceptible to such attacks if the database -- or the front-end application it supports -- contains code that a hacker can exploit by injecting... Tip | SearchSQLServer.com
-
SQL Server security: The implications of user-defined roles
Roles in SQL Server have been around in one form or another for almost the entire lifetime of this product, but SQL Server 2000 introduced the server-wide roles and security that... Tip | SearchSQLServer.com
-
Different ways to audit SQL Server security
With strengthened security management guidance from the industry, Microsoft is building more security and auditing features into SQL Server. These SQL Server auditing features not only help DBAs generate audit trails of schema changes and... Tip | SearchSQLServer.com
Search Again: