PrimalPad gets upgraded with code folding, new languages and the ability to run scripts. With this new 2011 version of the ever popular Notepad replacement you get support for code folding in VBScript, JScript and PowerShell. Because some of you asked nicely, we also added SQL and Python to the languages supported by PrimalPad’s syntax […]
Tag: sql
Feature Peek 2011: PrimalSQL – Exporting PowerShell GUIs
Similar to PrimalForms 2011, PrimalSQL 2011 will allow you to export PowerShell GUI scripts that run your queries. Simply design your query in PrimalSQL’s Query builder and press the “Export Query Form” button. (Fig 1: Export the Query into a PowerShell GUI) PrimalSQL 2011 will then generate a PowerShell script (ps1) or a PrimalForms Form […]
Connecting PrimalSQL to MySQL 5.1
Many organizations use MySQL as the back end database to their web sites and other infrastructure operations. While MySQL offers its own set of GUI too for database management, using a generic database tool like PrimalSQL has several advantages, especially when operating in a mixed database environment. It is fairly simple to connect PrimalSQL to […]
PrimalSQL: Querying a major update
Last month we released a major service update for PrimalForms 2009. This month we will release a major service update for PrimalSQL 2009*. What querying goodness will this update include? We made some major improvements to way PrimalSQL queries databases, as well as, a few other changes and additions. Users may experience improved query performance […]
Product Highlight – PrimalSQL and PrimalXML Example
In this blog, I will demonstrate how to use the features of PrimalSQL and PrimalXML to accomplish sample tasks. In this example, I will need to gather product information from a database and produce an XML file that will be used for offline processing. In addition, I would like to create a static drop down […]
SQL Live
PrimalScript 2009 sports a modified version of the Query results window you know from the 2007 version. Instead of just being able to run SQL queries from a SQL file you can just type queries in the provided combo-box: The combo-box of course is there to keep a history of your queries so you don’t […]
PrimalScript 2009 and SQL
PrimalScript 2009 has expanded its support for SQL in several major ways. Primary among these are the addition of SQL PrimalSense and the ability to edit and save stored procedures directly within a database. Let’s take a quick look at some of these new features. Before you can work with SQL, you should first create […]
PrimalSQL 2009 ready for beta test
One more tool of SAPIEN’s 2009 software lineup will be available for beta testing this week. PrimalSQL 2009 makes database query development and testing a snap. Regardless of your database type or vendor, PrimalSQL 2009 will connect to them all and allows you to visually build your queries. Its modern, streamlined interface makes PrimalSQL easy […]
Powershell vs T-SQL
If you’ve been debating the pros and cons of PowerShell vs T-SQL, or trying to decide why anyone would want to use PowerShelll to manage SQL server when it already has a great management language, take a look at http://blogs.msdn.com/dtjones/archive/2008/08/29/powershell-vs-t-sql-or-why-did-we-add-powershell-support-in-sql2k8.aspx. Good stuff. Clear and to the point.
Database Scripts with PowerShell
Did you know that PrimalScript 2007 Professional and Enterprise can produce database-connected Windows PowerShell scripts? At least, the new service build (566) for these products can! Just open your Database Browser (select it from View > Browser Windows if it isn’t visible; by default it’s on the right-hand side of the code editing window, once […]
