analytics and sql
Follow
Find
3.1K views | +0 today
 

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!

Microsoft Breathes Life into SQL Server On-Prem BI

Microsoft Breathes Life into SQL Server On-Prem BI | analytics and sql | Scoop.it
Microsoft breathes back into SQL Server BI with huge news of the upcoming SQL Server 2016 preview that is jam packed with new features.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014

SQL Server Data Tools (SSDT) is Missing After Installing SQL Server 2014 | analytics and sql | Scoop.it
Please note that you do not need Visual Studio 2013 installed on your box in order to install the SSDT-BI tools. The setup program will install the Visual Studio 2013 shell and then provide the BI tools as one component of Visual Studio. The SSDT-BI install actually adds all the following components:

Microsoft .NET Framework 4.5.1,
Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package,
Microsoft Visual Studio 2012 Shell (Integrated) Redistributable Package,
Microsoft Visual Studio 2013 Shell (Isolated) Redistributable Package,
Microsoft Visual Studio 2013 Shell (Integrated) Redistributable Package,
Microsoft Visual Studio Tools for Applications 2012,
and Microsoft Report Viewer 2014 Runtime.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

SQL Server Management Studio (SSMS) Tips and Tricks

SQL Server Management Studio (SSMS) Tips and Tricks | analytics and sql | Scoop.it
1.     Change the status bar in the "New Query? window to red when connecte
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!

SQL Server Data Tools Download

https://msdn.microsoft.com/en-us/data/hh297027

Kevin Jobe's insight:

SSDT-BI, SQL Server Business Intelligence is a distinct toolset from SSDT or the SQL Server database tooling in Visual Studio 2013. As part of the SQL Server 2014 release, SSDT-BI has released a version for Visual Studio 2013. 

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

Possible to disable spell checking in OneNote for a specific page only? - Super User

Possible to disable spell checking in OneNote for a specific page only? - Super User | analytics and sql | Scoop.it
Kevin Jobe's insight:

maybe there is a better way, but this works in a pinch.

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