Category: Exclusive Series

  • PowerShell : Copy a table from one server to another

    PowerShell : Copy a table from one server to another

    In general, a DBA like us gets requests to copy a table data from one SQL Server instance to another. In that case, a DBA first sees the amount of data present in the table and then he decides a method to transfer. Normally, a DBA selects Import Export method or SSIS and of course that is a suggested way to transfer data…

  • Learn Powershell with Vimal Lohani

    Learn Powershell with Vimal Lohani

    Vimal Lohani sharing his knowledge and experience of Powershell in an exclusive series “Introduction to Windows PowerShell” SN Topic Description Posted On 1 Introduction to Windows PowerShell (Part1) Windows PowerShell is a configuration management framework.. June 12, 2015 2 Introduction to Windows PowerShell (Part2) In this session, We will learn how you can control the result.. June…

  • Script : Who deletes the databases?

    Script : Who deletes the databases?

    Hello Readers, Before starting, let me give you some background about this problem. I used to support few servers which had more than 1000 small databases. Worst part was that many users had access to create/delete databases. Many times, other users used to approach me asking “who has deleted my databases” It was a nightmare to…

  • Series : Versus

    Series : Versus

      Our Versus Series is a comparsion series of blogs. Here, we will try to compare one concept with another or one feature with another. SN Date Topic  1  04 Jun 2015  CAST vs. CONVERT      

  • Series : SQL DBA Cheatcode

    Series : SQL DBA Cheatcode

    SQL DBA Cheatcode is a series or you can say a collection of those SQL Server scripts which we find very useful while troubleshooting issues day to day. These scripts are trusted and tested however there are some chances that a script may not work with some versions of SQL Server. SN Date Topic Part…

  • March towards SQL Server : Interview Question & Answer series

    March towards SQL Server : Interview Question & Answer series

    March towards SQL Server. This is a series of interview questions & answers on a new topic every day for SQL DBAs. Special thanks to Parvinder Pal for his enormous efforts for SQL Community. Stay tuned for whole month. One Blog Daily! Casino welcome bonus rankings 2019 bonushitlist.com: we rank the top 100 online casino…