SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003 | Journey to SQL Authority with Pinal Dave

Good article!

SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003 | Journey to SQL Authority with Pinal Dave:

Node.JS static file web server. Put it in your path to fire up servers in any directory, takes an optional port argument.

Node.JS static file web server. Put it in your path to fire up servers in any directory, takes an optional port argument.:

indeed, very convenient and cool!

Error during processing of the ConnectString expression of data source

Thanks for Carter33 who post at http://social.msdn.microsoft.com/Forums/sqlserver/en-US/447b14c0-f1d0-4980-a2cd-8f2069804801/receiving-a-datasource-error-when-running-report-that-uses-expression-based-connection-string?forum=sqlreportingservices , manually move the report parameters section of the rdl file on the top of datasource section fixes the issue.

Accessing a remote file share in SQL Server Integration Services | James Summerlin's Blog

Accessing a remote file share in SQL Server Integration Services | James Summerlin's Blog: "name /USER:"


- Note:
- "\" need to be doubled
- special character need to have "^" to escape.

The Ultimate Wake-on-LAN (WOL) Guide

My configuration is using a wireless bridge and it doesn't work after I shutdown the computer for a while, however if I turn on the computer and shutdown it, WOL works fine.

It seems that I have to setup a static arp with the MAC address of the wireless bridge I am using (TP-Link WRN700N).

under DD-WRT, it is something like that:

arp -s 192.168.2.50 (Computer's static IP) xx.xx.xx.xx (wireless bridge's MAC address)

update: well this still doesn't fix the problem, in my case My PC was connected to a switch which is connected to the wireless bridge, after remove the switch, I am now able to wake the PC even after it has been shutdowned for a long time...I suspect it it the arp cache in the switch expired and caused the issue.

The Ultimate Wake-on-LAN (WOL) Guide:
Tip: Wake on LAN/Magic Packet information collection and check list

How to change SQL Server Database Collation

SQL Server 2000 Collation Changer - CodeProject:

Easy way to change collation of all database objects in SQL Server - CodeProject:

Recover access to a SQL Server instance

Recover access to a SQL Server instance:

Another way is to start sql in single user mode, but the above approach using psexec is much better!

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal

The SQL Server Reporting Services (MSSQLSERVER) service failed to start + after SP2 installation on Windows 2008 R2 | Data Base Internal:

'via Blog this'

delete orphaned sql jobs

--select * from sys.master_files order by physical_name

select * from dbo.sysjobs
select * from dbo.sysmaintplan_subplans

delete from dbo.sysmaintplan_subplans where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

delete from dbo.sysmaintplan_log where subplan_id='7659F4CD-F98D-4F28-9372-5DBDC0BE168D'

--sp_help sysmaintplan_subplans

delete from sysjobs where job_id='B3FECCA3-A0D2-4BEA-88D6-685EBE2F1164'

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013 - Microsoft Project For All - Site Home - TechNet Blogs

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013 - Microsoft Project For All - Site Home - TechNet Blogs:

'via Blog this'

BizTalk 2013 and SharePoint 2013

There is no need to install the sharepoint web service adapter...the default biztalk installation already get the connectivity to sharepoint 2013 without installing anything on the sharepoint server :-)

SharePoint 2013 - Drag and drop requirements ~ Microsoft..what else?

SharePoint 2013 - Drag and drop requirements ~ Microsoft..what else?:

'via Blog this'

Throttle a Query in Mid-Execution - SQLServerCentral

Throttle a Query in Mid-Execution - SQLServerCentral:

'via Blog this'

Sharepoint 2010 Secure Store: An error occurred during the “Generate Key” process. Please try again or contact your administrator | Sharepoint Consultant, Automation & Stuff

Sharepoint 2010 Secure Store: An error occurred during the “Generate Key” process. Please try again or contact your administrator | Sharepoint Consultant, Automation & Stuff: "– In my case the ‘Sharepoint Webservices Root’ application pool had stopped on one of my app servers
"

'via Blog this'

Reporting Service doesn't appear under services on sharepoint 2013

Installed SQL Server 2012 reporting service with SP1 however the SQL reporting service is not shown under the manage services on server page, some mentioned that you might have to reinstall SP1 however I wasn't able to do that since it is already SP1.

finally I started the central administration service on the reporting server and access the central admin page from there, wow....it finally works. not sure why yet.

The Top 50 Proprietary Programs that Drive You Crazy — and Their Open Source Alternatives | WHdb

The Top 50 Proprietary Programs that Drive You Crazy — and Their Open Source Alternatives | WHdb:

'via Blog this'

Top Open Source ESB Projects | Architects Zone

Top Open Source ESB Projects | Architects Zone:

'via Blog this'

Table changes not automatically reflected in a SQL Server View

Table changes not automatically reflected in a SQL Server View:

'via Blog this'

CAS SSO | Jasig Community

CAS | Jasig Community:

Welcome to the home of the Central Authentication Service project, more commonly referred to as CAS. CAS is an authentication system originally created by Yale University to provide a trusted way for an application to authenticate a user. CAS became a Jasig project in December 2004.

How to add a user to the sudoers list | USB Pen Drive Linux

How to add a user to the sudoers list | USB Pen Drive Linux:

'via Blog this'

Argenis Fernandez : The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems, and AWE

Argenis Fernandez : The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems, and AWE:

'via Blog this'

SQL Server Upgrade Advisor: Considerations when upgrading from SQL 2000 to SQL 2012 - Premier Field Engineering Developer Blog - Site Home - MSDN Blogs

SQL Server Upgrade Advisor: Considerations when upgrading from SQL 2000 to SQL 2012 - Premier Field Engineering Developer Blog - Site Home - MSDN Blogs:

'via Blog this'