Тёмный
21Tech
21Tech
21Tech
Подписаться
#SQL #SQLServer #SQLDatabase #SQL 2019 #LearnSQL #SQLTutorialforBeginners #SQLTutorial #SQLStepbyStep #Database
#SQLBeginners #SQLServer2019
This is for anyone who would like to learn about SQL Server.
Having 15+ yrs of SQL DBA experience, I would like to share all my knowledge what i learned in these years.
Please let me know in comments if any idea, suggestions.
Комментарии
@LouiseDonald-rw9ox
@LouiseDonald-rw9ox 13 дней назад
2887 Marcelino Drive
@langtutorial4828
@langtutorial4828 3 месяца назад
I want to replicate on different machine not on the same machine
@VijitKumaroptimist
@VijitKumaroptimist 7 месяцев назад
Thanks a lot , this video has given me a cost reduction solution , we were able to do it on live server . Thanks
@iscan4u346
@iscan4u346 7 месяцев назад
does the DB needs to be in FULL recovery mode to use transactional replication? thanks.
@c0m4ndo
@c0m4ndo 7 месяцев назад
about publication I have this error on snapshot agent status: "The option "INLINE=ON" is not valid for this function. Check the documentation for the constructs supported with INLINE option in a function. " Please any help ???
@luandt95
@luandt95 9 месяцев назад
Hello Sir, i have a error when Create a subscription to the transactional publication. Error "Cannot find either column "dbo" or the user-defined function or aggregate "dbo.ufnLeadingZeros", or the name is ambiguous."
@vietdang1132
@vietdang1132 10 месяцев назад
hi , why i can''t configere distribition replication . It always said SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name,
@maduresenerd5716
@maduresenerd5716 10 месяцев назад
i have a question. Whose sql server password did you put when you create snapshot publication?
@kihramcizadegiller
@kihramcizadegiller Год назад
Mail (Id: 24) queued. but email not come
@richmondagyemangamponsah6173
This video saved me. Great work!
@hetalmakavana2084
@hetalmakavana2084 Год назад
im new to sql server. and i have one doubt ..that can we create only one distributer/ multiple distributer at a single instance????? plzz answer...THANK U
@21tech36
@21tech36 Год назад
Each Publisher can be assigned to only a single Distributor instance, but multiple publishers can share a Distributor. learn.microsoft.com/en-us/sql/relational-databases/replication/configure-distribution?view=sql-server-ver16
@paragkambli6866
@paragkambli6866 Год назад
I am not able to send mail using sql 2019. But I followed same process on sql 2012 and mail works fine. Microsoft has has not tested this tool properly. Configure app password in gmail and use same app password when configuring send mail account-- do not use original password or it will fail. I have not tested this process in SQL 2014, 2016, 2017.
@nat0106951
@nat0106951 7 месяцев назад
I am using 2012 and its not working
@danasdiq5010
@danasdiq5010 Год назад
Hello brother, thank you for sharing the video. I can't see "Configuration Distribution" in my SQL SERVER, any idea why? I will appreciate your answer.
@21tech36
@21tech36 Год назад
If it is already setup you will see distribution database under system database tab. You can also right click replication tab and click configure distributor as well. Hope this helps
@acknowledgment2490
@acknowledgment2490 Год назад
This is different from bigners
@deepikajoshi639
@deepikajoshi639 Год назад
Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication
@21tech36
@21tech36 Год назад
No, if you refresh subscribe database then you have to setup replication again.
@deepikajoshi639
@deepikajoshi639 Год назад
@@21tech36 thanks .. ya you are right ... I did that again... 🙂
@Kingbezy
@Kingbezy Год назад
man this Was Really helpful. 💯💯
@21tech36
@21tech36 Год назад
#iphone #iOS #DIY
@theboyholty
@theboyholty Год назад
its asking for a username and password when i try to access the reportserver
@chromeoshank563
@chromeoshank563 Год назад
Can a user log in to Reporting Services using a non-AD account? I want to provide reports produced by Reporting Services to non-company employees.
@Adanos_ger
@Adanos_ger Год назад
I was just planning to have a quick peek, but this video was actually really useful. Thank you!
@Ingles4allYou
@Ingles4allYou 2 года назад
awesome thanks
@Techie-La
@Techie-La 2 года назад
Exception from HRESULT: 0x800706B3) --- End of inner exception stack trace ---
@mathavanm5563
@mathavanm5563 2 года назад
Thanks a lot
@jackogle5913
@jackogle5913 2 года назад
Will this still work after May 30 when Google no longer allows the use of third-party apps or devices which ask you to sign in to your Google Account using only your username and password? Google is going to require "Sign in with Google" to authenticate.
@contactthejeff
@contactthejeff Год назад
Hello there. Was there any updates to this concern? Thanks!
@paragkambli6866
@paragkambli6866 Год назад
@@contactthejeff Mine not working
@lestherxm
@lestherxm 2 года назад
Thanks Sir, it works very well!
@MotionInMotion1975
@MotionInMotion1975 2 года назад
Hi man. Can this be done with Web edition?
@21tech36
@21tech36 2 года назад
No
@sirginirgin4808
@sirginirgin4808 2 года назад
Many thanks brother .Your video was very helpful..
@21tech36
@21tech36 2 года назад
You are most welcome
@naturevibezz
@naturevibezz 2 года назад
I got an error in status Unable to complete login process due to delay in opening server connection (Source: MSSQLServer, Error number: 08001
@hunaynhafeez5634
@hunaynhafeez5634 2 года назад
literally the worst tutorial ever,
@bobharford5643
@bobharford5643 2 года назад
I have a Disney add that blocks how you view the subscription in SSMS. That is the part that apparently failed in my first effort too. In short, too bad the RU-vid add blocks the final key piece of the puzzle.
@brittonwatson6225
@brittonwatson6225 3 года назад
Do you need to upgrade SSRS 2019 if you are installing Sql Server 2019?
@Johntreprenuer
@Johntreprenuer Год назад
yes
@mohammedalkhateeb7178
@mohammedalkhateeb7178 3 года назад
In the last window In The synchronous status the agent is not run although from properties it's running????
@bonillavillarreal
@bonillavillarreal 3 года назад
Error at runner scrpt create data base
@pianoLee-sx9dx
@pianoLee-sx9dx 3 года назад
This is strange.... My reportin server has been working for a while but just recently, it just can't connect and it seems to have detected two server names instead one just one...
@tejovathiv6029
@tejovathiv6029 3 года назад
Hi, These videos are very helpful to extend my skills, I faced one problem in my project, Could you help me? The Problem is, In one of the SSRS report for one filter I've huge amount of data, So while using that filter(selecting a data from drop down) getting black screen for a while and after the data gets loaded it is giving normal result. Can any one suggest for the possible solution..
@playscrape
@playscrape 3 года назад
Not enough info or troubleshooting
@timnguyen7606
@timnguyen7606 3 года назад
Can you explain how to configure scale out deployment if I have multiple SSRS servers connected to one SQL server?
@KabulFm
@KabulFm 3 года назад
Great job, brother. thank you!
@longhoang4768
@longhoang4768 3 года назад
How to fix *distributor admin is not defined as remote login* ?
@abdullahquhtani8058
@abdullahquhtani8058 3 года назад
Could you please tell use why you changed from default value "virtual account" to "network service" and the difference between them. Thank you
@andreito6642
@andreito6642 3 года назад
Thanks for the video, you have solved my doubt.
@charmantmimpembe8939
@charmantmimpembe8939 3 года назад
très intéressant
@mh63111
@mh63111 3 года назад
You solved my big issue, many thanks..!!
@abrammakgalemele3491
@abrammakgalemele3491 3 года назад
Microsoft SQL Server 2019 Reporting Services: www.microsoft.com/en-us/download/confirmation.aspx?id=100122
@narakdk
@narakdk 3 года назад
My server name is not the same as yours and when I click connect it gives me error. This is not for beginners.
@pankajmathur9
@pankajmathur9 4 года назад
Tnq sir for sharing knowledge abt replication....keep doing it for different-2 topics sir.😊
@muhammadasjad6686
@muhammadasjad6686 4 года назад
i need a little help or information. i have configured or designed a report on my Sql server report server. now i want to config same report on another system. is it possible for me to Export report from 1st server and then save it on another system?
@karabocalvin1152
@karabocalvin1152 4 года назад
Muhammad Asjad does the other server/system also have reporting services running?
@avinashareti3056
@avinashareti3056 4 года назад
Not able to click the backup option in encryption coloum. Can you provide the solution
@kyunghalee5149
@kyunghalee5149 4 года назад
Thanks for the video! Could you please help me to understand why the 'Next' button is not active when I tried to install the MS SQL Server2019 Reporting Services free version on my computer?
@21tech36
@21tech36 4 года назад
You have to check mark at accept terms and conditions box.