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
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
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
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 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
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
Like other mainstream commercial database systems, SQL Server supports analytic functions in Transact-SQL to depict complex analytical... Tip | SearchSQLServer.com
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
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
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