analytics and sql
3.8K 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!

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

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!

Setup SharePoint 2013 Preview - This Sql Server instance does not have the required max degree of parallelism

Kevin Jobe's insight:

not restricted to preview, this error also happens in RTM.

more...
ziclane's comment, September 23, 2014 2:23 AM
I want to configure using the wizard, and I am using a newly created service account. I created this account in AD and give it administrator rights. I leave the rest of the options default.
http://www.dumpspdf.com/70-667.html
Scooped by Kevin Jobe
Scoop.it!

How to re-enable ISO Mounting in Windows 8 File Explorer

Read the step-by-step instructions written by an IT pro in the how to: How to re-enable ISO Mounting in Windows 8 File Explorer
Kevin Jobe's insight:

Alas, Windows 8 Pro (and Server 2012) offer native iso mounting!

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

Hyper-v and anti-virus configuration

Hyper-v and anti-virus configuration | analytics and sql | Scoop.it
A senior program manager in the PQO group at Microsoft shares some common Hyper-V configuration problems that users are reporting, as well as the recommended resolutions.
Kevin Jobe's insight:

Exclude the following for default installations, or the equivalent directories for custom installs:

C:\Users\Public\Documents\Hyper-V

C:\Users\Public\Documents\Hyper-V\Virtual Hard Disks

 

And exclude the following processes:C:\Windows\System32\vmms.exeC:\Windows\System32\vmwp.exe

 

solution for common vm issues such as:

The requested operation cannot be performed on a file with a user-mapped section open

 

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

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 2

Installing SharePoint 2013 Preview on Windows 2012 Server with SQL 2012-Part 2 | analytics and sql | Scoop.it
Tweet Welcome back to part 2 on installing SharePoint 2013 Preview on Windows 2012!  In part 1 we focused on installing SQL 2012 on a Windows 2012 server and in today’s post we focus our effo...
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!

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

Cannot enable Network Discovery and change Network Location on Windows Server 2008 R2

Kevin Jobe's insight:

See Wilson Jia post:

 

In order to enable the Network Discovery settings, you may make sure the following services are enabled and running.

 

-      DNS Client

-      Function Discovery Resource Publication

-      SSDP Discovery

-      UPnP Device Host

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

Using Hyper-V with a Wireless Network Adapter - Ben Armstrong - Site Home - MSDN Blogs

Ben Armstrong talks about Hyper-V and virtualization at Microsoft.
more...
No comment yet.
Scooped by Kevin Jobe
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.