analytics and sql
Follow
Find
3.0K views | +0 today
analytics and sql
sql for mySQL and SQL Server, and database analytics
Curated by Kevin Jobe
Your new post is loading...
Your new post is loading...
Scooped by Kevin Jobe
Scoop.it!

Top 10 Transact-SQL Statements a SQL Server DBA Should Know — DatabaseJournal.com

Top 10 Transact-SQL Statements a SQL Server DBA Should Know — DatabaseJournal.com | analytics and sql | Scoop.it
Microsoft SQL Server is a feature rich database management system product, with an enormous number of T-SQL commands. With each feature supporting its own list of commands, it can be difficult to remember them all.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL Server 2012 with SP1 Slipstream ISO images do not install SP1

SQL Server 2012 with SP1 Slipstream ISO images do not install SP1 | analytics and sql | Scoop.it

<!--  kj if you initially installed SQL Server 2012, without SP1, just install the new SP1 only, and disregard this kb article. -->

 

Describes that SQL Server 2012 Service Pack 1 is not successfully applied to the RTM installation after you installed the SP1 Slipstream ISO images from MSDN and TechNet sites released on November 8, 2012.

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Install Google Chrome with YUM on Fedora 17/16, CentOS/Red Hat (RHEL) 6.2 - Software

Install Google Chrome with YUM on Fedora 17/16, CentOS/Red Hat (RHEL) 6.2 - Software | analytics and sql | Scoop.it

remember to go sudo gedit to open editor for creating new google.repo file

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Pentaho BI Platform Tracking [#PDI-8108] Exception while loading class mysql.Driver

Pentaho BI Platform Tracking [#PDI-8108] Exception while loading class mysql.Driver | analytics and sql | Scoop.it

To resolve this problem add mysql-connector-java-5.1.20-bin.jar into directory: \pdi-ce-4.3.0-stable\data-integration\libext\JDBC

 

The driver is no longer compatible with the Apache License that 4.3 ships with. As such we can't include it.

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

What datatype to use when storing latitude and longitude data in SQL databases? - Stack Overflow

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL Data Types for MS Access, MySQL, and SQL Server

Well organized easy to understand SQL tutorial with lots of examples. Including PHP, ASP.NET Oracle, Access, SQL Server.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

How to open command prompt in Windows 8

How to open command prompt in Windows 8 | analytics and sql | Scoop.it
Are you missing the good old command prompt in Windows 8 developer preview build? In this quick post, I will discuss how you can launch the command prompt in Windows 8.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Install SQL Buddy (A Web Based MySQL Administration) Tool for RHEL / CentOS / Fedora

Install SQL Buddy (A Web Based MySQL Administration) Tool for RHEL / CentOS / Fedora | analytics and sql | Scoop.it
SQL Buddy is one of my all time favorite tool, that I’ve use daily for accessing and managing MySQL administration of servers. SQL Buddy is an open source web based tool was written in PHP la...
more...
Victor Sabo's comment, July 26, 2013 2:28 AM
Not so far I have found new cool tool to work with mySQL - Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
Scooped by Kevin Jobe
Scoop.it!

Oxygen Editor RAM allocation- Setting a Java Virtual Machine Parameter in the Launcher Configuration File / Start-up Script

<!-- kj this is to allocate more ram to oxygen in the config file.  -->There are two ways of setting new Java Virtual Machine parameters: Setting Parameters for the Application Launchers On Mac OS X you can set or change existing parameters by editing the Info.plist ...

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Install Apache OpenOffice 3.4.1 on Fedora 17/16, CentOS/RHEL 6.3

Install Apache OpenOffice 3.4.1 on Fedora 17/16, CentOS/RHEL 6.3 | analytics and sql | Scoop.it

<!-- kj- believe i prefer the yum repository approach to this install method.  this downloaded to home dir and worked it from there.  -->

 

This is quick guide to install Apache OpenOffice 3.4.1 on Fedora 17/16/15/14/13/12, CentOS 6.3/6.2/6.1/6, Red Hat (RHEL) 6.3/6.2/6.1/6 with using Apache OpenOffice original RPM packages.

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Howto- Install LAMP server in Fedora 17 | Unixmen

Howto- Install LAMP server in Fedora 17 | Unixmen | analytics and sql | Scoop.it
In this post i will show you the steps to install LAMP server in Fedora 17 "Beefy"...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

How to properly create composite primary keys - MYSQL - Stack Overflow

CREATE TABLE INFO (
t1ID INT,
t2ID INT,
PRIMARY KEY (t1ID, t2ID)
)

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Looping Over Flat File Sources in SSIS

Looping Over Flat File Sources in SSIS | analytics and sql | Scoop.it
Introduction It seems I am often helping people configure SSIS packages to loop over several flat files to extract data to be sent to a single SQL destination table. While some may have found a way...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Cannot specify column delimiter for flat file connection manager in BI Studio

more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

xslt - XML/XSL/C# - transforming repeating group into several text lines - Stack Overflow

more...
No comment yet.