Monday, November 28, 2011

How I passed SharePoint 2010 exam 70-667 (Part 1 of 4) - Tales from a SharePoint farm

Sharepoint 2010 is a complex beast of an application, with many facets and configuration options.  Taking the exams should be a prerequisite to any upgrade or deployment.

These notes are the best I have seen so far to help prepare for the configuration exam.

How I passed SharePoint 2010 exam 70-667 (Part 1 of 4) - Tales from a SharePoint farm

PowerShell Data Processing Extension for SQL Server Reporting Services

A useful tool to generate reports based on Powershell outputs.

Plug this into SQL Server Reporting Services to create reporting based on your PowerShell scripts. The PowerShell DPE transforms your PowerShell output into a DataSet that can be consumed by SSRS.

PowerShell Data Processing Extension for SQL Server Reporting Services

Saturday, November 26, 2011

Executing a TSQL batch multiple times using GO

Need to run a query or update multiple times, or even a sql job?

EXEC sp_start_job ‘JOB_NAME’

GO 100

Executing a TSQL batch multiple times using GO

Monday, November 14, 2011

SQLBI - Marco Russo

SQLBI - Marco Russo
Project Crescent is now Power View, (on the theme of PowerPivot) and it doesn't support the many to many revolution (2.0).

"
If you are looking to create many-to-many relationships based models in PowerPivot and in BISM Tabular, probably one day you will be interested in using them with Power View (formerly codename “Crescent”). There is a very bad news for you: it appears that, at least in its first release, Power View will not support this scenario, showing a behavior that (and this really worries me) is very different from Excel."

SQLBI - Marco Russo

SQLBI - Marco Russo: "The Many-to-Many Revolution 2.0.

Marco Russo and Alberto Ferrari seem to confirm my assumption that the artist formerly known as UDM has become BISM.

Linking PowerPivot in a many-to-many scenario is, well, a bit hacky in my opinion. Issues like case insensitivity also can cause issues for users.

A whitepaper link below that may give some ideas for a better approach to these challenges.


These are the news in this edition:

Alberto Ferrari joined me as co-author of the paper
We added a new pattern for BISM Multidimensional (formerly known as UDM)
We translated several existing pattern to BISM Tabular model.
Because BISM Tabular doesn’t support many-to-many relationships in its data model, you have to rely on DAX formulas to obtain the desired results. This produces many changes in data modeling and we tried to cover these differences in the paper, too
The paper is freely available in PDF format. We will publish single patterns described in the paper as web articles, in order to improve readability and indexing from search engines (today everybody use a web search engine instead than looking for a document in local disk, just because it’s faster)."

'via Blog this'

Thursday, November 10, 2011

EEG shows awareness in some vegetative patients - Health - CBC News

I wonder if something as simple as a $90 OCZ NIA would allow people to test for this?

EEG shows awareness in some vegetative patients - Health - CBC News: "Owen said another goal is to see whether brain-computer interface technology being developed may one day be used to unlock the world even more for patients who are cognitively aware but unable to let anybody know."

'via Blog this'

Tuesday, November 08, 2011

Create a date and time stamp in your batch files | Remote Administration For Windows

DOS scripts at their best.  DOS better be in Windows 8…

Here is an interesting one. I found a way to take the %date% environment variable, and turn it into a valid string for a filename – without any extra programs or scripts.

For the longest time I used a little utility I created to do this. The problem with that is the utility needs to be around if you want to send the batch file to someone.

What I didn’t know that was that you can use this character combination ‘:~’ to pull a substring out of an environment variable. That is when I realized you could use this to pull out parts of the current date (or time).

Here is how it works. Lets take the %date% variable and print it out

Create a date and time stamp in your batch files | Remote Administration For Windows

Here’s an example including time that backs up a projects directory to the C: drive under a Backup timestamped directory.

@echo off
set YYYYMMDD=%date:~-4,4%%date:~-10,2%%date:~-7,2%
set HHMMSS=%time:~-11,2%%time:~-8,2%%time:~-5,2%
echo %HHMMSS%


c:
md \Backup_%YYYYMMDD%%HHMMSS%

echo Backing Up files to \Backup_%YYYYMMDD%%HHMMSS%\

xcopy /s C:\Projects\*.* \Backup_%YYYYMMDD%%HHMMSS%\

echo Files backed up to \Backup_%YYYYMMDD%%HHMMSS%\

Goto Quit

:Quit

Friday, November 04, 2011

SQL Server 2012 Editions Announced

 

Microsoft has just announced SQL Server 2012 Editions information on official SQL Server 2012 site.

SQL Server 2012 will be available in three main editions:

  1. Enterprise
  2. Business Intelligence
  3. Standard

The other editions are Web, Developer and Express.

Here is the salient features of each of the edition:

Enterprise

  • Advanced high availability with AlwaysOn
  • High performance data warehousing with ColumnStore
  • Maximum virtualization (with Software Assurance)
  • Inclusive of Business Intelligence edition’s capabilities

Business Intelligence

  • Rapid data discovery with Power View
  • Corporate and scalable reporting and analytics
  • Data Quality Services and Master Data Services
  • Inclusive of the Standard edition’s capabilities

Standard

  • Standard continues to offer basic database, reporting and analytics capabilities

There is comparison chart of various other aspect of the above editions. Please refer here.

Additionally SQL Server 2012 licensing is also explained here.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

Journey to SQLAuthority

Wednesday, November 02, 2011

Under the hood: Copy database diagrams in SQL Server 2005

One way to copy database diagrams between databases.

INSERT INTO dbB.dbo.sysdiagrams
SELECT[name],[principal_id],[version],[definition]
FROM dbA.dbo.sysdiagrams

Under the hood: Copy database diagrams in SQL Server 2005