analytics and sql
Follow
Find
2.5K views | +12 today
 
Scooped by Kevin Jobe
onto analytics and sql
Scoop.it!

Windows 8, find the Resource Monitor

Windows 8, find the Resource Monitor | analytics and sql | Scoop.it

The Resource Monitor is available in Windows 8, but not as visible as it is in Server 2012.

more...
No comment yet.

From around the web

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!

How do I open Resource Monitor on Windows 8?

How do I open Resource Monitor on Windows 8? | analytics and sql | Scoop.it
When I press the Windows key and type Resource Monitor, no programs are shown. How do I open "Resource Monitor" on Windows 8?
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Power BI - Getting Started Guide - SharePoint Online for enterprises - Office.com

Power BI - Getting Started Guide - SharePoint Online for enterprises - Office.com | analytics and sql | Scoop.it
Abstract: The growth of data increases each day, as does the need for self-service business intelligence that can turn data into decision-ready insights. But too often, the tools
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Fix: Active directory corrupted (NTDS ISAM Database Corruption errors in eventlog)

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

SharePoint 2013 - "Sorry, this site hasn't been shared with you."

SharePoint 2013 - "Sorry, this site hasn't been shared with you." | analytics and sql | Scoop.it
"Sorry, this site hasn't been shared with you." This seems to be a common message SharePoint 2013 users are seeing if things aren't configured correctly. There may be a variety of reasons why you a...
Kevin Jobe's insight:

restart the Microsoft SharePoint Foundation Web Application in central admin.

more...
No comment yet.
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!

Except (MDX)

Kevin Jobe's insight:

kj, nice for excluding only the leaves of a dimension, but including the rest of the hierarchy.

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

SSAS- Define a Default Dimension Member

Kevin Jobe's insight:

..If no default member is specified for an attribute hierarchy, and the attribute hierarchy is aggregatable (the IsAggregatable property on the attribute is set to True), the (All) member is the default member. If no default member is specified and the attribute hierarchy is not aggregatable (the IsAggregatable property on the attribute is set to False), a default member is selected from the attribute hierarchy's top level.

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

Big data: are we making a big mistake? - FT.com

Big data: are we making a big mistake? - FT.com | analytics and sql | Scoop.it
Five years ago, a team of researchers from Google announced a remarkable achievement in one of the world’s top scientific journals, Nature. Without needing the results of a single medical check-up, they were nevertheless able to track the spread of
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SSAS/MDX Concepts & Tools: Remote Query (Linked Server) Connection Time-Out Issue & Solution

Kevin Jobe's insight:

for the following error: 

OLE DB provider "MSOLAP" for linked server "" returned message "XML for Analysis parser: The XML for Analysis request timed out before it was completed.

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.