Search this blog
-
The Current Book
MVP Award
Tags
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Search this blog
Steve’s Tweets
- @SteveRezhener I neglected to empty it which is close to an act of war in airports around the world. Fortunately th… twitter.com/i/web/status/1… 3 hours ago
- RT @redgate: #LevelUp2022 is still the talk of the town here at @redgate. And you can see why from this fab access-all-areas video from the… 4 hours ago
- RT @AnalyticAnna: SQL Saturday Los Angeles is happening this Saturday! sqlsaturday.com/2022-08-13-sql… https://t.co/v8Ffee0hcr 4 hours ago
- @peschkaj I think they set it aside to be exploded later in a cinder block and concrete reinforced bunker 4 hours ago
- @jayfalck I wisely decided not to applaud the performance 4 hours ago
- Hopefully all you in the US feel safer today after the TSA confiscated a clear plastic water bottle with 1oz of wa… twitter.com/i/web/status/1… 5 hours ago
- @thepointsguy SFO-SYD 5 hours ago
- @DonaldTreeHive Gotta brush up on those bakery skills 6 hours ago
- administration
- AI
- auditing
- Azure
- backup
- Backup/Recovery
- blogging
- business
- career
- career2
- car update
- Cloud Computing
- conferences
- containers
- continuous delivery
- continuous integration
- coping
- data
- data analysis
- database design
- databases
- Database Weekly
- data privacy
- dbatools
- DevOps
- disaster recovery
- DLM
- encryption
- Friday Poll
- GDPR
- Git
- goals
- hardware
- high availability
- Humor
- life
- Linux
- machine learning
- mcm
- Microsoft
- misc
- monitoring
- networking
- NoSQL
- PASS
- Performance
- powershell
- presentations
- Redgate
- republish
- sabbatical
- security
- software development
- software development
- speaking
- SQL Compare
- SQL in the City
- SQLNewBlogger
- SQL Prompt
- SQL Saturday
- sql server
- SQLServerCentral
- SSMS
- syndicated
- T-SQL
- T-SQL Tuesday
- Tesla
- testing
- travel
- tsqlt
- vacation
- version control
- webinar
- windows
- work
Older Posts
Meta
Monthly Archives: June 2010
PASS, Don’t Waste My Time
Update: Apparently I can’t write, or get a point across from the comments and a few emails, so I have edited this to hopefully make it clearer. The pre/post conference sessions came out today for the 2010 SQL PASS Summit. … Continue reading
Truncating the Log and Database Mirroring
I saw someone post recently that they wanted to run this code on their principal server in database mirroring to clean out a large transaction log and shrink it. alter database <mydb> set recovery simplegocheckpointgoalter database <mydb> set recovery fullgobackup … Continue reading
Posted in Blog
Tagged high availability, sql server, syndicated
Comments Off on Truncating the Log and Database Mirroring
‘Tis the Season for SQL Leaving
With the announcement of Brent Ozar (Blog | Twitter ) leaving Quest for SQL Skills, Exceptional DBA finalist Jorge Segarra (blog | twitter) taking a new job far from the Novice Chef, Kathi Kellenberger getting a new job, and more, … Continue reading
ASK SQLServerCentral – The New Community Model
We had an unexpected switch last weekend. My boss decided that we were ready to move from the Stack Exchange (SE) to an alternative, OSQA.net, without informing any of the people that work on the site. Needless to say this … Continue reading