More Results
-
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response... Tip | SearchSQLServer.com
-
Staying hip to HIPAA regulations: How one DBA stays compliant
Editor's note: This is the first of a two-part story. Check back next week for the second part.
While being a database administrator (DBA) is... Feature | SearchSQLServer.com
-
Little-known features of Microsoft SQL Server 2012
After more than 25 years of working with Microsoft SQL Server, you'd think pretty much everything has been done at least once. I thought it would be... Feature | SearchSQLServer.com
-
Research claims no link between high-frequency trading and market manipulation
Research commissioned by the Bank of England for the Foresight project on high-frequency trading shows no correlation between... IT for financial services | ComputerWeekly.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
-
URL manipulation (URL rewriting)
URL manipulation, also called URL rewriting, is the process of altering (often automatically by means of a program written for that purpose) the parameters in a URL (Uniform Resource Locator). Definition | WhatIs
-
Server-side selector provides flexible DOM manipulation
jQuery made DOM manipulation on the client side much more concise thanks to its CSS Selector mechanism, among other things. Now, the CSS selector technique has been extended to server side technology in ZK 6 under the guise of Java... Tip | TheServerSide.com
-
Native string manipulation functions for SQL Server
Check out this list of custom functions for basic string manipulation – a great skill for any database professional. Tip | SearchSQLServer.com
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Years ago, I had a class project that used SQL Server as a back end and a website as a front end, and one of the incremental exercises I implemented on it was moving all those horrible ad hoc, in-line SQL Server statements to SQL Server... 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
Search Again: