analytics and sql
3.6K views | +0 today
Follow
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...
Rescooped by Kevin Jobe from SharePoint By Natali
Scoop.it!

Let’s Make a Clickable Image Map Using SharePoint Designer 2010

Let’s Make a Clickable Image Map Using SharePoint Designer 2010 | analytics and sql | Scoop.it

custemers just love the idea of an image map !

 

this article shows how simple is it to make one by using SharePoint Designer 2010


Via Natali Polishuk
more...
Anonymous's comment, April 13, 2012 7:53 AM
Hi!
Can i use this method to make an organizational structure?
Or maybe there are another methods to make it?
Scooped by Kevin Jobe
Scoop.it!

How to rename a column without breaking your SQL database

How to rename a column without breaking your SQL database | analytics and sql | Scoop.it
SQL Server tools for auditing, database data recovery, change management and more
Kevin Jobe's insight:

How to rename a column without breaking your SQL database

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

Less Than Dot - Blog - Maximum length of data in every column in a table

Less Than Dot - Blog - Maximum length of data in every column in a table | analytics and sql | Scoop.it
more...
Kevin Jobe's comment, January 11, 2013 12:42 PM
sql server, maximum column length
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!

Absolute SharePoint Blog: SharePoint 2013 Service Accounts Best Practices! Is there a golden solution for all farms?

Absolute SharePoint Blog: SharePoint 2013 Service Accounts Best Practices! Is there a golden solution for all farms? | analytics and sql | Scoop.it
This post talks about Best Practices for Service Accounts in SharePoint 2013. I am challenging the idea that one can propose only one set of Service Accounts for all the farms.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints - Stack Overflow

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.