Viewing 15 posts - 31 through 45 (of 127 total)
hahahahahahahahahahahahahahahaha....
I got it right
Because I knew it
From a class I took in October
lulz
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 21, 2017 at 7:48 am
When splitting data and log files, for performance reasons its been a recommendation for separate spindles....when using rotating disk drives in a non-SAN setup.
Logical volumes still use the...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 18, 2017 at 6:31 am
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 17, 2017 at 11:57 am
I've always used this to check physical files to current dbnames
select d.name, m.name, m.physical_name
from sys.master_files m
inner join sys.databases d
on (m.database_id =...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 17, 2017 at 7:16 am
first...Always On doesn't mean anything. Do you mean Failover Cluster Instances, or Availability Groups?
Second, you need to go check the Microsoft documentation on this, for whichever of the two...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 16, 2017 at 3:35 pm
Aaron says it better than I can:
https://dba.stackexchange.com/questions/73324/tempdb-will-not-shrink-no-open-transactions
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 16, 2017 at 3:32 pm
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 12, 2017 at 9:02 am
Toyota North America's new HQ in Plano, TX offers the same thing, and they advertise it all over their LinkedIn recruiting efforts. Not sure about onsite/WFH mix. I'm tempted...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 12, 2017 at 8:25 am
Is there anything relating to network protocols or the login failures in the ERRORLOG file?
path similar to:
C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Log
And are you connecting locally...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 12, 2017 at 6:36 am
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 11, 2017 at 6:37 am
As VastSQL said, your connection manager for the package is likely pointing to the old server
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 10, 2017 at 7:46 am
In addition to Sue_H's answer, check to see if there are indexes on the various tables...2016 has them, older versions do not. Not sure when this changed. I've had...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 10, 2017 at 7:39 am
Also look at the size of the backupset table(s) in MSDB....if that old data isn't getting purged it can cause the new info about backups to fail to write to...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 6, 2017 at 7:30 am
" I submit that if I am opening a hex editor on your SQL Server you are already p0wned. "
Bingo 🙂
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 5, 2017 at 9:23 am
Another option is to set it to Restricted_user instead of Single.
The semi-colon is a statement terminator...some connection might be getting in between statements is my thinking. I had...
------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]
July 5, 2017 at 8:23 am
Viewing 15 posts - 31 through 45 (of 127 total)