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
-
Splitting SQL Server backups to multiple files
Database size is increasing across businesses all over the world, and as a database administrator (DBA) one should make sure that database backups are completed on time.
For more on SQL Sever backup... Tip | SearchSQLServer.com
SQL Server 2012 security: Changes for the newest version
Editor's note: This is part two of a four-part series about SQL Server security. The first part, "Why SQL Server security... Series | SearchSQLServer.com
Excerpt: Planning a Microsoft SQL Server install
During the installation process, you have to make many choices. As a general guideline, it is best to familiarize yourself with their effects before installing your system. At the beginning, you should answer the following... Excerpt | SearchSQLServer.com
Scale out with Windows Azure SQL Database
In the early days of Window Azure SQL Database -- formerly called SQL Azure -- scaling out your databases was a tedious effort that impacted the connecting applications as well as the databases themselves. Since those days, Microsoft has added a... Tip | SearchSQLServer.com
Introduction to SQL Server 2012 Express LocalDB
Microsoft SQL Server 2012 Express LocalDB is a lightweight version of SQL Server 2012 targeted for database developers. Microsoft's goal was to get developers an executable mode of... Tip | SearchSQLServer.com
Coding for seamless SQL Server database mirroring
SQL Server database mirroring has been providing a high-availability option since 2005. One feature is automatic application failover to the secondary server when the primary server is no longer available. This article discusses automatic... 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
T-SQL analytic functions in SQL Server can help solve problems quickly
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical... 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: