You Tube

Saturday, 6 April 2024

How to Shrink Database Log File

 1st find out the logical name of the Database. using this
SELECT name FROM sys.master_files WHERE database_id = DB_ID('DataBaseName')


Now Execute this query with logical name of the Database.
DBCC SHRINKFILE('LogFile Name', 50);

now log file is 51MB or somthing

Saturday, 2 March 2024

Fill Dropdown with times in 15 Minutes Difference in JS.

 Fill Dropdown with times in 15 Minutes Difference in JS.


Try this


    <div class="input-group time">

         <asp:DropDownList ID="ddl_time" CssClass="form-select tts_textBox" runat="server">                   </asp:DropDownList>

  </div>

 <script type="text/javascript">

        function generateTimeSlots() {

            var times = ['']; // Start with an empty option

            for (var hour = 0; hour < 24; hour++) {

                for (var minute = 0; minute < 60; minute += 15) {

                    var hh = String(hour).padStart(2, '0');

                    var mm = String(minute).padStart(2, '0');

                    times.push(hh + ':' + mm);

                }

            }

            return times;

        }


        var timeSlots = generateTimeSlots();


        var dropdown = document.getElementById("<%=ddl_time.ClientID%>");


        dropdown.innerHTML = "";


        timeSlots.forEach(function (time) {

            var option = document.createElement("option");

            option.text = time;

            option.value = time;

            dropdown.add(option);

        });


    </script>

Saturday, 3 February 2024

Various Popular web hosting providers in India

 Plesk hosting services can be purchased from various web hosting providers in India. However, specific options may change over time, so it's recommended to check with popular hosting providers in India to see if they offer Plesk hosting. Some well-known hosting providers globally that often provide Plesk hosting include:


  1. Bluehost
  2. HostGator
  3. SiteGround
  4. GoDaddy
  5. ResellerClub



Please note that the availability of Plesk hosting may vary among different hosting plans offered by these providers, so it's important to review the features of each plan to ensure that it meets your requirements. Additionally, new hosting providers may have entered the market since my last update, so it's a good idea to explore recent reviews and recommendations to find the best fit for your needs.


Remember to check the most recent information from these providers and verify if they offer Plesk hosting plans in India.