Sysads Gazette

Linux tutorials, howtos and step by step guides

How to create an Amazon S3 bucket

Year First → Months (Jan – Dec) → each month will have two folders one per server– Click on the newly created bucket → click Create folder – Enter a name for the folder → press enter – Click on the newly created folder → click on Create folder and repeat same for other folders → when done, you should have the following: 3. Delete a folder:If for any reason you decide you want to delete a folder

My list of useful apps

Will update list from time to time and if you want to share other tools you have used, please feel free and reply: [button link=”https://evernote.com” size=”mini” style=”download” color=”primary” class=”sys_btn”]Evernote[/button] [button link=”https://www.avianwaves.com/Tech/Tools/RDTabs.aspx” size=”mini” style=”download” color=”primary” class=”sys_btn”]RD Tabs[/button] [button link=”https://addons.mozilla.org/en-US/firefox/addon/ie-tab/” size=”mini” style=”download” color=”primary” class=”sys_btn”]Firefox IE Tab[/button] [button link=”https://addons.mozilla.org/en-US/firefox/addon/firebug/” size=”mini” style=”download” color=”primary” class=”sys_btn”]Firefox Firebug Plugin[/button] [button link=”https://addons.mozilla.org/en-US/firefox/addon/tree-style-tab/” size=”mini” style=”download” color=”primary” class=”sys_btn”]Firefox Tree Style Tab extension[/button] [button link=”http://nmap.org/download.html” size=”mini” style=”download” color=”primary” class=”sys_btn”]NMAP[/button] [button link=”http://www.openspf.org/” size=”mini” style=”info” color=”success” class=”sys_btn”]Senders Policy Framework[/button]

Determine SQL Server install date

[sourcecode language=”sql”] SELECT createdate AS [SQL Server Install Date] FROM sys.syslogins WHERE [sid] = 0x010100000000000512000000; [/sourcecode] – This T-SQL command helps to determine the date and time that SQL Server was installed

Use T-SQL command to get Windows information

[sourcecode language=”sql”]SELECT windows_release, windows_service_pack_level, windows_sku, os_language_version FROM sys.dm_os_windows_info OPTION (RECOMPILE); [/sourcecode] – Gives you major OS version, Service Pack, Edition, and language info for the operating system

Find SQL server and OS Version information for current instance

[sourcecode language=”sql”] SELECT @@VERSION AS [SQL Server and OS Version Info]; or SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) [/sourcecode] – This T-SQL command will help to determine the version of SQL server you are running and corresponding Windows Operating System version

Install Windows 8.1 on VirtualBox

– This is how the new Windows 8.1 Operating System looks like with the Start menu Why not comment on what you think about this Operating System