-
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
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?
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
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
-
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…