More Results
-
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... 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
Maximize SQL Server database performance by streamlining your data
As the databases behind websites and applications become bigger and busier, application architects and developers often need to figure out very quickly how to scale the database before the application becomes unusable under heavy... Tip | SearchSQLServer.com
The pros of Windows Azure SQL Database
Windows Azure -- Microsoft's cloud infrastructure platform -- has become a major part of Microsoft's overall strategy, and the Windows Azure SQL Database, formerly called SQL Azure, has become a major component of Windows Azure... Feature | SearchSQLServer.com
SQL Server DBAs must get ready to take on 'big data' and more roles
SQL Server DBAs have to be ready for the influx of big data and be willing to take on more roles -- particularly in business analytics -- than they have in the past, according to leaders of the Professional Association for SQL Server.
The... News | 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
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
Further SSIS tips: Parameters and undoing operations
Editor's note: Check out the other two parts of the series: a tip on new SSIS features for BI developers and a tip on... Tip | SearchSQLServer.com
More new features for SSIS 2012: Connection managers and more
Editor's note: This is the second part of a three-part series on new features in SSIS. Please follow this link for... Feature | SearchSQLServer.com
Great new SSIS features for BI developers
Editor's Note: This is the first of a three-part series by frequent SearchSQLServer.com contributor Robert Sheldon about new SSIS features that will make the jobs of BI developers easier -- and why.
Developers are always... Tip | SearchSQLServer.com
Search Again: