- Видео 37
- Просмотров 349 239
Kevin Hill
США
Добавлен 19 июн 2007
Free SQL Server Health Check: Optimize Your Database Performance!
Claim your free Health Check here:
dallasdbas.com/health-check-offer/
Is your SQL Server running at its best?
In this video, we describe why you should perform comprehensive health checks on your SQL Server!
Identify and fix common issues, optimize performance, and ensure your database is running smoothly.
Whether you're a beginner or an experienced DBA, getting a Health Check from Dallas DBAs can help you make the most of your SQL Server!
dallasdbas.com/health-check-offer/
Is your SQL Server running at its best?
In this video, we describe why you should perform comprehensive health checks on your SQL Server!
Identify and fix common issues, optimize performance, and ensure your database is running smoothly.
Whether you're a beginner or an experienced DBA, getting a Health Check from Dallas DBAs can help you make the most of your SQL Server!
Просмотров: 184
Видео
Dallas DBAs Theme song
Просмотров 1617 месяцев назад
Killa DBA did a great job on this song! All we asked was for him to have fun creating it :)
How to Test Restore Your SQL Server Databases!
Просмотров 1,7 тыс.Год назад
If you are not doing test restores from your SQL Server backups, how do you know they are any good in an emergency? Contact us: www.DallasDBAs.com/contact Our Services: www.DallasDBAs.com/services
From Lost to Found: How I Discovered My Dream Career in Databases
Просмотров 198Год назад
Amazing how a lunch with a friend can have decades long impact. Click here for more about us: www.DallasDBAs.com
SQL Server: Code That Writes Code
Просмотров 974Год назад
Work smarter, not harder...t-sql cheat to create code for you. Like this? Join my LinkedIn group "The Accidental SQL DBA": www.linkedin.com/groups/12660606/
SSMS - how to organize your query tabs with one checkbox
Просмотров 4,9 тыс.Год назад
Use the "Pinned Tabs" feature to help keep track of your most important queries in SQL Server Management Studio. I gave credit to Lee Markum, but it was actually Daniel Maenle that lead me to this :) Both are great folks to find and follow!
How to find the SQL Server ErrorLog
Просмотров 6 тыс.Год назад
An easy way to find the ErrorLog location without having to click around and poke into every drive on the server.
SQL Server Registered Servers
Просмотров 2,5 тыс.Год назад
How to query more than on SQL instance at time Visit us: www.DallasDBAs.com
One Minute Of Peace
Просмотров 241Год назад
Not SQL Server or Bike related, just a minute of peace watching leaves fall on an autumn day. Breathe deep and enjoy.
DallasDBAs - Who we are
Просмотров 338Год назад
More info about us: www.DallasDBAs.com Kevin on LinkedIn: www.linkedin.com/in/kevin3nf/
SQL Server Database Restore using SSMS
Просмотров 2,9 тыс.2 года назад
Super basic walk through of restoring a database in SQL Server using SSMS. Beginner level. More cool stuff: www.DallasDBAs.com
Full backups do not break SQL Server Log Shipping
Просмотров 2,5 тыс.2 года назад
Sorry so blurry...not sure why. More SQL Admin stuff at www.DallasDBAs.com and app.pluralsight.com/profile/author/kevin-hill
Renaming Databases in SQL Server
Просмотров 2,6 тыс.3 года назад
All demo walkthrough of renaming SQL Server databases! More SQL Server things: www.dallasdbas.com SQL Server Training on Pluralsight: app.pluralsight.com/profile/author/kevin-hill
Connect to SQL Server Configuration Manager on a remote server
Просмотров 3,2 тыс.4 года назад
Its so simple I'm embarrassed to admit I didn't know how to do this :) Check out my Pluralsight courses: app.pluralsight.com/profile/author/kevin-hill
Test your SQL Server Restores and run CheckDB with DBATools!
Просмотров 1,4 тыс.4 года назад
Read the blog here...it has links to some of the resources used in the video: dallasdbas.com/irl-7-test-restores-and-checkdb
SQL Server High Availability and Disaster Recovery overview
Просмотров 39 тыс.5 лет назад
SQL Server High Availability and Disaster Recovery overview
Recruiting 101 - understanding SQL Server roles and terms
Просмотров 1,2 тыс.5 лет назад
Recruiting 101 - understanding SQL Server roles and terms
SQL Server Instant File Initialization
Просмотров 2,1 тыс.5 лет назад
SQL Server Instant File Initialization
Cost Threshold for Parallelism in SQL Server
Просмотров 7 тыс.5 лет назад
Cost Threshold for Parallelism in SQL Server
SQL Server Max Server Memory setting
Просмотров 10 тыс.5 лет назад
SQL Server Max Server Memory setting
Getting Started with the SQL Server Import/Export wizard
Просмотров 26 тыс.5 лет назад
Getting Started with the SQL Server Import/Export wizard
DBA Fundamentals Day long training - promo!
Просмотров 4816 лет назад
DBA Fundamentals Day long training - promo!
Backup SQL Server to Azure Blob Storage
Просмотров 29 тыс.6 лет назад
Backup SQL Server to Azure Blob Storage
Excellent video! Very helpful!
Great tip
There are way more optional features in SSMS than I could ever describe :)
Hi Kevin, Nicely done. The explanation is very clear. Could you please explain why we should avoid shrinking the data file and what the disadvantages of shrinking the log file are, particularly in terms of recovery or any other potential issues?
Shrinking is not bad...repeated shrinking and growing just uses cycles unnecessarily and can cause performance issues. In the spinning drive days it also caused fragmentation of the disk.
Thank you for this
My pleasure!
Good morning Kevin I am interested in becoming a SQL DBA do you have any programs/ schools you can recommend? I would greatly appreciate it. Thank you for reviewing my question and providing feedback!
Not yet. I will eventually get some content onto Teachable for this very thing but its still in the planning stages
i am from india
This is Pure Gold (as Manosphere Highlights Daily channel would say).
Hope it helps you :)
thanks Kevin, appreciate this little things that helps make life easier
Glad to help
Hello Kevin, Very helpful content. On SSMS I'm seeing some tables inside database with naming "table name$change log entry$437dbf0e-84ff-417a-965d-ed2bb9650.... These table size grows like anything. Can you please guide me what are these tables ?
My first thought would be the "Change Tracking" feature, which is different from "Change Data Capture"
@@Kevin3NF thanks Kevin, Later we found there's application driven module which enabled change log setup from LS retail. We are planning to take export dump every month and truncate tables for archival and purging those data.
If I am using SQL Express which has 1.4Gb of buffer pool, and i set my max server memory to lets say 26Gb(since i have 32Gb i would leave the 6 for windows and other processes) is my buffer memory going to grow or shorten or is it staying the same and i just gave the upper RAM limit to my instance?
I don't know much about the SQL Express limitations and behaviors, but SQL BPool memory doesn't generally shrink once it hits the max. It starts paging out.
awesome !
Thanks! Super little time-saver :)
Hi Kevin, do you know how to create a google cloud instance on linux?
I know nothing about GCP, and very little about AWS
Just found this. It is great. I do keep many Tabs open. I always tried to remember the tab number because it wasn't worth saving at the moment. Thank you!
Glad it was helpful!
very well explained
Glad you think so!
I ran the Shrink and it didn't seem to do anything
I figured it out I had a Replication that the system thought it was still running I had to clear that out before it would Shrink my database
Yes, the FULL to SIMPLE to FULL won't work if there is a dependency on the log file such as the log reader agent or in an Availability Group situtation
I have 'enjoyed' fixing crawling servers with full drives after log file explosions a few times before so know the solution. Unsure why I decided to watch your video but I found myself blown away by the pleasant way that you explained the problem, its reasons and the solution while smoothly touching on the tools to analyse and the settings that were involved. Thanks, I enjoyed myself.
Thanks for the kind words! I try to be gentle with non-DBAs...and that is who sees this issue most often
omg you saved my energy and everything thanks alot
Glad it helped!
Best teacher, subscribed
Wow, thanks!
Always looking for ways to work smarter, not harder. Thanks for sharing.
Always!
Hi Kevin, what if after 16th record 17th and 18th record were added and want to recover 17th and 18th also after deleting 16th record knowing or unknowingly. Could you make a video for this scenario please Kevin? 😊
I would restore to a different database name in order to get back that 16th record.
I did that and log file is full again. What’s the configuration for avoiding this to happen again?
Hey did you get any updates on? because I am also having the same issue to figure out.
If your log file is filling up quickly AND you are backing it up regularly, is it too small? Or part of an Availability Group?
Hello Sir, you changed recovery model and fixed the issue but same senario data base is part OF always on it is not possible. How to Handel this senario
In that case you will have to do a LOT of CHECKPOINTS, LOG backups and SHRINKFILE attempts. AGs keep a lot of log file segments "active" and SHRINKFILE only removes ones after the last active one (per .ldf file)
Really informative. Thank you!
Glad you enjoyed it!
Thanks for sharing information IFI, I completely understand from your video😀
My pleasure 😊
Many Thanks It Was Very Helpful
Glad it helped
So can I restore today's data to the 3 days ago ?
If you have backups starting from before the point in time you want to restore to, yes. Minimum, you need a Full backup to start from and all of the transaction logs from then until the PIT. Any data entered into the DB AFTER that point in time will be gone
Hey kevin, Nice video and nice t-shirt :) Where can I buy this T-shirt?
That was a custom shirt for volunteers and sponsors at the SQL Community event in Dallas 2022...Azure Data Saturday I think?
This one probably doesn't work with TDE databases as you described since you need DEKs on both ends
Thanks Tony...that didn't even occur to me since I very rarely see TDE :)
Hmmm, wondering if I can create a new ldf file, link it, limit the old file and the start backing up the ldf then when the ldf is old enough to delete it or something similar, should avoid having 2 copies of the ldf
You CAN create a new .ldf file, if you cannot get a backup right away. Its a whole *thing* to get rid of the file later. When you run a LOG backup, it will do both files
Neither fix worked for me. I'm using SQLEXPRESS. -T272 has no effect. And ...Scoped Configuration, throws an error: incorrect syntax.
Our problem is that we don't do the backups our server team does and they use Rubrik. Is there a way I can use this command to connect to Rubrik and get the restore that way?
Sorry sir, I'm aware that Rubrik exists but know nothing about how it works
Good info. As my DBA friends say, we don't get paid to backup databases, we get paid to restore them. Appreciate your content.
Thanks! I appreciate that :)
Thank you so much Kevin! Very well explained
Glad it was helpful!
Thank you for the great video teacher
Glad you liked it!
You just saved me so much headache TY so much!
You're welcome!
This saved my life today! I was looking and reading solutions that won't work but you explained it well and good!
Glad it helped!
This saved me today! thank you!
Thank you for your sharing Kevin, this hint really helpful. Look forward to watching more videos from you.
Thanks for watching!
great video ;)
Thanks!
Multiple instance concurrent query. Who'd a thunk? Excellent video!
Thanks Mike
6 years later and this video is still helpful, great job, appreciate it. Thank you
Appreciate the comment...still my most viewed video ever :)
From which version of SSMS is this valid for
I don't know...probably at least 18.x?
Great video. Our vendor has the primary db and they logship us the logs. If i attempt the backup the secondary database and them restore the next days TRNs the chain breaks. Should i just trust the vendor to give me the full backup
How to set the parameters for these scripts
That will depend on your organizational goals, workload performance, etc. Start with the defaults and adjust as needed
Nice video!, I have a question, if the blob storage where I want to export the database is in another subscription what do I need? thanks.
No idea...permissions in Azure are something I am not familiar with
Thank you!!! It was driving me mad to have that many tabs open!
You're welcome!
Same here one of my junior suffered the incident at night on parellel server he tried to shrink the 3 tb log space and he failed to retrieve the space so he called me and applied same trick and cleared within a second Thanks Kevin hill for this Trick to resolve log space issue
Help Kevin my drive is full and i cannot enter simple mode. The logs are backing hard
What error trying to go to Simple? What do you mean "backing hard"? Another option is to backup the log to 'NUL', which avoids the changing of the recovery model, but takes nearly the same amount of time as a backup to Disk.