Search Results for &#8220;dns&#8221;

Microsoft Azure

To celebrate this month’s launch of our new class, Fundamentals of Azure Networking for the Data Professional, we’re making one video a day completely free. Here’s what’s on tap this week: July 17: Demo: Using Virtual Networks for Data Services July 18: Demo: Private Networks Without Public Access July 19: Demo: Multiple Private Networks July…

Free Azure Networking Training This Month!

Last Updated July 12, 2023

Microsoft Azure

Raise your hand if you’ve ever blamed the network. You’re responsible for the health, security, and uptime of your company’s data services in Azure. You’ve provisioned a few services, but every now and then, you run into problems making your services reachable and reliable from different users and app servers. You want to understand: Your…

1.3 Demo: Creating a Virtual Network

Last Updated July 12, 2023

We cover how to create a virtual network and configure its peerings, DNS, and more.

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, Recorded Class Season Pass – or Recorded Class Season Pass – , or log in if you already shelled out the cash.

Office Hours Speed Round: Text Edition

Last Updated July 29, 2022

Production Database Administration

Got questions for me? Post ’em at https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. I filter out the ones that are too short for video answers, and here’s the latest batch: Thomas Franz: When I have a very large table with no statistics (or not on a specific column in the…

Building PollGab.com: February’s Hosting Bill: $1.85.

Last Updated March 3, 2022

PollGab

Earlier this week, I wrote about how we designed the database for PollGab.com. Because we went with AWS DynamoDB for the database storage and AWS Lambda for the processing work, costs are really, really low: That is not a typo: that’s $1.85 USD. Richie puts the business logic in functions, and those functions run in AWS…

[Video] Office Hours: SQL Server Q&A in Cabo at Sunrise

Last Updated December 15, 2021

Let’s watch the sun rise at Land’s End and cover your top-voted questions from https://pollgab.com/room/brento/. Here’s what we covered: 00:00 Introductions 01:04 Jr Wannabe DBA: Hi Brent, a colleague wants to upgrade from Standard to Enterprise purely for performance gains on several regular servers (up to 8 CPU, 128GB of RAM, SQL 2016 or 2019).…

How to Install Azure Data Studio to Work with SQL Server

Last Updated July 23, 2020

Production Database Administration

Download Azure Data Studio on your desktop. Do this on your desktop, not the SQL Server itself. You always want to run management tools from your own machine to reduce the overhead on the SQL Server itself. After it downloads, install it – just accept the defaults. During the installation process, it may ask: You…

How to Get Started with SQL Server Management Studio

Last Updated July 13, 2020

Production Database Administration

In the big picture, you need to: Download the free Microsoft SQL Server Management Studio and install it, accepting the defaults Connect to your SQL Server Create a low-privileged login so that you don’t accidentally drop objects Learn to switch back & forth between the low-privileged account and your regular one Let’s get started! 1.…

How Azure SQL DB Hyperscale Works

Last Updated February 10, 2019

Managed Instances, Microsoft Azure

Microsoft is starting to talk about the internals for Azure SQL DB Hyperscale, their competitor to Amazon Aurora. Aurora took the open source MySQL and PostgreSQL front ends and hooked them up to much more powerful cloud-first storage engines on the back end. Here’s a quick primer on how Microsoft is doing something similar –…

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Last Updated September 24, 2018

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

[Video] Office Hours 2018/8/8 (With Transcriptions)

Last Updated August 11, 2018

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips for getting a new SQL Server DBA job, using alias names for SQL Servers, database going into suspect mode during…

[Video] Office Hours 2018/5/30 (With Transcriptions)

Last Updated June 2, 2018

This week, Brent, Erik, Tara and Richie discuss severity 16 error warning, best way to move databases from SQL 2008 R2 to SQL Server 2014, adding Analysis services to a cluster, taking to higher management, deadlocks in a transaction log shipping setup, syncing date between an on-prem and Azure SQL DB server, log backups, renaming…

Training Week: Announcing Edwin’s New Class on Failover Clustered Instances

Last Updated April 11, 2018

Clustering, Company News

This week, we’ve got a bunch of announcements about new training classes. Next up, Edwin Sarmiento: his 3-day Always On Availability Group class has been getting great reviews: “This class is fantastic. There is no filler, and no needless repetition, so be prepared to pay attention the entire duration. Edwin clearly is very passionate about…

[Video] Office Hours 2017/12/6 (With Transcriptions)

Last Updated December 9, 2017

This week Brent, Erik, and Richie discuss filestream waits, what to use instead of filestream, Availability Groups & clusters, implicit data conversion, using snapshot backups, MERGE statement bugs, deadlocks, the future of on-prem servers, Erik’s new sp_Blitz lock, and if the SQL Server knowledge base “Virtual Assistant” can answer DBA interview questions. Here’s the video…

[Video] Office Hours 2017/10/25 (With Transcriptions)

Last Updated October 28, 2017

SQL Server, Videos

This week, Brent, Erik, and Richie discuss database corruption, multi-instance clusters, career advice, whether you should transition from contract work to full time, VMware vMotion, reducing failover time with AGs, query tuning, and more. 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…

[Video] Office Hours 2017/10/4 (With Transcriptions)

Last Updated October 7, 2017

SQL Server, Videos

This week, Brent, Tara, and Richie discuss what they think about having no more service packs for SQL Server 2017 and newer versions, shrinking log files, how many servers can one DBA manage, log backups, mirroring vs Availability Groups vs log shipping, and their next company retreat location. Here’s the video on YouTube: You can…

[Video] Office Hours 2017/07/29 (With Transcriptions)

Last Updated July 29, 2017

Amazon Web Services (AWS), Backup and Recovery

SQL Server, Videos

This week, Brent, Erik, Tara, and Richie discuss SQL Server performance monitoring, ASYNC_IO_COMPLETION, AWS SQL Server licensing and fees, rebuilding indexes, licensing model for Blitz scripts, stored procedures, using (or not using) primary key on a table, choosing ORMs and other tools, and more. Here’s the video on YouTube: You can register to attend next week’s Office…

Builder Day: Doing a Point-in-Time Restore in Amazon RDS for SQL Server

Last Updated June 13, 2017

Tara Kizer

Brent had an idea that we should set aside a day per month where we could build things in the cloud and blog about our experiences. I was tasked with Amazon RDS for SQL Server: create an instance, configure backups and test point-in-time restores. After grabbing some coffee, I logged into the AWS console. We…

sp_AllNightLog

Last Updated December 13, 2022