• AWS RDS SQL Server Database Restore and Backup using S3
    Articles,  Blog

    AWS RDS SQL Server Database Restore and Backup using S3

    – What’s up, everyone? Welcome to Josh Burns Tech. In this video, I’m gonna give you a step-by-step process that you can take to perform native SQL Server database backups and restores in AWS RDS for SQL Server, using .bak files, coming right up. (techno music) So, I’ve extensively been working with AWS RDS for SQL Server, and I really enjoy the control that you have compared to using something like Azure SQL, where you don’t really have much control as far as what’s going on in SQL Server. So, what are some use cases in which you would wanna be able to take native SQL Server backups in Amazon…

  • SQL Server training :- When do we apply de-normalization ?(Interview question)
    Articles,  Blog

    SQL Server training :- When do we apply de-normalization ?(Interview question)

    In the previous part of the video we saw the benefits of normalization we also saw how normalization help’s you to avoid redundant data and error data enter into your systems now i am sure that somewhere in your mind the three normal forms have must becomes golden rules for database designing but that hang one there is other side of the story as well we need to understand before we go and apply this normalization as golden rules for database designing in order to understand the other part of the story let us first understand the larger classification of IT systems from the data perspective from the data perspective…

  • SQL SERVER – Index Usage (Improve Performance)
    Articles,  Blog

    SQL SERVER – Index Usage (Improve Performance)

    – What’s up everyone. Welcome to Josh Burn’s Tech. In today’s video we’re gonna be looking at how to identify SQL server unused indexes and to come up with a plan to address those as well. Coming right up. (music) So listen, if this is our first time meeting, my channel folks is on tech how-to videos, tech reviews, and freelance consulting tips. So to stay up to date on all the future content that’s coming to the channel, be sure to hit that subscribe button that’s in the bottom right hand corner of your screen. And now let’s go ahead and jump into the video. So to get started,…

  • Articles

    Improve SQL Server performance using profiler and tuning advisor

    Lets start with point number 7 How can we improve SQL Server performance by using Database engine tuning advisor SQL Server performance largely depends on how you have created the index i.e your cluster index and non cluster index etc Most of the times developers do not even think about indexes By default SQL Server creates a cluster index on the primary key and that’s a only index you will find in most database by default non cluster index if you have not given thought of index or indexes I’ll say non cluster indexes far away When these default settings are taken to production It doesn’t workout for a long…

  • SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)
    Articles,  Blog

    SQL SERVER 2017 TUTORIAL: PART 05 (STORED PROCEDURE)

    Welcome to beginners tutorial Microsoft sql server part 5. today We are going to learn about the store procedure how to create it and how to execute stored procedure a Stored procedure is a set of structured query language statements with an assigned name Which are stored in a relational database management system as a group, so it can be reused and shared by multiple Programs. there are so many advantages of using a stored procedure if managed control and a validate data Larger queries can be avoided. it reduces network traffic since they need not be recompiled hence stored procedure increases reusability of code Permissions can be granted for…

  • How to Execute R/Python in SQL Server with Machine Learning Services
    Articles,  Blog

    How to Execute R/Python in SQL Server with Machine Learning Services

    Welcome back everyone in this video will cover how to execute arm python code in sequel server with machine learning services if you don’t already have ml services installed and enabled  check-out the description below for links to learn how to get set up all right let’s get to it open sequel server management studio let’s talk about a real simple example you can copy past this code from the video description below sp execute external script is a special system stored procedure that enables rm python execution sequel there’s a language parameter that allows us to choose between python and R for today’s video I decided to shares examples…

  • How to open an .MDF file? (Attach a Database in SQL Server)
    Articles,  Blog

    How to open an .MDF file? (Attach a Database in SQL Server)

    Hi. Let’s say somebody wants to share their SQL Server database with you. If they give you an .MDF and .LDF file, how do you actually look at the contents of that database? You might be tempted to try to open these files with a specific SQL Server program, like SQL Server Management Studio. But the correct approach is to “attach” these files to a specific instance of SQL Server. Let me show you how this works. First, you need a running instance of SQL Server on your machine. SQL Server 2008 R2 Express is a free edition of SQL Server. Once installed, you can open up SQL Server Management…

  • How to Enable Machine Learning Services in SQL Server
    Articles,  Blog

    How to Enable Machine Learning Services in SQL Server

    Hi, everyone in this video we will cover how to enable machine learning services after you’ve installed it on sequel server 2017 and most services not enabled by default in order to provide for control db administrators we need to configure it before executing any R python code the first step is to open sequel server management studio if you do not already have it installed check-out the description below for a link to the free download add this statement you can find the description of the below and execute before we are finish we need to restart the sequel service and verify configuration was successful open sequel server configuration…

  • SQL Server interview question  :- What is use of Coalesce and ISNULL ( SQL Server training)?
    Articles,  Blog

    SQL Server interview question :- What is use of Coalesce and ISNULL ( SQL Server training)?

    In this video will try to understand what exactly is the use of ISNULL function and what is the use of Coalesce function Let me pronounce again coalesce I am not sure that if that pronounciation is right but english is my second language In case it is not right I am extremely sorry for that In this video we will try to demonstrate ISNULL and Coalesce function First start with ISNULL In order to demonstrate the ISNULL function I have created a very simple table here The table name is tblPerson and it has two columns first name and surname and if you go and fire select query over…

  • What is CTE ( Common table expression) in SQL Server ( Doubt solving sessions)?
    Articles,  Blog

    What is CTE ( Common table expression) in SQL Server ( Doubt solving sessions)?

    Hello welcome to doubt sessions of questpond so we have in this session you know will clarify the doubt about CTE or common table expression so here’s a email we have got from one of our users I want to clarify common table expression in SQL I have ask many times but did not respond to me please clarify okay so what I will do is let me just quickly go to first to MSDN and let’s just talk about definition and then with then will do some demonstration okay you can see that a common table expression nothing but it’s a temporary result set it’s a temporary table okay…