Announcing the General Availability of IDERA SQL Compliance Manager 7.0
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Engaging the Business Users in Enterprise Semantics – by David Loshin, Knowledge Integrity, Inc.
This is the fifth in a series of six posts on metadata collaboration from David Loshin. Read the previous post and the next post in the series. In my previous post, we discussed the need to review business glossary terms and data elements and their...
Collaboration Principles and Universal Data Models – By Len Silverston, Universal Data Models, LLC
Once upon a time, there were four expert data modelers engaged on an enterprise data modeling effort. There was also an additional expert data modeler facilitator to foster collaboration among the modelers. The modelers each had different opinions regarding how to...
PostgreSQL Administration Made Easy
PostgreSQL let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out there. Well, being a bleeding edge Database Tools Company, Embarcadero always keeps pace with the latest happening in the...
2 Things to Know About When Using Snapshot Isolation
SQL Server 2005 version introduced the concept of Snapshot isolation setting. It is one of those hidden gems inside SQL Server which is under appreciated. Snapshot is a great option for increasing the concurrency of application at the same time giving application...
SMO – SQL Server Management Objects
SMO stands for Shared Management Objects. It is a SQL administration API used to get meta data information from SQL Server. You may ask “Why? I can already do that”. True, but what if your only need was to have a tool that could do some of the following: Backups and...
MongoDB – Data Modeling Primer
We all know and have been hearing about NoSQL systems since the last year or so! 2014 is slated to be the year of NoSQL DB Platforms and Big Data Implementations. Well MongoDB one of the leading NoSQL Database providers are making waves. You might think why would one...
How-To Guide: Upgrading Your Delphi VCL Applications To Support 4K Displays
Alexander Halser from EC Software GmbH. has released an in-depth how to guide for preparing your Delphi VCL applications to support 4K displays. The guide talks about what the standard DPI in your Windows applications is usually set to (96 DPI), which versions of...
Tips Database Developers Must Know Reading Query Plans
If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding those “problems” which DBA might be talking about. We would talk about tips which can help a developer in finding some of...
The 3Vs may require NoSQL, but data modeling is still required – by Rob Loranger
We live in an exciting time where technology is entering our lives in areas that many of us never expected. For example, at home, once unintelligent devices such as thermostats, light bulbs, and entertainment consoles are now capable of detecting when a person is...
Knowing your Storage Basics- 2 Life Lessions for a DBA
IF_THEN_ELSE_RapidSQL
This week I’ll take a look at IF-THEN-ELSE-ELSEIF syntax. Next blog I’ll take a look at the similar CASE syntax and compare/contrast the two. This will help document what I’ll cover in a live demo using Rapid SQL. Lets look at the IF-THEN-ELSE syntax....
CASE Syntax using Rapid SQL
Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE syntax. RapidSQL has templates for this syntax as well! Using the ctrl + space bar, you can see the...
Auditing is More Than a Way to Get the Security Team Off Your Back
As a DBA, you probably look at auditing tools as a something forced upon you by the security officer. You are asked to provide continuous auditing of SQL Server activity and to generate reports to satisfy PCI, HIPAA, FERPA and SOX requirements. You buy a tool just to...
Securing your Data Modeling Assets – ER/Studio Repository
How do I turn off Scientific Notation in the Grid and Text Results for Sybase ASE FLOAT data type?
How do we turn off scientific notation? I’m getting this in both text and grid results for Sybase ASE servers. create table myfloat ( floater float NOT NULL) go insert myfloat select (10000000000.00) go select * from myfloat go (Output)...
How to execute IBM DB2 UDB Admin commands that are part of CLP in Aqua Data Studio ?
How to execute IBM DB2 UDB Admin Functions in Aqua Data Studio ? IBM DB2 has server SQL commands, and commands that are part of their command line tool. SQL Commands are executed on the server, while the command line commands are executed on the...
Changing the Max Concurrent Service Connections for SQL Diagnostic Manager
SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This serves to protect the monitored server from having hundreds of connections opened by the monitoring tool right when things...
Top 2 Reasons Why Database Developers Take Certifications
Developers, Administrators and individuals have various levels of motivations when it comes to taking certifications. There are no set rules or ways in which one takes certifications. For organizations it is a great way to find the right candidate and candidates who...
3 Cool SQL Server TSQL Snippets for Productivity
Nobody would want to shy away from some help. This is second to human nature and we never try to talk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of time. Keeping things...
5 Different Ways to Start SQL Server Services
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are working as SQL Server DBA, you must have done this many times – restart SQL Server Services. It’s always interesting to...