Database refactoring is a simple database transformation which improves its design without changing the behavioral semantics of the database. The process of database refactoring defines how to safely evolve a database schema in small steps
October 25, 2013SQL Solution center round-up – October 18th, 2013 – SQL Server compliance with FERPA and Basel II, database recovery, and methods for auditing failed logins
In the latest SQL Solution center articles, we wrote about SQL Server compliance regulations FERPA and Basel II, SQL Server database recovery from a corrupted file, and various methods for auditing failed SQL Server logins
October 24, 2013ApexSQL Log 2013 vs. 2011 performance testing: the results are in
At ApexSQL we constantly strive to improve our tools. We optimize the technology, improve existing features and options, and introduce new ones. When it comes to a SQL Server transaction log reader, performance is critical. This is why the recent performance breakthroughs in ApexSQL Log 2013 are so important and exciting
October 21, 2013ApexSQL Audit 2013 R2 – Product update alert
ApexSQL Audit 2013 R2 has been released
Type: Maintenance release
About ApexSQL Audit: ApexSQL Audit is a SQL Server auditing tool with a wide range of possibilities for auditing access, changes, and security on SQL Server instances, databases, and objects. It audits queries, execute and security (authentication changes, permissions changes, attempted logins) operations on tables, stored procedures, functions and views, saves captured information in a centralized auditing repository, and provides comprehensive reports
October 18, 2013ApexSQL Complete vs. SSMS – Part 5 – Options not supported by SSMS IntelliSense
Our latest ApexSQL Complete vs. SSMS article presented the main differences between ApexSQL Complete’s auto – complete feature and SQL Server Management Studio’s IntelliSense.
October 18, 2013ApexSQL Recover 2011 R3 – Product update alert
ApexSQL Recover 2011 R3 has been released
Type: Maintenance release
About ApexSQL Recover: ApexSQL Recover is a recovery tool for SQL Server databases which recovers deleted, truncated, corrupted or damaged data. It recovers objects and data lost due to drop operations and restores both deleted and online BLOBs as files making it ideal for SharePoint recoveries
October 17, 2013ApexSQL Diff 2013 released
Raleigh – October 17, 2013 – ApexSQL, a Microsoft Gold Certified Partner and major provider of Microsoft SQL Server solutions, today announced the release of ApexSQL Diff 2013. The new version includes full support for SQL Azure and outstanding performance improvements as well as many other new features
October 17, 2013ApexSQL Diff 2013 – Product update alert
ApexSQL Diff 2013 has been released
Type: New version
About ApexSQL Diff: ApexSQL Diff is a SQL Server and SQL Azure database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders and generates comprehensive reports on the detected differences
October 17, 2013ApexSQL Complete vs. SSMS – Part 4 – SSMS IntelliSense add-in and native SSMS IntelliSense
In the previous articles ApexSQL Complete vs. SSMS – Part 1 – Object recognition and ApexSQL Complete vs. SSMS – Part 2 – Auto-complete DDL and DML statements, we have presented two features of ApexSQL Complete’s intellisense tool: context based recognition of typed terms and support for auto-complete DDL and DML statements. In the third ApexSQL Complete vs. SSMS – Part 3 – Creating and using T-SQL code we compared ApexSQL Complete’s and SQL Server Management Studio’s snippet features.
October 16, 2013SQL Solution center round-up – October 4th, 2013 – SQL Server compliance with Sarbanes-Oxley (SOX), PCI, and GLBA
In the latest SQL Solution center articles, we focused on SQL Server compliance with federal regulations and standards
October 15, 2013
