Had a dev doing the opposite, he had temp admin access to set up all his tools on fresh machine and wondered why he couldn’t find SSMS when he had installed SQL Server.
I have had this. Database, about 50GB, about 175, unrelated, tables, application being retired. PM asks, can you stick the database all in an excel spreadsheet so we can, for legal reasons, keep it accessible for 50 years?
hehe, reminds me of the time I blew away a whole database in SQL 7 finding this nifty tool that in enterprise manager sounded like it would copy data from one db to another – which it does, but first it drops every table in the target database. thank god that was dev.
There was nothing under Maintenance Plans in SSMS! I set some up right away to backup the databases and transaction logs and even shrink the files to save space. What? Ola Halla what?
“Brent Ozar First Responder Kit”
“What is database corruption”
“Database stuck in recovery mode”
“How to fix replication”
“What are Availability Groups”
“What’s a deadlock”
“Why is my query slow”
“How to move user logins”
“How to restore a database and logs up to a point”
“Bars near me”
“Jobs outside of IT”
I broke a prod DB and now restoring from backup:
– “sql server restore taking forever how to check progress”
– “how to check estimated completion time of sql restore”
– “management studio restore progress bar accurate??”
– “what to tell angry users while restore running”
– “how to tell if SQL restore is stuck or still running”
I’ve just accidentally kicked off a FULL backup of our main production application database… in the middle of the day. Users are already asking why things feel “slower than usual”
– “sql server backup progress t-sql”
– “check backup percent complete sys.dm_exec_requests”
– “how to see ETA for backup in SQL Server”
– “does full backup slow down production”
– “can I cancel backup without corrupting db”
– “what to tell angry users”
– “what to tell angry manager”
– “what is a PIR”
I’ve just accidentally kicked off a FULL backup of our main production application database… in the middle of the day. Users are already asking why things feel “slower than usual”
– “sql server backup progress t-sql”
– “check backup percent complete sys.dm_exec_requests”
– “how to see ETA for backup in SQL Server”
– “does full backup slow down production”
– “can I cancel backup without corrupting db”
– “what to tell angry users”
– “what to tell angry manager”
– “what is a PIR”
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:123456; actual 0:0). It occurred during a read of page (1:123456) in database ID 5 at offset 0x0000003c000000 in file ‘C:\MSSQL\Data\MyDatabase.mdf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
Developer here: I opened my big mouth and said we should migrate the database from Access to SQL-Server. Now I’ve been given the job! Where do I start?
Why is TempDB full?
What is compatibility level?
Best chair for sitting all day at a computer
Funny SQL jokes to impress my team
How to stop my laptop from making jet engine noises
Cheap lunch ideas near me
What does RTFM mean?
I did that on my first day as a real solo DBA in a job for a museum. When I looked for backups I couldn’t find them. When I asked, they said they used backup software, ARC Serve(?). What they didn’t realize is that the software required a plugin for SQL Server, which they didn’t purchase. So there were backups, just not SQL Server backups. They had to tell everyone to re-input the data. No one grumbled. I wonder if it had happened before:)
“How do I undelete data?”
“How do I un-truncate a table?”
“How to restore database with a log file”
“How to open database log file”
“How to restore single database backup file faster”
“SQL code library”
“average salary dba”
“free sql classes”
“recover corrupt backup file”
“difference between junior dba and senior dba”
“how to become a dba”
“how to download database”
“truncate table with rollback”
“drop database with rollback”
“why do I get the same query results when I changed the server connection by clicking on another server in Object Explorer?” (I actually had a software developer who thought that changed the query window’s connection)
“how to find SQL Server Management Studio after installing SQL Server”
“how to find SQL Server Management Studio”
“difference between SQL Server Management Studio and SSMS”
“how to pronounce SQL”
“how to import screenshot data to populate table”
“my server is still slow even with daily reboots”
“why won’t SQL Server let me drop tempdb when I don’t need a temp database for my work?”
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
139 Comments. Leave new
How do I use NOLOCK?
Users are saying my SQL Server is slow, what do I do?
How do I restore a table?
What is SQL Server
How to undo “delete from table”
Nice
How to restore a database if you never setup a backup job?
This was going to be my entry as well 🙂
What’s a filegroup?
Why is my rollback so slow?
what is single core rollback yahoo answers
I have installed SQL Server* on my laptop, why can’t I connect to my default instance?
*It’s actually just SSMS
Had a dev doing the opposite, he had temp admin access to set up all his tools on fresh machine and wondered why he couldn’t find SSMS when he had installed SQL Server.
I was getting reports of people’s queries going slow so I rebooted the server.
“Who Is Brent Ozar and why does he keep appearing in my search results”
?????
That was supposed to be laughing emoji’s
Usually followed by, after a couple of months: “Are the fundamentals and mastering classes worth It?”
My database keeps growing and I have a lot of free space. How can I automate shrinking it so we have a smaller database?
How do I index all the columns so everything goes faster?
What are these “statistics” things I keep hearing about? Do I need to go take a math course?
Someone gave me an Excel spreadsheet to load in the database? How do I copy and paste the data into a table?
This one made me spit my coffee out.
For real though, if you right-click and edit top rows in SSMS, and then line up the columns juuuuuuust right… hah.
How do I shrink the transaction log?
deleting the transactionlog gives error
Please don’t mess with the SSMS connection “Remember password” in the server, it will make me retype the sa credentials!!!
How to stop SQL Server memory leak?
Why is my SQL server slow until I restart it?
Can I delete my log file?
My database doesn’t work after deleting my log file. How do I fix it?
Hiw do I become a Senior DBA?
How is DB formed?
What’s the difference between SQL and Sea Quill?
And perhaps NyQuil & DayQuil
Application was installed in master database. How do I fix it?
Where do I find SQL Server’s Recycle Bin?
What is the difference between a primary key, clustered index and non-clustered index?
Does Shrink go before reOrg in the maintenance plan?
I want to download IMDB into SQL Server, but only want to get the original movies. Is there a way to index for that?
*Real World Question from a developer* How do I add this database to PowerBI and how to use PowerBI.
what’s a deadlock and why is this stored procedure being “killed” by the system? Why doesn’t it just “wait” its turn to update a table?
How do I export this to Excel?
I have had this. Database, about 50GB, about 175, unrelated, tables, application being retired. PM asks, can you stick the database all in an excel spreadsheet so we can, for legal reasons, keep it accessible for 50 years?
I mean… do you still call yourself a DBA if you can’t?
I have one single data table with 75 columns that holds everything my system needs, why is the performance so bad? I did create 25 indexes already!
SR SQL DBA positions fully remote
…
SR SQL DBA Interview questions and answers
How do I restore an encrypted MSSQL database
Does anyone have a script?
Who is this Essey everyone keeps talking about?
Why is “Select * From MyTabLe” so slow?
Which is faster: an African or a European swallow?
But carrying a coconut or not?
i don’t knooooooooooooooooooooooo
Why is SQL ldf 4 terabytes and growing?
For a 20 MB database?
I’ve added all the Missing Indexes that SSMS keeps recommending. Now my database is slow when I insert new records. Why?
FREE Brent Ozar Classes
Why can’t I restore my database from the ‘diskdump’ device?*
* An actual search made by a jr dba** on versioin 6.5.
** Me. I was the jr dba. Inheriting a mess.
I was going to post that. 🙂 I recall such post in the old newsgroup forums.
hehe, reminds me of the time I blew away a whole database in SQL 7 finding this nifty tool that in enterprise manager sounded like it would copy data from one db to another – which it does, but first it drops every table in the target database. thank god that was dev.
“How to change sa password, someone stole the community post-it note”
Hey DBAs, application is slow, fix it!
*and ofc doesn’t provide any type of details
**provides a looong API error nowhere mentioning databases
What is a ‘covering index’?
Best way loop over rows
Missing rows in left join
How to recover deleted rows after running “Delete from [tablename]” without WHERE condition
I ran the scripts in production instead of dev. I ran ROLLBACK but that didn’t work. Isn’t that like Edit-Undo?
How do I undo a SQL Injection attack?
My cousin says he can do the same things with MS Access, for much less money. Is that possible?
How do I build screens in SQL Server like the ones I can build in Access?
Users are our friends, they will never blame us for anything.
Was there a Primary Server? Just asking since there is a Sequel Server. Also if there is a lock on a table, what keys are used to unlock it?
Does that make a collection of flat files a Prequel Server?
Why do I have to shrink the database after rebuilding the indexes?
Senior DBA: Carve out some time to watch Ozar videos every day this week.
Junior DBA: I’ve seen all 4 seasons and I’m pretty sure Jason Bateman never mentions SQL Server.
Will AI bots replace me, do i even have a future as jr SQL DBA?
How much discspace does one record claim? (Real real world question from an IT person).
Pros/cons of setting the sa password to so its easy for everyone to remember?
Can I get my dropped database back, without a backup? Followup: do we NEED mdf and ldfs? Are they important?
How to turn on NOLOCK by default
How to use cursors in SQL Server
How to set up a linked server
Linked Servers aren’t that bad… for transferring monitoring data
There was nothing under Maintenance Plans in SSMS! I set some up right away to backup the databases and transaction logs and even shrink the files to save space. What? Ola Halla what?
Top 5 anime battles
“Brent Ozar First Responder Kit”
“What is database corruption”
“Database stuck in recovery mode”
“How to fix replication”
“What are Availability Groups”
“What’s a deadlock”
“Why is my query slow”
“How to move user logins”
“How to restore a database and logs up to a point”
“Bars near me”
“Jobs outside of IT”
that punchline landed well
Dear ChatGPT,
Do chicks REALLY dig DBA’s? ‘Cause I’ve been doing this for 72 hours and am still gettin’ NO action. :-/
I accidentally deleted the production database, am I a senior DBA now?
only if you fix it within your rpo/rto 🙂
What are the different types of backups and how many backups do I need to have?
How do you pronounce SQL
How can I learn SQL in one day
What IT jobs don’t involve databases
Online therapy providers
Old DBA left with password how do I get into SQL server?
I can’t find the any key on my database.
What is dbo? A schema? a user?
Who is Brent Ozar ?
SQL Server for the SysAdmin guide
What’s the best way to blame database corruption on my manager?
How do I prevent deadlocks in my SQL code?
SQl Server Error: XXXX, Severity: XX
(1) how to automate database engine tuning advisor
(2) how to change database collation
(3) create maintenance plans
(4) how to fix failover cluster
(5) download free sql monitoring tool
(6) sql server in-place upgrade failed
(7) dba resume examples
How do we make a dump of sql?
How do I connect to SQL Server?
How do I monitor page life expectancy?
How make babby?
I broke a prod DB and now restoring from backup:
– “sql server restore taking forever how to check progress”
– “how to check estimated completion time of sql restore”
– “management studio restore progress bar accurate??”
– “what to tell angry users while restore running”
– “how to tell if SQL restore is stuck or still running”
I’ve just accidentally kicked off a FULL backup of our main production application database… in the middle of the day. Users are already asking why things feel “slower than usual”
– “sql server backup progress t-sql”
– “check backup percent complete sys.dm_exec_requests”
– “how to see ETA for backup in SQL Server”
– “does full backup slow down production”
– “can I cancel backup without corrupting db”
– “what to tell angry users”
– “what to tell angry manager”
– “what is a PIR”
I’ve just accidentally kicked off a FULL backup of our main production application database… in the middle of the day. Users are already asking why things feel “slower than usual”
– “sql server backup progress t-sql”
– “check backup percent complete sys.dm_exec_requests”
– “how to see ETA for backup in SQL Server”
– “does full backup slow down production”
– “can I cancel backup without corrupting db”
– “what to tell angry users”
– “what to tell angry manager”
– “what is a PIR”
“how to delete comment on brent ozar site”
Why is my database so slow? I have an index on every column.
ChatGPT told me to … now my replication is properly broken. “How do I reconfigure replication without anyone noticing”
Accidentally removed sysadmin from all accounts how to fix.
How do I get a list of all the apps that use my SQL Server?
How many JOINs can I use at the same time?
When things get slow, I reboot the SQL Server. It never seems to help. What should I do instead?
Is there any trick to remembering the syntax for CURSORs? Even though I use them for everything I struggle each time I write a new query.
Oh yes ? Tried a Tattoo?
I deleted whole table, forgot where. How can restore table quickly
How do I fix this:-
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:123456; actual 0:0). It occurred during a read of page (1:123456) in database ID 5 at offset 0x0000003c000000 in file ‘C:\MSSQL\Data\MyDatabase.mdf’. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
I asked our sysadmin and he said running REPAIR_ALLOW_DATA_LOSS will sort all that out so you should try that
“The transaction log for database ‘xxx’ is full”
How to shrink tempdb?
How often should I rebuild my indexes?
What are the threshold value of “Cost Threshold for Parallelism” refering to?
Why doesn’t SQL use my index
Table is still in use
Can I see what caused X some time ago?
How to import / export csv’s
SQL Agent is missing on Azure
How to stop this system is shutting down message and clear who did it
How do I uninstall WID from my server?
A lot of the existing SQL servers are on SQL 2012 – maybe I should install that on the new servers too?
Download Brent Ozar training for free
* Silly search prompts:
Who is Brent Ozar, and why should I care?
Brent Ozar versus Erik Darling, who would win?
Developer here: I opened my big mouth and said we should migrate the database from Access to SQL-Server. Now I’ve been given the job! Where do I start?
Why is TempDB full?
What is compatibility level?
Best chair for sitting all day at a computer
Funny SQL jokes to impress my team
How to stop my laptop from making jet engine noises
Cheap lunch ideas near me
What does RTFM mean?
I’ve indexed every column in my table. Why is my query still slow?
Someone has dropped the production database as they thought it was a test one. Can this be recovered.
I did that on my first day as a real solo DBA in a job for a museum. When I looked for backups I couldn’t find them. When I asked, they said they used backup software, ARC Serve(?). What they didn’t realize is that the software required a plugin for SQL Server, which they didn’t purchase. So there were backups, just not SQL Server backups. They had to tell everyone to re-input the data. No one grumbled. I wonder if it had happened before:)
How to index/optimize a cartesian join
Why can’t I download SSMS? Why is it showing me Visual Studio instead?
I mistakenly restored the production database with a day old backup instead of the dev database, now what do I do?
What’s a Foreign Key?
Who is Joe Celko and why_are_all_his_tables_names_funnys?
SQL For Dummies vs SQL For Smarties – Ready, FIGHT!!!
I created the login on a different server and restore the database there but I can’t still connect using the login. Why?
My database is in full recovery and my log file is gigantic, why?
I am just adding a field with a default value on my very large table and nothing works anymore, why?
sqlserver how to undo delete quick
sql injection for dummies
a dev asked me this once: “Why does my stored procedure not update in the DB when editing in SSMS and pressing the save button?”
“How do I undelete data?”
“How do I un-truncate a table?”
“How to restore database with a log file”
“How to open database log file”
“How to restore single database backup file faster”
“SQL code library”
“average salary dba”
“free sql classes”
“recover corrupt backup file”
“difference between junior dba and senior dba”
“how to become a dba”
“how to download database”
“truncate table with rollback”
“drop database with rollback”
“why do I get the same query results when I changed the server connection by clicking on another server in Object Explorer?” (I actually had a software developer who thought that changed the query window’s connection)
“how to find SQL Server Management Studio after installing SQL Server”
“how to find SQL Server Management Studio”
“difference between SQL Server Management Studio and SSMS”
“how to pronounce SQL”
“how to import screenshot data to populate table”
“my server is still slow even with daily reboots”
“why won’t SQL Server let me drop tempdb when I don’t need a temp database for my work?”
The users says this query is really slow when it’s run via the app but it’s fast when I run it in SSMS. wtf?