Search Results for &#8220;log shipping&#8221;

Backup and Recovery, SQL Server

SQL Server 2017

I’m only showing the English (1033) ones here, message ID and then text. Some of the new messages are very Azure-specific, and while I love to think that we’d get some of these features in the boxed product, I think Microsoft is just getting down to a standard shared list of message IDs. However, some…

Why Is Tracking Restores So Hard?

Last Updated June 21, 2017

Erik Darling

Phantom of the Nopera Let’s say you have a server. Let’s go one step further and say SQL Server is running on it. Crazy, I know. But hey, we specialize in crazy, here. If you want to track CREATE, ALTER, or DROP DATABASE commands, that’s easy enough with DDL triggers. But guess what? None of…

[Video] Office Hours 2016/12/21 (With Transcriptions)

Last Updated December 24, 2016

SQL Server, Videos

This week, Erik and Richie discuss latency, partition tables, SOS_SCHEDULER_YIELD, alerts, nolock, and what people look for in Senior DBA. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Enjoy the Podcast? Don’t miss an episode, subscribe via iTunes, Stitcher or RSS.…

[Video] Office Hours 2016/10/12 (With Transcriptions)

Last Updated October 15, 2016

SQL Server, Videos

This week, Brent, Richie, and Erik discuss estimating compression savings, disabling triggers, suggestions to first-time Pass Summit attendees, tools for database version control, transitioning from SQL 2000 to 2016, troubleshooting failovers, and how to convince your manager to upgrade to newer version of SQL. FYI: our regular transcriptionist is out for a couple of weeks,…

What kind of hardware can you buy for one core’s worth of Enterprise Edition?

Last Updated April 9, 2017

Licensing, SQL Server

Dell R730 Microsoft charges $14,256 for a 2-core pack of SQL Server 2016 Enterprise Edition. So how much hardware can we get for $7,128? I started with one of the more common 2-socket server models, a Dell PowerEdge R730, and then optioned it with: Chassis – up to 8 2.5″ drives (because 2.5″ drives aren’t…

We’re Renaming sp_BlitzFirst. What Should the New Name Be?

Last Updated April 9, 2017

First Responder Kit, SQL Server

338

Yesterday we announced that we’re open sourcing our free SQL Server scripts, and one of those is sp_BlitzFirst. I originally named it that because it had a funny magic-8-ball type feature: if you pass in a question as a parameter, it gives you an answer like “Outlook not so good, Access even worse.” Cute, but now…

New SQL Server Management Studio 2015/June – with Check for Updates!

Last Updated June 24, 2015

SQL Server

This morning, Microsoft announced a new standalone SQL Server Management Studio download: This is our first effort to release SQL Server Management Studio (SSMS) in a mechanism outside of the SQL Engine releases. Our goal is to update this frequently with new features, fixes and support for the newest SQL Server features in SQL Server…

Data Dumps in Disguise

Last Updated September 8, 2014

Doug Lane

sp_BlitzRS® Result: Data Dumps in Disguise Often times, a user requests a report when really all they want is raw or nearly raw data. If your Reporting Services server is under heavy load, shipping these data dumps elsewhere can help. A data dump is defined by sp_BlitzRS® as a report having: No visualizations: charts, graphs, gauges,…

Monitoring SQL Server Transactional Replication

Last Updated October 5, 2021

Replication

“It will catch up eventually. I hope.” It was the best of times, it was the worst of times. I was a SQL Server DBA, and if something went wrong in Transactional Replication I needed to find out about it right away and help keep things healthy, day or night. Here’s what I learned from…

DBCC CheckDB FAQ: Check for Corruption in SQL Server

Last Updated February 9, 2017

Backup and Recovery, CHECKDB and Corruption

DBCC CheckDB: Frequently Asked Questions It’s eating our logo. Will it stop at nothing??? Q: Do I really need to run DBCC CheckDB? Yes. If you’re even partially in charge of a SQL Server and you’d like to keep your job, you should make sure CheckDB is being run regularly. (Seriously!) Q: But WHY do…

T-SQL Tuesday: Stop Tuning with Wait Stats Percentages

Last Updated July 3, 2018

SQL Server, Wait Stats

For this month’s T-SQL Tuesday topic, Michael J. Swart told us to argue against a popular opinion, and man, is that right up my alley. I’ve told you to stop worrying about index fragmentation, stop backing up your logs once an hour, and to stop running $14k of licensing on $3k of hardware. You’re probably checking…

What You Can (and Can’t) Do With Filtered Indexes

Last Updated January 21, 2019

Indexing, SQL Server

Filters aren’t just for instagram photos. When you write a query, you (usually) don’t want to return all the rows from the table(s) involved – so you add a WHERE clause to the statement. This ensures that fewer rows are returned to the client – but doesn’t reduce the amount of I/O done to get…

Who Needs an Operating System?

Last Updated October 25, 2013

Jeremiah Peschka

Cloud Computing

In the 1950s, the global economy saw a tremendous change – container ships revolutionized global commerce. Shipping costs got 36 times cheaper with the introduction of containerization. What if you could reduce operational costs and revolutionize application and database deployment in the same way? Containers to the Future In the last few months, the developer world…

#SQLPASS #Summit2013 Professor DeWitt Keynote

Last Updated August 11, 2019

#SQLPass, In-Memory OLTP (Hekaton), SQL Server

This morning at the PASS Summit, we have the pleasure of listening to Professor David DeWitt talk about Hekaton internals. I’m actually not going to liveblog this – I’m going to sit back and take in the presentation as an attendee because it’s going to be so damn good, and I’m not going to be…

Rebuild or Reorganize: SQL Server Index Maintenance

Last Updated February 13, 2017

Index Maintenance, SQL Server

109

Index maintenance compacts a structure *and* changes physical order– both can be important! Editors Note: this post was updated in June 2014 to link to an online index rebuild bug that can cause corruption. Once up on a time, there was a database server with 500GB of data and a heavy read workload of dynamic…

The Elephant and the Mouse, or, Parameter Sniffing in SQL Server

Last Updated January 5, 2019

Jes Schultz

Development

Imagine you work for a zoo, and you need to ship an animal to another zoo. If you are told one will be a mouse and one will be an elephant, you will need to handle them differently. The Detroit Zoo used a moving van to move two elephants, while mice can be put in…

Privacy Policy for www.BrentOzar.com

Last Updated September 15, 2021

PRIVACY POLICY for www.BrentOzar.com and all subdomains This website (the “Website”) is the property of Brent Ozar PLF, LLC, d/b/a Brent Ozar Unlimited (“Ozar,” “we” or “us”). We take the privacy of all visitors to this Website very seriously. Accordingly, this privacy policy (the “Privacy Policy”) sets forth our position regarding certain privacy matters. This…

Why Availability Groups Make It Cool Again to Be a Sysadmin

Last Updated February 9, 2017

Always On Availability Groups

Professions go through phases. Some skills are highly valued for a while, then go out of fashion. Just like leg warmers and skinny jeans, some skills come back into style when you least expect it. Sideburns are back Database Administrators Started Out in the Server Room In the early days, most database administrators started out…

“Who Wrote This?” Contest

Last Updated February 12, 2017