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...
Scooped by Kevin Jobe
Scoop.it!

BgInfo

BgInfo | analytics and sql | Scoop.it
This fully-configurable program automatically generates desktop backgrounds that include important information about the system including IP addresses, computer name, network adapters, and more.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Define a Default Member

Kevin Jobe's insight:

describes how default member is resolved when the default member is not defined.

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

Last executed queries for a specific database

Last executed queries for a specific database | analytics and sql | Scoop.it
I know how to get the last executed queries using the following SQL in SSMS -

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Comparing Two Recordsets Using Powershell - SQLServerCentral

Comparing Two Recordsets Using Powershell - SQLServerCentral | analytics and sql | Scoop.it
Free Microsoft SQL Server articles, news, forums, scripts and FAQs.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Powershell 3.0- about_Execution_Policies

Powershell 3.0- about_Execution_Policies | analytics and sql | Scoop.it
Kevin Jobe's insight:

if you attempt to run a powershell script, and receive the following message:

"script cannot be loaded because running scripts is disabled on this system".

 

This post explains execution policies and describes how to change them.

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

PowerTip: Determine PowerShell Version

The Hey, Scripting Guy! Blog includes helpful how-to posts and scripts about PowerShell, Active Directory, Exchange, SQL Server, VBScript and other Microsoft technologies.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Date picker dropdown in Excel 2013

Date picker dropdown in Excel 2013 | analytics and sql | Scoop.it
Hi, I have looked for support of inserting a date picker drop down into a cell. The only instructions available are for Office 2010 or previous; these instructions seem to be the most comprehensive,
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Automating SSAS cube docs using SSRS, DMVs and spatial data | Purple Frog Systems

Automating SSAS cube docs using SSRS, DMVs and spatial data | Purple Frog Systems | analytics and sql | Scoop.it
Querying Analysis Services DMVs to generate automated cube documentation in SSRS, and visualising star schemas using spatial data and SSRS maps. Part 1
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Cast (SSIS Expression)- legal and illegal cast chart

Kevin Jobe's insight:

kj- nice chart showing legal and illegal cast operations

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

How to embed a Word document in a SharePoint 2013 page using Office Web Apps

The background for this video can be found here: http://www.brainlitter.com/2012/12/21/how-to-embed-a-word-document-in-a-sharepoint-2013-page-using-office-we...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Using multiple monitorss, can I have the notifications area appear on all taskbars?

Using multiple monitorss, can I have the notifications area appear on all taskbars? | analytics and sql | Scoop.it
I use 3 monitors with an AMD 7xxx series card. I would prefer to not use a 3rd party program to manage multiple windows. I am wondering if it is possible with Windows 8 to have the notification area
Kevin Jobe's insight:

see the following from Mathew:

Right click taskbar.
Properties.
Untick "show taskbar on all displays"
Apply.
Drag the remaining "primary monitor" taskbar to the screen you want.
Tick "show taskbar on all displays"
... you're done. Notification area now on whatever monitor you want.

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

Project REAL: Analysis Services Technical Drilldown

Kevin Jobe's insight:

interesting discussion on data source views

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

How to use the "Open with Explorer" command and how to troubleshoot issues with this option in SharePoint Online

How to use the "Open with Explorer" command and how to troubleshoot issues with this option in SharePoint Online | analytics and sql | Scoop.it
Discusses how to use the "Open with Explorer" command and how to troubleshoot issues with this option in SharePoint Online.
Kevin Jobe's insight:

When you use the Open with Explorer command, it opens Windows Explorer on your computer. However, Windows Explorer then displays the folder structure on the server computer that hosts the site. You can then work with the files in the folder. For example, you can perform actions by using Windows Explorer that include the following: 

Drag documents into libraries.Create folders.Move or copy documents in one library to another library within the same site collection or between site collections.Delete multiple documents at one time.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Double-Hop Linked Servers

Double-Hop Linked Servers | analytics and sql | Scoop.it
Having made use of linked servers in a few previous posts, let us take a closer look at a common problem with them: double-hop authentication failure when using Windows Authentication. This issue p...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SharePoint 2013 error when creating a new SSRS service application | Scott Mattie's Blog

Kevin Jobe's insight:

Powershell error is: New-SPRSServiceApplication : The timer job completed, but failed on one or more machines in the farm.

 

The service application db's are created, but the service application in SharePoint is not.

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

Location of the spPowerPivot.msi

Location of the spPowerPivot.msi | analytics and sql | Scoop.it
Ever tried to find that spPowerPivot.msi file on the SQL Server 2012 installation media with SP1 included? Just to be able to start the PowerPivot configuration whereever and whenever you want... t...
more...
Kevin Jobe's comment, September 12, 2013 3:53 PM
Not available on 32 bit version of SQL, only 64 bit.
Scooped by Kevin Jobe
Scoop.it!

Excel 2013 Video 10 Insert a Calendar Datepicker in a Floating VBA Userform

I have a PHD in Economy, many years of experience in Accounting, Taxes declarations for Individual and Corporations, Balance Sheet Preparation, Financial Ana...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Installing Power View for Multidimensional Models

Installing Power View for Multidimensional Models | analytics and sql | Scoop.it
  Power View was a new reporting option added in the SQL Server 2012 release as part of the SharePoint integrated mode of Reporting Services. From the beginning it was limited to only reportin...
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Enable anonymous users for custom list in SharePoint 2013 - Sites and document sharing - Office 365 - Microsoft Office 365 Community

Enable anonymous users for custom list in SharePoint 2013 - Sites and document sharing - Office 365 - Microsoft Office 365 Community | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Add a BI Semantic Model Connection Content Type to a Library (PowerPivot for SharePoint)

more...
No comment yet.