legi, intellexi

On Windows 8 running RDP over Juniper client causes connectivity lost every couple of seconds. To fix this issue you need to disable UDP when accessing the servers via RDP protocol. In Local Group Policy editor (gpedit.msc) navigate to Computer Configuration -> Administrative Templates -> Windows Components -> Remote Desktop Services -> Remote Desktop Connection Client -> and then enable the 'Turn Off UDP on client" policy. And then you can reliably reconnect  via RDP

When opening Model.bim in Visual Studio 2012 (with update 2 installed) I got an error                    Class already exists and in the application log the Event ID 25 was also logged saying The description for Event ID 25 from source MSOLAP$LocalCube cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event:  msmdsrv.rll 4105 4105 is locale ID corresponding to English (Canada). When I changed the language settings in Control Panel to English(US) the errors is gone and I can successfully open Model.bim file

If you have the animation in Office 2013 application you can disable it by modifying the registry (it will disable animation in all office 2013 applications). Navigate to this key HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Graphics and add a new DWORD value DisableAnimations Set it to 1 to disable the animation (you'll need to close and re--launch the application) or change it back to 0 to re-enable it

For testing the performance impact of enabling synchronous replica on AlwaysOn 3-node cluster (see  http://smizrohi.blogspot.ca/2013/01/sql-2012-alwayson-synchronous-vs.html ) I used s simple test script presented here. The first part of the script is a CMD file called DB_Load.CMD If you use this script then you need to change the parameters defined by the SET statements within the script: SRV is a name of the SQL server to connect to (SQLDEVCLUSTER1) DBNAME is a name of a test database (Test_DB3) TIMEINTERVAL - defines the initial delay in ShowStats and then each loop is also paused by that amount of seconds NumOfClients is the number of concurrent sessions MODE means: MODE=1 means Creating the DB, the Tables, and the Procedures MODE=2 means Creating the Tables, and Procedures (the DB has already been created) MODE=3 means Creating the Procedures (the DB has already been created) And check if SQLCMD path on you server is the same as defined by the SQL...

Jack Li from MS SQL Server support blogged about the change in http://blogs.msdn.com/b/psssql/archive/2013/03/19/sql-server-2012-partitioned-table-statistics-update-behavior-change-when-rebuilding-index.aspx Here is what he said: In past versions, when you rebuild an index, you will get statistics update equivalent to FULLSCAN for free.    This is true regardless if the table is partitioned table or not. But SQL Server 2012 changed the behavior for partitioned table.    If a table is partitioned, ALTER INDEX REBUILD will only update statistics for that index with default sampling rate.  In other words, it is no longer a FULLSCAN.  This is documented in  http://technet.microsoft.com/en-us/library/ms188388.aspx .  But lots of users do not realized that.  If you want fullscan, you will need to run UPDATE STATISTCS WITH FULLSCAN .   This change was made because we started to support large number of partitions up to 15000 by d...

To test a connection string (in my case with MultisubnetFailover parameter) I used this simple PowerShell script: $ConStr=' Server=SQLdevCluster1;Database=TESTDB1;Trusted_Connection=yes;Provider=SQLNCLI11;MultisubnetFailover=TRUE ' $conn = New-Object System.Data.OleDb.OleDbConnection $conn.ConnectionString = $ConStr $conn.Open() $Tables = $Conn.GetOleDbSchemaTable([System.Data.OleDb.OleDbSchemaGuid]::tables,$null)  $Tables | FT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, TABLE_TYPE,DATE_CREATED | More $conn.Close() The server must have SQL 2012 native client installed and the account you use to run this script must have permissions to connect to the SQL server (SQLDEVCluster1) and access the database (TESTDB1)

to download all files from a SharePoint library Function Get-FilesFromSPSLibrary { Param ( [string] $FolderPath, [string] $SiteURL, [string] $ListTitle ) if (-NOT (Test-Path $FolderPath -PathType 'Container'))  {            write-host "`n[$($FolderPath)] is not a valid folder or you have no access to it`n`n"  return         } [net.httpWebRequest] $req = [net.webRequest]::create($SiteURL) $req.Method = "HEAD" $Req.UseDefaultCredentials = $true; try { [net.httpWebResponse] $res = $req.getResponse() } Catch {   write-host "`nSite [$SiteURL] is inaccessible`n" return } $MySite = Get-SPWeb -Identity $SiteURL $Mylist = $MySite.Lists[$ListTitle]  if ($Mylist -eq $null)  {  write-host "Unable to open list [$ListTitle] at [$SiteURL]" return }  ForEach ($Fl in $MyList.Items) { $fname=$Folderpath+$fl.Name write-host "Downloading [$($Fl...