All posts tagged: SQL Server on cloud

SQL BI Check on cloud

1.  Real-time performance monitoring for SQL Server Analysis Services (SSAS) 2. See physical server metrics for CPU, disk, and storage. 3. View analysis metrics for SSAS processing, memory, and cache. 4. Get up and running in minutes, no agents required.   Major Features of  SQL BI Check Real-time SQL BI Performance Monitoring : Monitor the

SQL Hekaton Memory Check on cloud

SQL Hekaton Memory Check, a free tool that allows database administrators (DBAs) to see real-time memory usage on all SQL Server instances that use Hekaton, and take immediate action to avoid downtime and optimize appropriately. Hekaton, Microsoft’s in-memory database for online transaction processing in SQL Server, can increase processing speeds up to 30x using a

SQL Statistics Aggregator on cloud

SQL Statistics Aggregator tool allows users to speed up the aggregation and analysis of Statistics IO data that is common when doing query tuning by creating an interactive table of the data making it much easier to view and interpret. Using this information, database administrators (DBAs) can quickly see where the problems are that otherwise

SQL Update Statistics on cloud

Launch directly within SSMS for optimal usability Identify out-of-date SQL Server table and index statistics View and change database statistics options Create graphical histograms for each column’s statistics Easy point-and-click rebuilding of statistics Connect to cloud and run in cloud (provisional) SQL Update Statistics on cloud for AWS   Major Features of SQL Update Statistics

SQL Page Viewer on cloud

Stop digging through confusing DBCC Page output to troubleshoot SQL Server issues. With a single click, SQL Page Viewer gives you quick insight into how the SQL Server data is stored. Get the page level data you need to quickly diagnose locking, blocking or wait events caused by a given table, index or corrupted data.

SQL XEvent Profiler on cloud

IDERA’s SQL XEvent Profiler emulates the functionality and simplicity of SQL Server Profiler, letting you quickly view data from SQL events and see what’s happening on the server. Plus, it leverages SQL Extended Events (XEvents) as the backing technology — making it more efficient, more powerful and more scalable than SQL Trace. View sessions running

SQL Fragmentation Analyzer on cloud

Idera’s SQL fragmentation analyzer displays a graphical view of the fragmentation level of your SQL Server indexes, helping you see what indexes might require maintenance. Idera’s commercial SQL defrag manager 3.1 takes this a step further and lets you automate defragmentation. You can find SQL fragmentation analyzer at the Idera site. Analyze fragmentation by one

Sql Ping on cloud

SQLPing scans your network to locate new and unprotected SQL Server and Microsoft SQL Server Desktop Engine (MSDE) instances. SQLPing works with SQL Server 2000 and later, and requires the .NET Framework. SQLPing uses both active and passive scans to find SQL Server and Microsoft SQL Server Desktop Engine (MSDE) installations that need to be

sql prompt  on cloud

SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code choices. Automatic script layout provides easy code readability – particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so you can make it

SQL Check on cloud

Real-time SQL BI Performance Monitoring Monitor the performance of physical server activity as well as analysis services to get a better picture of your SQL BI systems. Set the refresh rate to as little as 1 minute and see up to 2 ½ hours of data. The configurable dashboard provides an at-a-glance view of the

ApexSQL TriggerViewer with sql server 2016 on cloud

ApexSQL Trigger is an auditing tool for SQL Server databases which captures DML/DDL changes that have occurred including information on who made the change, which objects were affected by it, when it was made, as well as information on the SQL login, application, and host used to make the change.   ApexSQL TriggerViewer on Cloud

ApexSQL Complete with SQL Server 2016 on cloud

Automatically complete SQL statements Improve productivity with snippets Keep track of all your tabs Easily navigate to SQL objects Review an object’s script and description Identify the structure of complex SQL queries Log every executed query Check queries in test mode ApexSQL Complete with SQL Server 2016 on cloud For AWS     Major Features

ApexSQL Refactor with SQL Server 2016 on cloud

ApexSQL Refactor is a free SQL formatter, and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE. ApexSQL

ApexSQL Search with SQL Server 2016 on cloud

ApexSQL Search analyzes SQL Server database object’s dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself. Search for SQL objects directly in SSMS and VS, quickly find data in SQL tables and views, visualize complex relationships between objects and rename SQL

ApexSQL Snapshot utility with sql server 2016 and SSMS on Cloud

What is a snapshot? A snapshot is a read-only file in a binary format that stores the complete information of a database schema. It can be used as a data source in ApexSQL Diff. The ApexSQL Snapshot utility enables creating snapshots without ApexSQL Diff. The utility is free and can be installed on multiple remote

MS SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 on cloud

SQL Server 2005’s data-mining algorithms offer powerful capabilities for analyzing data, but Microsoft didn’t provide any out-of-the box tools for delivering data mining to the desktop until recently. In February 2007, Microsoft delivered the Data Mining Add-ins for Office 2007, which let you take advantage of SQL Server 2005 predictive analytics in Excel 2007 and

SQL Server on Cloud

    Microsoft SQL Server 2012 Express is a powerful and reliable free data management system that delivers a rich and reliable data store for lightweight Web Sites and desktop applications. Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 2012 comprises a set