38_Spotkanie_PLSSUGweWroclawiu_KilkaSłów_ApexSQL_FreeTools
19
KILKA SŁÓW O APEXSQL FREE TOOLS TOBIASZ JANUSZ KOPROWSKI
-
Upload
tobiasz-koprowski -
Category
Education
-
view
218 -
download
0
description
Very short indoduction for three ApexSQL ftree tools for DBA. Second session (more practical at next meetup - February).
Transcript of 38_Spotkanie_PLSSUGweWroclawiu_KilkaSłów_ApexSQL_FreeTools
KILKA SŁÓW O APEXSQL FREE TOOLSTOBIASZ JANUSZ KOPROWSKI
O ApexSQL
3KILKA SŁÓW O APEXSQL FREE TOOLS
About Company – This Is A GREAT Company
4KILKA SŁÓW O APEXSQL FREE TOOLS
Great software
Great ROI
Great bundles
Great quality
Great support
Great service
Great community
Great people
ApexSQL For DBA
5KILKA SŁÓW O APEXSQL FREE TOOLS
Change management
ApexSQL Diff Compare and synchronize SQL database objects
ApexSQL Data Diff Compare and synchronize SQL database data
ApexSQL Diff API Compare and synchronize SQL databases programmatically
ApexSQL Build Build, update and deploy SQL databases
Database analysis and reporting
ApexSQL Clean Analyze dependencies and remove unused objects
ApexSQL Doc Document SQL instances, databases and SSIS packages
ApexSQL Search Search SQL objects and data and visualize dependencies
Database auditing
ApexSQL Comply Fault tolerant auditing, centralized storage and reporting
ApexSQL Audit Track data changes to SQL databases
ApexSQL Log Audit, undo or replay SQL database changes
ApexSQL Diff Compare and synchronize SQL database objects
ApexSQL Log API Audit SQL database changes programmatically
ApexSQL For DBA / Deployment
6KILKA SŁÓW O APEXSQL FREE TOOLS
Database scripting and deployment
ApexSQL Script Script and package SQL databases
ApexSQL Diff Compare and synchronize SQL database objects
ApexSQL Data Diff Compare and synchronize SQL database data
ApexSQL Diff API Compare and synchronize SQL databases programmatically
ApexSQL Build Build, update and deploy SQL databases
Disaster recovery
ApexSQL Recover Recover deleted, dropped, corrupt or lost data
ApexSQL Log Audit, undo or replay SQL database changes
ApexSQL Data Diff Compare and synchronize SQL database data
ApexSQL Diff Compare and synchronize SQL database objects
ApexSQL Restore Work with backups just like with live databases
ApexSQL For Development
7KILKA SŁÓW O APEXSQL FREE TOOLS
Database development
ApexSQL Refactor Format and refactor SQL code
ApexSQL Version Version control SQL code
ApexSQL Complete Develop SQL code faster in SSMS and VS
ApexSQL Search Search SQL objects and data and visualize dependencies
SQL formatting and refactoring
ApexSQL Refactor Format and refactor SQL code
ApexSQL Complete Develop SQL code faster in SSMS and VS
SQL Server version control
ApexSQL Script Script and package SQL databases
ApexSQL Diff Compare and synchronize SQL database objects
ApexSQL Version Version control SQL code
ApexSQL Build Build, update and deploy SQL databases
ApexSQL Product Licensing
8KILKA SŁÓW O APEXSQL FREE TOOLS
Per User
With per user licenses, the software is licensed for use by a single user only. This applies to client tools, add-ins and APIs
Per Server
This allows the software to be activated on a single server and may be used by multiple users. This applies to server tools
For more information on the license types please review the EULA
http://www.apexsql.com/zips/license.pdf
ApexSQL Complete
Automatically complete SQL keywords, statements and identifiers
Visual Studio and SSMS intellisense add-in
Review object’s script and description without interrupting coding
Speed up SQL coding with snippet
9KILKA SŁÓW O APEXSQL FREE TOOLS
ApexSQL Complete
Customizable shortcuts
Customizable snippets Reuse SQL code fragments as snippets and insert
context-specific values as needed
Snippet management Save development time by creating your own snippets
or editing the predefined ones
Visual Studio 2013 support
Code structure viewer Identify the structure of complex SQL queries at a
glance
Tooltips for identifiers View detailed information on SQL identifiers inline
Closing characters auto-insertion Ensure the number of closing characters
matches the number of opening ones with automatic closing character
insertion
Automatic bracketing Improve SQL identifier visibility by bracketing them
automatically
Pair highlighting Determine whether the SQL code is formed correctly by
highlighting paired elements
Quick cache refreshing
SQL code auto-complete Automatically fill in SQL keywords and names
Support for all Visual Studio versions
Auto-complete object details Check the object’s definition and description without backtracking
Syntax error highlighting Automatically identify and highlight any syntax error within the code
Quick error navigation Jump to the exact position in the code where the error has occurred
Transparent decryption Seamlessly work with encrypted objects
Completion options Define insertion keys and fine tune auto-complete layout and performance
Keyword formatting Format auto-completed keywords in upper, lower or proper case
Qualified object names Automatically insert the fully qualified object name
Global aliases Specify aliases to be filled in for objects from all SQL Server instances and databases
Schema caching Boost auto-complete performance with object caching
Support for all SQL Server versions
KILKA SŁÓW O APEXSQL FREE TOOLS 10
ApexSQL Refactor
Format and refactor code directly in SSMS or VS for FREE
Qualify objects, expand wildcards, encapsulate SQL and more
Locate and highlight unused variables and parameters
SQL formatter with over 160 formatting options and 11 code refactors
11KILKA SŁÓW O APEXSQL FREE TOOLS
ApexSQL Refactor
Performance improvements
Visual Studio 2013 support versions
Formatting profiles Save and quickly toggle between different sets of formatting settings
Batch SQL scripts formatting Format SQL scripts and script folders in batches
SQL Server 2012 support
Advanced SQL formatting Layout your SQL code with over 160 customizable options and preview the impact of the changes
Customizable options Create custom formatting profiles and share them across your team
Impact analysis Preview the impact of changes with difference highlighting
Expand wildcards Transform * wildcards into explicit lists of column names
Qualify object names Qualify columns with schema table names and schema or aliases
Copy SQL code as Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Copy and paste it into your applications data access layer
Add surrogate key Replace complex, multi-column primary keys with a single column surrogate key
Find unused variables and parameters Clean up your code by identifying and removing parameters and variables that aren’t used
Replace one-to-many relationships Add a new associative table to replace one-to-many relationships
Change parameters Add, remove or change parameters without breaking dependencies from referencing objects
Encapsulate SQL Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
Smart rename Rename tables, procedures, views, functions and columns risk-free
Split table Improve your database design and make large tables more manageable by partitioning them
Support for all Visual Studio versions
Support for all SQL Server versions
KILKA SŁÓW O APEXSQL FREE TOOLS 12
ApexSQL Search
Search for SQL objects directly in SSMS and VS
Quickly find data in SQL tables and views
Visualize complex relationships between objects
Rename SQL objects without breaking dependencies
13KILKA SŁÓW O APEXSQL FREE TOOLS
ApexSQL Search
Visual extended description editing Add or edit descriptions for your database objects using the extended properties that are stored in your SQL Server database
Query editor renaming Identify the content of open query windows easier by automatically renaming them
SQL Server 2012 support
Object search Search for objects or text in database object definitions
Text search Search for text, numbers, dates and unique identifiers in your tables and views
Graphical dependencies Visualize even the most complex relationships between SQL objects
Smart rename Rename tables, procedures, views, functions and columns without breaking dependencies
Search history Quickly access previously searched objects with automatically saved searches
Accurate analysis Recognize all object interdependencies; even the ones SQL Server itself fails to identify
Customizable searches Specify the object types to be searched
Quick navigation Navigate to the found object in a single click
Results browsing Group, sort and filter search results
Transparent description
Visual Studio integration
Support for all SQL Server versions
Visual Studio 2013 support
KILKA SŁÓW O APEXSQL FREE TOOLS 14
ApexSQL Demo
KILKA SŁÓW O APEXSQL FREE TOOLS 15
ApexSQL offline demo 1
ApexSQL Compare
– integrated with SQL Server Management Studio 2012
KILKA SŁÓW O APEXSQL FREE TOOLS 16
ApexSQL offline demo 2
ApexSQL Refactor
– integrated with SQL Server Management Studio 2012
KILKA SŁÓW O APEXSQL FREE TOOLS 17
ApexSQL offline demo 3
ApexSQL Search
– integrated with SQL Server Management Studio 2012
KILKA SŁÓW O APEXSQL FREE TOOLS 18
AFTER SESSION {NEXT CONTACT}
MAIL: [email protected]
MSG: [email protected]
SKYPE: tjkoprowski
TWITTER @KoprowskiT
SlideShare (post-sessions): http://www.slideshare.net/Anorak
BLOGS:
ITPRO Anorak’s Vision: http://itblogs.pl/notbeautifulanymore/ [PL/EN]
Volume Licensing Specialites: http://koprowskit.eu/licensing/ [PL/EN]
My MVP Blog: http://koprowskit.eu/geek/ [PL/EN/ES]
19KILKA SŁÓW O APEXSQL FREE TOOLS
DZIĘKUJĘ
