Microsoft Azure Blog
Blog on Windows Azure, Microsoft's Cloud Computing Platform, as well as other technical IT matters.
-
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/
-
"Password must meet complexity requirements" Cannot be Disabled
Change in: Active Direcotry Administrative Centre -> MyDomain -> Users -> Attribute Editor -> pwd... <setting>
-
SVN Source Code Control - Enabling Editing of Log Messages
To fix error: “Repository has not been enabled to accept revision propchanges; ask the administrator to create a pre-revprop-change hook”
Solution:
To correct this, I needed to create a file in … more
-
SQL Server Projects on GitHub
https://desktop.github.com/https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kithttps://github.com/olahallengren/sql-server-maintenance-solutionhttps://github.com/Microsoft/ … more
-
Running Balance Calculation in Microsoft Excel
https://support.office.com/en-us/article/calculate-a-running-balance-f54dbfb7-324d-4688-911e-14bbb1492158 more
-
Default Teamspeak Ports
Published on Jun 1, 2017
- Default port (UDP incoming): 9987- Default filetransfer port (TCP incoming): 30033- Default serverquery port (TCP incoming): 10011- Default weblist port (UDP outgoing): 2 … more
-
Copy a SQL Server Database
https://stackoverflow.com/questions/6267273/how-to-restore-to-a-different-database-in-sql-server
http://www.sqlservercentral.com/articles/Copy+Database+Script/107377/
http://sqlhint.com/sqlserver/ … more
-
TSQL RAISERROR
https://stackoverflow.com/questions/659188/sql-server-stop-or-break-execution-of-a-sql-script
-
SQL Server TSQL for Web Content and Scraping
https://www.red-gate.com/simple-talk/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/
http://www.dataadventure.com/blog/database/download-data-from-web-on-sql-server-with- … more
-
SQL Server SELECT ... INTO Statement Limitations
https://www.red-gate.com/hub/product-learning/sql-prompt/use-selectinto-statement more
-
Remove the IDENTITY property from an existing column
https://www.linkedin.com/pulse/remove-identity-property-from-existing-column-eitan-blumin/ more
-
Programmatic Access to Microsoft Account and OneDrive
https://stackoverflow.com/questions/36715473/allowing-users-to-log-in-to-their-microsoft-account-no-uwp-documentation
-
Delete Directory using Windows Command Line When Filename Too Long Error
mkdir \emptyrobocopy /mir \empty \MyFolderToDelete