analytics and sql
Follow
Find
3.0K views | +0 today
 
Scooped by Kevin Jobe
onto analytics and sql
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.

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!

sql server - IntelliSense not working but it is enabled - Database Administrators Stack Exchange

sql server - IntelliSense not working but it is enabled - Database Administrators Stack Exchange | analytics and sql | Scoop.it
Kevin Jobe's insight:

Answered by Ritesh D:

There are cases where the local cache used by IntelliSense becomes stale. Refreshing the cache is easy but not necessarily obvious.

There are two ways to refresh the cache:

Hit Ctrl+Shift+RGo to Edit -> IntelliSense -> Refresh Local Cache and


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

LTRIM RTRIM doesn’t always work - CodeProject

Kevin Jobe's insight:
--Replace all non printing whitespace characers with Characer 32 whitespace --NULL Set @StringToClean = Replace(@StringToClean,CHAR(0),CHAR(32)); --Horizontal Tab Set @StringToClean = Replace(@StringToClean,CHAR(9),CHAR(32)); --Line Feed Set @StringToClean = Replace(@StringToClean,CHAR(10),CHAR(32)); --Vertical Tab Set @StringToClean = Replace(@StringToClean,CHAR(11),CHAR(32)); --Form Feed Set @StringToClean = Replace(@StringToClean,CHAR(12),CHAR(32)); --Carriage Return Set @StringToClean = Replace(@StringToClean,CHAR(13),CHAR(32)); --Column Break Set @StringToClean = Replace(@StringToClean,CHAR(14),CHAR(32)); --Non-breaking space Set @StringToClean = Replace(@StringToClean,CHAR(160),CHAR(32));   Set @StringToClean = LTRIM(RTRIM(@StringToClean)); Return @StringToClean
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL Server Forums - datediff in expression excluding weekends

SQL Server Forums - datediff in expression excluding weekends | analytics and sql | Scoop.it
Kevin Jobe's insight:

per visakh16: 

SELECT DATEDIFF(dd,StartDate,EndDate) - (2 * DATEDIFF(wk,StartDate,EndDate)) as Weekdays FROM Table
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

How to list all the installed SQL Server on the Server using TSQL - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs

How to list all the installed SQL Server on the Server using TSQL - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs | analytics and sql | Scoop.it
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!

automatically copy to clipboard and editor- SnagIt screen capture tool.

automatically copy to clipboard and editor- SnagIt screen capture tool. | analytics and sql | Scoop.it
Older version used to allow me to capture, preview and have it automatically copied to the clipboard without any extra clicks so I could just paste the capture into the application. Now I have two extra clicks and some mousing to do this. Can you please return the old functionality?
Kevin Jobe's insight:

per torvaldur:

 

I've devised a workaround that solves all of our problems (mine was that I want output to both editor and clipboard in one click). The trick is to disable "Preview in editor" and then Output to the editor anyway.

Step-by-step:
1. Create, duplicate or edit an existing profile.
2. In the Profile Settings > Output: Uncheck Preview in Editor.
3. Check Multiple Outputs.
4. Check Clipboard and Program and additional alternatives you might want.
5. Output > Properties... > Program tab. Choose Add... Find the executable to the Snagit Editor (in my case C:\Program Files (x86)\TechSmith\Snagit 10\SnagitEditor.exe).
6. Save profile.
(7. Bind profile to a hotkey if you didn't edit the one you are using.)

Now everytime you capture an image it will be in the clipboard and pop up in the Editor if you want to draw something on it.

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

Calculating days to excluding weekends (Monday to Friday) in SQL Server - Stack Overflow

Calculating days to excluding weekends (Monday to Friday) in SQL Server - Stack Overflow | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

OneNote 2013: Move Notebook to Office 365 - YouTube

If you've created a OneNote notebook using a personal Windows Live/Skydrive account, you may want to move the notebook into Office 365 so that you can easily...
more...
No comment yet.
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.