Knowledge Folders: Recently changed documents for Satya Komatineni

How do I schedule a backup database program on windows servers? I have SQL Server 2008 Express on my azure server. It doesn't have any tasking or scheduling tools as it is an express version. Recommendation is to write a SQL server script and invoke it through sqlcmd.exe. Then have a windows scheduler schedule it at regular intervals. By the end of this research I will know how to schedule full backups and also differential backups using command line tools.

How do I reverse clone a directory into a repo?

More documents like this are at: Git

17-Jul-20

How do I reverse clone a directory into a repo?

windows batch or command files

More documents like this are at: Computer Hardware

2-Jul-20

windows batch files

Julia modules

What to do with Coconut Milk

More documents like this are at: Recipes

26-Jun-20

What to do with Coconut Milk

what are main topics to work on for akc?

More documents like this are at: Aspire Notes

14-Jun-20

what are main topics to work on for akc?

Git Rebase

More documents like this are at: Git

2-Jun-20

Git Rebase

sample sql code

More documents like this are at: CS-SQLServer

25-May-20

sample sql code

Azure misc

More documents like this are at: azure

20-May-20

Azure misc

Error handling in ETL

More documents like this are at: azure

13-Apr-20

Error handling in ETL

sql quick journal

More documents like this are at: CS-SQLServer

24-Mar-20

sql quick journal

SSMS: Sql Server Management Studio notes

More documents like this are at: CS-SQLServer

22-Mar-20

SSMS: Sql Server Management Studio notes

Guidelines for data modelling

More documents like this are at: CS-SQLServer

28-Feb-20

Guidelines for data modelling

Journal

More documents like this are at: Git

27-Feb-20

Journal

Basic Data science with Powershell

More documents like this are at: PowerShell

21-Feb-20

Basic Data science with Powershell

sft

More documents like this are at: azure

12-Feb-20

sft

SampleStoredProc1

More documents like this are at: CS-SQLServer

6-Feb-20

This proc demonstrates

1. left Outer joins in SQLServer
2. left join by default is a left outer join
3. You can use a sub-select as a column value
4. You can use top 1 to picke the top row for case 3
5. You can use a function to get the value for a column
6. For 4 and 5, you can use the values of other columns as inputs
7. Use of inner selects for outer joining multiple tables
8. Demonstrates how to pass input arguments and use them