Profile cover photo
Profile photo
PowerShell SQL
117 followers
117 followers
About
Posts

Post has attachment
Microsoft Azure Cosmos DB vs. Microsoft SQL Server vs. MongoDB vs. MySQL vs. Oracle Comparison
Add a comment...

Post has attachment
This article will provide an overview of SQL Power Doc, a powerful script to document SQL Server, including pre-requisites, purpose, installation, processing and output. Automation seems to be an increasing need in IT industry. At present, PowerShell…
Add a comment...

Post has attachment
The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join an excellent group of elite authors. When I joined this family, I looked at it as a place to showcase my work online, but I never thought it was going…
Add a comment...

Post has attachment
Problem statement When I was working DML operation on the database, Tempdb has grown  80 GB. After the completion, It is noted that the tempdb has grown significantly larger and I didn’t have much space on this Server. I tried shrinking the mdf file of…
Add a comment...

Post has attachment
I was asked by the reader on how to get all the port information of SQL Servers instances. As you all knew that PowerShell is an automation framework for any of such requirement. In this post, I’ll show to how to gather the information without logging on…
Add a comment...

Post has attachment
I got a chance to work with PowerShell automation script to automate the login process. In the script, the profile is loaded using the Select-AzureRmProfile. If you try to log in using Select-AzureRmProfile you most likely encounter the following error…
Add a comment...

Post has attachment
My work is recognized and my blog is listed under Top 30 elite list. I am pleased, honored and humbled to accept this award and to join other great recipients who I have long admired and respected.  A very special thanks to the SQLShack family for their…
Add a comment...

Post has attachment
DBAs have plenty of day-to-day tasks to do as part of the administration, but one overarching task is managing the entire SQL Server environment. To do this, the full SQL Server estate must be discovered and inventoried. To accomplish that all SQL Server…
Add a comment...

Post has attachment
SQL is the essential part of SQL Administration and SQL Development. A quick overview of basics can take you a long way in the database career and make you feel more comfortable to use powerful SQL features. This article introduces the basic and important…
Add a comment...

Post has attachment
SQL date format functions like the DateDiff SQL function and DateAdd SQL Function are oft used by DBAs but many of us never took the time to fully understand these extremely useful features. For professionals just getting started with SQL Server, these…
Add a comment...
Wait while more posts are being loaded