DevOps is a culture which promotes collaboration between Development and Operations Team to deploy code to production faster in an automated & repeatable way. The word ‘DevOps’ is a combination of two words ‘development’ and ‘operations.’ DevOps helps to increases Continue Reading..
Last week a good friend of mine (Parth Shah) asked me a very interesting question that he wants to capture TRUNCATE and DELETE statements being fired on a database with very minimal overhead on the system. When performance is the Continue Reading..
Microsoft Excel is a very powerful tool, using excel we can connect to all most all known data sources available and create a report easily. In this post, we will learn how to connect to a SQL Server database from Continue Reading..
As a SQL Server DBA, I like to code in T-SQL mostly. Recently I had a requirement where I need to delete files on conditional basis. I could have done the same writing a simple batch script or vb script Continue Reading..
When you ask a DBA or developer that, what features they would most like to see added to the future versions of SQL Server, they will undoubtedly say, “The ability to backup of a single table to physical file system Continue Reading..
In our SQL Server career, transferring or coping SQL table from one SQL server database to another is very regular and common. There is nothing new about it, we can do the same by generating table script with data or Continue Reading..