Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
SQL Server Reporting Services Error: The 'ORAOLEDB.Oracle' provider is not registered on the local machine.
Open a command prompt in administrator mode
cd \oracle\product\11.2.0\client_64\BIN
c:\Windows\system32\regsvr32.exe OraOLEDB11.dll
source: https://stackoverflow.com/questions/12903366/ … more
-
Remote Desktop Error: An authentication error has occurred - The function requested is not supported
Caused by patching mismatch between workstation and server. See: http://blog.fmsinc.com/remote-desktop-authentication-error-function-requested-is-not-supported-credssp/
-
SVN List All Locked Files
What you're looking for is the svnadmin lslocks command.
I have this set up at work because we keep some Word documents in our Subversion repository (with svn:needs-lock). I have a cron job set up … more
-
Send Email Via Command Line
http://caspian.dotconf.net/menu/Software/SendEmail/ more
-
How to change the listening port for Remote Desktop
https://support.microsoft.com/en-us/help/306759/how-to-change-the-listening-port-for-remote-desktop
changing the RDP port using registry key:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\ … more
-
How to whitelist a domain in Office 365 Exchange online
http://www.mattwharton.co.uk/2014/08/how-to-whitelist-a-domain-in-office-365-exchange-online.html more
-
SQL Server From .Net: Building a DataSet with Code
http://www.sqlservercentral.com/articles/ADO.NET/171331/?utm_source=SSC&utm_medium=pubemail
-
Cloudflare IP Address Ranges
https://www.cloudflare.com/ips/
-
SQL Server Data Tools (SSDT)
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017 more
-
Cloudflare IP Resolution
https://www.ericzhang.me/resolve-cloudflare-ip-leakage/ more
-
Compare and merge two versions of a document
https://support.office.com/en-us/article/compare-and-merge-two-versions-of-a-document-f5059749-a797-4db7-a8fb-b3b27eb8b87e more
-
T-SQL code for TOP N Worst Performing Stored Procedures
T-SQL code for TOP N Worst Performing Stored Procedures
-- ============================================================
-- Author: Eli Leiba
-- Create date: 2018-02
-- Description: … more
-
SVN Command Line Syntax
Basic Checkout:
svn checkout https://MySVNServer:MyPort/svn/MySVNRepositoryName/MyFolder1/MyFolder2 MySVNRepositoryName --username MyUsername
Basic Commit:
svn commit -m "My Comment For the … more
-
Autologon and Task Scheduling
https://www.solvps.com/blog/how-to-start-a-program-at-startup-in-windows-windows-server/ more
-
How to Programmatically Identify When Your SQL Server Was Last Started
https://www.databasejournal.com/tips/how-to-programmatically-identify-when-your-sql-server-was-last-started.html
-
Collab.net SVN Edge: Remove Password Complexity Requirement
modify the appropriate setting in the security.properties file, default location is: C:\csvn\data\conf more
-
Show Query Plan of a Running Query in SQL Server
SELECT QP.query_plan as [Query Plan], ST.text AS [Query Text]FROM sys.dm_exec_requests AS R CROSS APPLY sys.dm_exec_query_plan(R.plan_handle) AS QP CROSS APPLY sys.dm_exec_sql_text(R.plan_ … more
-
Install and Patch Applications Using Ninite
https://ninite.com/ more
-
Compare Files and Folders
https://docs.microsoft.com/en-au/vsts/tfvc/compare-files?view=vsts
https://docs.microsoft.com/en-au/vsts/tfvc/compare-folders?view=vsts
https://docs.microsoft.com/en-au/vsts/tfvc/folder-comparison- … more
-
Putting a SQL Server Database into Maintenance Mode (Single User)
https://docs.microsoft.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode
http://www.sqlusa.com/bestpractices/singleuser/