analytics and sql
Follow
Find
2.3K views | +2 today
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!

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!

SQL Chick - Microsoft BI Blog

SQL Chick - Microsoft BI Blog | analytics and sql | Scoop.it
Data Analysis & Visualization with Microsoft Business Intelligence tools
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.
Scooped by Kevin Jobe
Scoop.it!

PowerPivot BI Semantic Model Connection (.bism)

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

Rename service application databases in SharePoint 2013

Rename service application databases in SharePoint 2013 | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Get the Real SharePoint Error using the ULS Logs

Get the Real SharePoint Error using the ULS Logs | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

PowerPivot Reference for SharePoint PowerShell

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

Comparing Tabular and Multidimensional Solutions (SSAS)

Kevin Jobe's insight:

kj see table for comparison of Multidimensional vs. Tabular vs. PowerPivot:

 

Model Features

The following table summarizes feature availability at the model level.

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

Obama orders agencies to make data open, machine-readable by default

Obama orders agencies to make data open, machine-readable by default | analytics and sql | Scoop.it
Latest push for openness mandates new and upgraded systems be exposed via API.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Gopika's Blog: [Connection manager "Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered...

Gopika's Blog: [Connection manager "Excel Connection Manager"] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered... | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

How do I open Resource Monitor on Windows 8? - Super User

How do I open Resource Monitor on Windows 8? - Super User | analytics and sql | Scoop.it
Kevin Jobe's insight:

see this answer: 

There is no Start Screen shortcut to "Resource Monitor" by default in Windows 8, but you can create one:

Press Win+D to show the desktop.Right-click in an empty area, choose New → Shortcut.In Type the location of the item, type perfmon.exe /res; click Next.In Type a name for this shortcut, type Resource Monitor; click Finish.

You should now have a shortcut on the desktop named "Resource Monitor". Right-click on this shortcut and choose Pin to Start.

Now, when you press the Win key and type Resource Monitor, an icon that launches Resource Monitor should appear on the Start Screen.

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!

Create a BI Semantic Model Connection to a Tabular Model Database

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

SQL 2012: Data Connections, Data Sources, and Connection Strings (SSRS)

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

Understanding PowerPivot and Power View in Microsoft Excel 2013 | SQL Server 2012 content from SQL Server Pro

Understanding PowerPivot and Power View in Microsoft Excel 2013 | SQL Server 2012 content from SQL Server Pro | analytics and sql | Scoop.it
Microsoft Excel 2013 is a big step forward with respect to business intelligence. The native integration of PowerPivot and Power View provides a whole new level of scalability and functionality.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Automating the SharePoint 2013 installation and creating a farm with PowerShell

Automating the SharePoint 2013 installation and creating a farm with PowerShell | analytics and sql | Scoop.it
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

Rename SharePoint Content Database

Rename SharePoint Content Database | analytics and sql | Scoop.it
I've been tasked to manage the SharePoint 2010 and 2013 database servers after deployment. While looking at the list of databases, I saw several content databases that have GUID values appended to their names.
more...
No comment yet.
Scooped by Kevin Jobe
Scoop.it!

How many decimal places are there in a specific column

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

Suggested Max Memory Settings for SQL Server 2005/2008 - SQLServerCentral

Suggested Max Memory Settings for SQL Server 2005/2008 - 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!

sql server - Why can't I shrink a transaction log file, even after backup? - Stack Overflow

Kevin Jobe's insight:

kj- see Brent's comment from June 02, 2010:

 

I've had the same issue in the past. Normally a shrink and a trn backup need to occur multiple times. In extreme cases I set the DB to "Simple" recovery and then run a shrink operation on the log file. That always works for me. However recently I had a situation where that would not work. The issue was caused by a long running query that did not complete, so any attempts to shrink were useless until I could kill that process then run my shrink operations. We are talking a log file that grew to 60 GB and is now shrunk to 500 MB.

Remember, as soon as you change from FULL to Simple recovery mode and do the shrink, dont forget to set it back to FULL. Then immediately afterward you must do a FULL DB backup.

more...
No comment yet.