DevOps in Space

• by Steve Jones

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)

Steve draws some DevOps parallels with how SpaceX is developing rockets.

Understanding the Internals of a Data Page

• by Mohsin Khan

• SQLServerCentral

• SQL Server internal storage

In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.

Export SQL Server Data to Excel and Add New Columns with C#

• by Additional Articles

• MSSQLTips.com

• C#
• Export
• export data
• import

Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.

Have your say about PASS Summit 2021

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Redgate has committed to organizing a free virtual Summit for the PASS Community this fall. To help guide the format and provide you and the data platform community with the best virtual event experience possible, we'd appreciate your input. As a thank you for your feedback you could win a Peloton Bike or $3,000 (the equivalent in your local currency) to donate to your chosen charity.

Easing Back to the Office

• by Steve Jones

• SQLServerCentral

• Work environment

Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.

Missing Data

• by Joe Celko

• SQLServerCentral

• Database Design

When we don't have all the information needed to model data, we often use NULL. However, that causes other issues.

Digital Event: Innovate Today with Azure SQL

• by Additional Articles

• Redgate

• Conferences, Classes, Events, and Webinars

Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.

Mastering TempDB: Managing TempDB growth

• by Additional Articles

• SimpleTalk

• Database Administration

Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth.

Patching Quickly

• by Steve Jones

• SQLServerCentral

• Database Weekly
• Patching
• Security

Prompt patching is important, as a recent ransomware situation shows.

Converting Binary Numbers To Hex

• by Steve Jones

• SQLServerCentral.com

• T-SQL

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.