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
Configure SQL diagnostic manager for non-standard ports
SQL Server uses the port 1433 as its standard listening port. Hackers know this and will use it to more easily hack into your SQL environment. Because of this, many DBAs will choose to not use the standard SQL port of 1433 for their SQL environment and...
Manipulating Scheduled Tasks
If you need to change and adjust settings in a registered scheduled task, there is a COM interface called 'Schedule.Service' that you can use to access all registered scheduled tasks (Vista/Server 2008 or better). The sample code below accesses the scheduled...
Dumping Scheduled Tasks
There is an underestimated option to make schtasks.exe dump scheduled tasks as CSV data. PowerShell can grab the CSV data and turn it into objects, creating reports with all scheduled tasks in just one line: schtasks.exe /query /fo csv | ConvertFrom-Csv | Where-Object...
Create Strongly Typed Hash Table
A hash table can store any data type. If you want more control, you can create a typed dictionary (which behaves pretty much like a hash table): $ht = @{} $htTyped = New-Object 'System.Collections.Generic.Dictionary[string,int]' $ht.ID = 12 $ht.Person =...
Lucky number 13 : Big Data, Little Data, we don't discriminate
We have begun seeding release candidates of Aqua Data Studio version 13.0 with a planned stable release beginning of May. We have some new members to the family, which include Greenplum, Vertica and SQLite. The three expand both our big data and embedded database...
Why Back Up the Transaction Log if not Interested in Point-in-time Restore?
I’ve heard people say many times that they don’t use full or bulk-logged recovery model or backup the transaction log of their database because they do not care about point-in-time (PiT) restores. However, PiT restores are not the only reason to use...
Make Your PowerShell Scripts Click-runnable
If you are like me, you hate having to type in the full path to a PowerShell script to run it.Wouldn’t it be nice if you could just execute it? I’m an old Windows scripter guy (DOS, VBScript, etc), and I’m used to being able to just double-click a...
Clone FireMonkey objects
I've got a task of cloning FireMonkey objects. Let it be "chess". An object is created as an aggregate in design-time. Look at the picture in the Structure pane. I have made the composite pawn model and start thinking of make 15 more. If you’re thinking...
Is Using RECONFIGURE WITH OVERRIDE dangerous?
One of my pet peeves is the use of RECONFIGURE WITH OVERRIDE in scripts to change server options. Am I being unreasonable or is this justified? All you need to do is look up the definition of the WITH OVERRIDE option for the RECONFIGURE command in Books Online to see...
Delphi Labs: DataSnap code samples updated to XE3
It seems that it is my very first post in the New Year 2013, so I wish You all the best and great time writing all kinds of programs. I'm sure it is going to be a great year for Delphi and Marco is predicting it as well, especially that next month Delphi is going...
Increase SQL Server Performance Using Multiple Files
By default, SQL Server databases are comprised of two files: the primary data file (or .mdf) and the log file (or .ldf). It is, however, possible to configure SQL Server databases to use additional files – which can be an effective means of increasing SQL Server...
Unix Log Scanner
After the installation of the Unix Log Scanner using the uptime plugin manager I try to create a service monitor. But every time I run the test I received this error Status: WARN Message: Process returned with warning status – Error Output received:...
XE3 Visual LiveBindings: User defined objects
The adapter components TListBindSourceAdapter and TObjectBindSourceAdapter enable LiveBindings with user defined TObjects. Here is a user defined TObject for example. type TContact = class private FFirstName: string
Installing Sonar for Delphi
On 15th of November the HTML5 Builder QA Team was in the VLCTesting where we learned very good experiences and shared knowledge, amongst this was the software Sonar, Right now in HTML5 Builder we are not using that tool but we found interesting to add a continuous...
Why isn’t there a Procedure Editor for Sybase ASE like there is for the other database vendors?
I can right mouse click on a procedure in Oracle, DB2 and SQL Server and choose the "Edit in Procedure Editor", but in Sybase ASE this option doesn't exist. Why is "Edit in Procedure Editor" missing in Sybase ASE? Response Niels Gron over 11 years ago Aqua Data Studio...
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...