Posts Tagged ‘sql’


 

PrimalPad gets a 2011 upgrade

Tuesday, September 6th, 2011 by Alex Riedel
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 coloring. Last but not least, you can now run your script files from within PrimalPad. While it doesn't have PrimalScript's output capture abilities, it still works pretty well for some quick hit and run scripting. The tools menu is where you make it all happen.…   More »

Feature Peek 2011: PrimalSQL – Exporting PowerShell GUIs

Tuesday, January 11th, 2011 by David Corrales
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 (pff)  depending on the option you select. (Fig 2: Select PS1 Script or PrimalForms File) And finally you can edit and run the script in your favorite PowerShell editor: (Fig 2: Running the PowerShell Query GUI in PrimalForms 2011)…   More »

Connecting PrimalSQL to MySQL 5.1

Tuesday, October 27th, 2009 by Ferdinand Rios
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 your MySQL 5.1 database. Follow the outlined steps below and you will be connected in no time! 1) Presumably you have a MySQL 5.1 database installed either locally or on a server somewhere. If you want to test this on a new installation, you can…   More »

PrimalSQL: Querying a major update

Monday, October 5th, 2009 by David Corrales
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 with PrimalSQL’s new asynchronous queries. What do asynchronous queries mean to me, the user? Well it means that when you run a query, you no longer have to wait until the query completes. Therefore, you can perform multiple operations at the same time, including running…   More »

Product Highlight – PrimalSQL and PrimalXML Example

Tuesday, March 24th, 2009 by David Corrales
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 list for a webpage using the information I exported. I begin by running a basic query which displays a list of products available in the Northwind database. To do this, I will be using PrimalSQL 2009. PrimalSQL is a powerful tool that allows you to…   More »

SQL Live

Friday, December 19th, 2008 by Alex Riedel
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 have to type them over an over again while experimenting. With this improvement of the Query window you can experiment and fine tune any query you have and verify its results against a live data source. Once you got it right, you can confidently copy…   More »

PrimalScript 2009 and SQL

Tuesday, December 9th, 2008 by Ferdinand Rios
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 a connection to a database. Open the Database Browser in PrimalScript and right click in the pane. Select “Create a new connection.” Immediately name the connection. Fill in the connection dialog boxes and press OK.  (If you are connecting to a SQL Server 2008 database…   More »

PrimalSQL 2009 ready for beta test

Tuesday, November 4th, 2008 by Alex Riedel
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 to understand and use. From simple select statements to complicated outer joins, from just checking if a connection works to editing stored procedures and live data, PrimalSQL 2009 provides all the tools you need every day to create efficient SQL statements quickly and effortlessly. Just…   More »

Powershell vs T-SQL

Sunday, August 31st, 2008 by Jeffery Hicks
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.…   More »

Database Scripts with PowerShell

Sunday, May 4th, 2008 by Don Jones
 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 it's made visible), right-click to create a new database connection, and use the GUI to connect to any kind of database. Then, right-click a table to generate a script using the database wizard. You'll get complete boilerplate code that maps to YOUR database schema -…   More »