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

Post has attachment
The requirement of data refactoring is very common and vital in data mining operations. In the previous article, you’ll learn the tips for getting started with SQL string functions, including the SQL substring function for data munging with SQL Server. As…
Add a comment...

Post has attachment
In this article, you’ll learn the tips for getting started using SQL string functions for data munging with SQL Server. In many cases, Machine learning outcomes are only as good as the data they’re built on – but the work of preparing data for analytics…
Add a comment...

Post has attachment
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques to build applications using SQL Server tools. The first article of the series covers the rudimentary DevOps concepts and discusses on a…
Add a comment...

Post has attachment
SQL Server 2017 is considered a major release in the history of the SQL Server life cycle for various reasons. From my personal point of view, SQL Server 2017 is indeed an interesting release. After writing a lot about it and testing various features of…
Add a comment...

Post has attachment
It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database backup-and-restore features and skills you’ll need to build good backup-and-restore strategies using the available tools and techniques.…
Add a comment...

Post has attachment
In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do you delete six months old data to reduce the size of the backup and restore history tables? How do you get the Backup History for…
Add a comment...

Post has attachment
In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL Server database backup-and-restore (recovery) internals, you can refer to the following full list of topics. Define database restore Define the…
Add a comment...

Post has attachment
Let’s deep dive and review each of the database backup command topics to get a better understanding of what it is all about. In this article, we will find an answer for FAQs about the SQL Server database backup. We will learn more about database backup.…
Add a comment...

Post has attachment
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio…
Add a comment...

Post has attachment
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers using SQL Ops Studio (SOS). Before proceeding, you need to have Docker engine installed and SQL Ops studio…
Add a comment...
Wait while more posts are being loaded