Announcing the General Availability of IDERA SQL Safe Backup 9.3
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
Can we export data from Oracle using UTL_FILE or the SPOOL command?
How can we do this? Response Niels Gron over 10 years ago You can accomplish this functionality in Aqua Data Studio with the same or similar commands. Here are some clarifications ... The SPOOL command is a SQLPlus command and not an Oracle command. It runs on the...
DB2 iSeries SQL and System Naming
I have a question about using "system" naming with the iSeries driver. Usually this allows you to provided a list of schemas that may contain your tables. So instead of having one default schema you may have several schemas that will be checked for unqualified tables....
Why does Table Data Editor ask me to disambiguate column names?
When I enter a query into ADS which contains a join and the tables have common column names, the database server will not execute the query if the column names are not identified with their proper namespaces. But if I execute such a query in the Execute/Edit mode, a...
Getting the Permissions Wired-Up Properly When Attaching a Content Database to a SharePoint Farm
You’ve probably heard the latest news in the SharePoint world: SharePoint 2013 has been released to manufacturing (RTM)! We’ve been told that SharePoint 2013 should start to appear “in the wild” starting sometime in November, and I expect that...
BUMMER
USE mysql; SHOW FULL TABLES WHERE table_type = 'base table'; /* returns ... innodb_index_stats BASE TABLE innodb_table_stats BASE TABLE ... */ SELECT * from innodb_table_stats; /* returns Error CODE: 1146 TABLE 'mysql.innodb_table_stats' doesn't...
Top MySQL Blogs You Should Be Reading
There's a lot happening in the world of MySQL and it's really vital to be up-to-date with the latest advancements in this field to stay ahead of the game. Reminds me of this quote by Albert Einstein "Once you stop learning, you start dying." The easiest way to stay...
Powershell
Hi there, I have created a simple powershell script which I know works on my local machine running Windows 7 64bit. I have an evaluation copy of uptime that is also running on the same laptop. I have created a service monitor that runs the powershell script and looks...
ORM Frameworks for Delphi…
I have just returned from my RAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam, Warsaw and Heidelberg. In two cities I was asked whether there were any Object Relational Mapping solutions for Delphi....
Okay, Really – What Can I Do with a SharePoint Farm Configuration Database Backup?
I’ll cut straight to the chase: no, a configuration database backpastedimage1478188484999v3.pngup is not just a fancy paperweight. The prevailing wisdom in the SharePoint space is that configuration database backups are generally useless, and there’s a reason for that...
Don’t Forget Application Caching to Boost SQL Server Performance
When it comes to SQL Server performance, many organizations look to their DBAs to help fine-tune hardware configurations, optimize indexes, or weed out poorly written code and queries. Consequently, many performance tuning topics and suggestions commonly center upon...
Tips for Optimizing XML in SQL Server
I’ve worked on a project that used XML heavily inside SQL Server. We really utilized SQL Server’s XML support almost to the full extent, but with some repercussions. As we did our load testing, performance did degrade and we had to step back and adjust how...
Character sets in MySQL – still not for Windows users.
Recent MySQL versions (first the chaotic series of releases that preceeded 5.5 - 5.2, 6.0 and 5.4 - and now 5.6) adds new 'character sets' to MySQL. But little of it is useful. Let us take it from the beginning: before 4.1 MySQL supported a wide range of...
Delphi Training videos and tutorials – from LearnDelphi.tv
For those of you who need to learn more about Delphi programming, Alister Christie (http://learndelphi.tv/) who is one of our Embarcadero MVPs, has 74 free Delphi tutorial videos and a long form training videos "Building Applications in Delphi Using the Visual...
Custom FireMonkey "TSimpleTriangle" component
Have you ever written a component in Delphi? Reusable components are the corner-stone of rapid application development and important part of Delphi success on the market. Being able to manipulate an instance of a class at design-time is where Delphi shines! One day I...
Consider Your Collations Carefully, Or Pay Later
When first installing SQL Server, many developers and DBAs new to SQL Server may have the temptation to click Next, Next, Next on the installation wizard. However, it is of utmost importance to pay close attention, and be conscious, of options that you choose. We...
Ensure Proper SQL Server Connection Pooling
Coming to SQL Server from both a database developer and DBA background, I maintain that while tuning SQL Server’s ability to handle your application workloads is a viable way to increase performance, another way to bolster performance is to consider architectural and...
Getting to grips with using FireMonkey Grids
Although there is a huge amount that is the same for Delphi and C++ Builder developers between VCL and FireMonkey, one thing that has changed is the FireMonkey grids. After a recent question at an event, I thought I would put a little demo together to help understand...
Monyog Custom Counters – overcoming a problem.
In this previous Blog I described an example on how to build a Custom Object in MONyog. But there is one problem you may encounter and that is, that when querying Information_Schema and Performance_Schema, it can sometimes be difficult or impossible to be sure to have...
Log security and log tables.
Accidentially I came across the statement "SHOW GRANTS requires the SELECT privilege for the mysql database." in MySQL documentation (http://dev.mysql.com/doc/refman/5.1/en/show-grants.html). It is not quite true. Any user can "SHOW GRANTS [FOR...
Java 6u29 bug prevents SSL connection to SQL Server 2008 R2
In Java 6u29, there was a bug introduced which prevented SSL connections to SQL Server 2008 R2. This bug was logged with Oracle as Bug ID: 7103725 here : bugs.sun.com/.../view_bug.do Oracle has delivered a fix in 6u30, although some claim it still is not fixed. This...