Search Results for “log shipping”

  1. Home
  2. Search Results
  3. (Page 3)
Brent Reading Book

4 Ways to Move Data Into a Reporting Server

Architecture
44 Comments
You’ve decided that you need to offload reports to a different SQL Server, and you’re willing to pay the costs. Here are the most common ways to move the data from production to a reporting server, arranged roughly from easiest-to-implement to hardest: 1. Log shipping. Log shipping is more of a technique than a feature:…
Read More

Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?

Humor
7 Comments
2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Server 2000 Service Pack 1, and it hit me…these bugs…
Read More
Office Hours Podcast

[Video] Office Hours 2018/10/3 (With Transcriptions)

Videos
1 Comment
This week, Tara and Richie discuss database corruption, CLR, DBCC issues, adding identity columns to databases, distributed transactions, tracking how recently a procedure was executed, maintenance plans, recompiling stored procs, parameter sniffing issues, troubleshooting replication with Always On, forecasting database growth and estimating capacity issues, tools for database growth forecast reports, RCSI, and much more.…
Read More
Office Hours Podcast

[Video] Office Hours 2018/7/18 (With Transcriptions)

Videos
0
This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server…
Read More
Office Hours Podcast

[Video] Office Hours 2018/7/11 (With Transcriptions)

Videos
0
This week, Brent, Richie, and Erik discuss best account practices for SQL Server, change tracking, disabled indexes, measuring queries to gauge their speed, overcoming issues between Management Studio and integration services, deadlocks and long-running processes, query tuning, and lock escalation. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to…
Read More
Office Hours Podcast

[Video] Office Hours 2018/6/27 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure vs Amazon, parameter sniffing, creating custom alerts for agent jobs, activity monitor, troubleshooting SQL Server 2014, replication, turning off auto-updating stats on tempdb, and why Brent can’t get a tan. Here’s the video on…
Read More
Menu