Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Do presenting and writing really matter?

I’m sure you’ve heard the adage that people are more afraid of public speaking than they are of death. On the other hand, some folks can’t get enough public speaking and look forward to opportunities to get up in front of a group and talk. Writing is not so scary since it’s a solitary activity, but having someone read what you’ve written – and possibly criticize it – is quite frightening. Still, some write books or blogs for the world to see.

For over 15 years, I’ve been one of those brave people speaking at data platform events and writing about SQL Server. I’m not sure how the speaking began, but I remember the first time I approached Steve Jones (@way0utwest) about writing for SQLServerCentral. It wasn’t long before I was contributing chapters to a book and then writing my own books.

Tech writing and preparing presentations take a lot of time and work, and while there might be some exceptions, don’t expect to get rich doing these activities. Frequently, speakers at in-person events must pay their own travel expenses and may have to use their vacation or weekend time to attend. Writing blogs is typically for free, but you may get paid for articles and books. Neither is going to let you quit your day job.

Why would anyone want to do these things? The answer is that the intangible benefits can be huge. In my case, I can say that the jobs and consulting engagements I’ve taken over the past decade or so have been directly related to my writing and speaking, especially my current position at Redgate.

Creating content is also a great way to learn more about a topic, another benefit. Years ago, I was asked a question about Kerberos by a customer that I couldn’t answer. I spent a weekend trying to figure it out, but I couldn’t find one resource that told me everything I needed to know. That led to the Kerberos session that I presented at several SQL Saturdays, and here’s an article I wrote on the topic.

The most significant benefit to speaking and writing, in my opinion, is the impact you can make on others in the community. There are people out there who will watch your presentation or read your article or book and solve a problem or maybe even take a step towards their next job. You will never know the impact you can make. By writing and presenting, you can make a difference in the world.

 

Kathi Kellenberger

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Scripting with Flyway Teams and PowerShell

During the development cycle, the mechanics of reliable delivery must not be allowed to dominate the design work. With script callbacks in Flyway Teams, many of the development tasks required during a database migration can happen automatically, producing reports, build scripts, code reviews, or documentation.

Administration of SQL Server

Four Areas to Focus on When You Start A New DBA Role

You’ve just been hired into a DBA role at a new company, or you’ve been given the DBA keys at your current company. Maybe you’re a SysAdmin and your boss has informed you that you are now supposed to manage the SQL Servers...

What About Filtered Indexes?

From Callihan Data

We would all be happy if tables in our databases only contained the data we need. In reality, we tend to have data that needs kept for legal purposes...

How to Rebuild the SQL Server Tempdb Database

From MSSQL Tips

In this article we look at how to rebuild the SQL Server TempDB database when SQL Server won't start using sqlcmd along with the system stored procedure sp_resetstatus.

Azure DevOps

CI/CD for serverless SQL pools using Azure DevOps

From Kevin Chant

Reading Time: 5 minutes I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using Azure DevOps in this post. Because...

Azure SQL Database

Copy Data tool to export data from Azure SQL Database into Azure Storage

From SQLShack

DBA may import, export regularly within a differen...

Options to Perform backup of Azure SQL Database ? Part 1

From MSSQL Tips

In this article we cover various methods to export an Azure SQL Database so that it can restored and used somewhere else.

Automatic Index advisor in Azure SQL database

From SQLShack

This article will explore automatic index advisor (CREATE_INDEX, DROP_INDEX) for Azure SQL Database. Introduction Azure SQL Database enables its users to focus on database objects, tuning queries without managing...

Azure SQL Managed Instance

Azure Managed Instance Doesn’t Manage tempdb Well

From Erik Darling Data

Twelve Angry Files This post is admittedly short, but since we’re short of First Party Solutions™ to gripe to Microsoft with… I need to save this stuff somewhere. You get 12 tempdb...

Azure Synapse (SQL Data Warehouse and Data Lake)

Using Azure Synapse Serverless Pools for Data Engineering | Data Exposed: MVP Edition

From Azure SQL

Data engineering is one of the most involved, dull, and repetitive tasks in the data industry today. Bringing up the subject is a sure way to instantly clear the...

Career Growth and Certifications

Preparing for and Taking Microsoft Exam DP-900 (Azure Data Fundamentals)

From Cathrine Wilhelmsen

In this post, I share my experiences preparing for...

SQL Server Interview questions and answers

From SQLShack

This article will help you to learn and prepare SQL Server interview questions and answers. If you are looking for a job change or want to improve your interview...

Computing in the Cloud (Azure, Google, AWS)

Amazon RDS Custom for Oracle – New Control Capabilities in Database Environment

From AWS News Blog

Managing databases in self-managed environments such as on premises or Amazon Elastic Compute Cloud (Amazon EC2) requires customers to spend time and resources doing database administration tasks such as...

Performance of querying blob storage with SQL

It’s possible to query blob storage using SQL, but what about performance? In this article, Dennes Torres compares several query methods to see which one performs the best.

Conferences, Classes, Events, and Webinars

Don't miss out on 3 days of data platform training

PASS Data Community Summit is just a few days away—don't miss your chance to join the world's largest gathering of data platform professionals. Featuring over 250 sessions and speakers, Learning Pathways, keynotes, and networking opportunities, this is your chance to level up your data career. Registration is free!

Free Webcast Coming Up: How to Size Storage for SQL

From Brent Ozar Unlimited

Storage sizing isn’t just about space: it’s about latency and throughput. When you move to new hardware or the cloud, and when you try to consolidate SQL Servers, you...

DMO/SMO/Powershell

Generate PowerShell Dynamic Parameter Code

One of the topics we’ve discussed in the PowerShell Cmdlet Working Group is a request to make it easier to insert dynamic parameters.

#PowershellBasics: Sort a list

In my last post I grabbed a file list but I really need it sorted alphabetically. Now, I’ve been a DBA my entire career and one of the things that gets hammered into you is that unless you specifically sort a list, there is no guarantee that that list will be sorted...

Database Design, Theory and Development

Introduction to SQL Server sequence objects

From Simple Talk

SQL Server sequence objects can be used in place of identity columns. In this article, Greg Larsen explains how to set up and use sequence objects.… The post Introduction to...

ETL/SSIS/Azure Data Factory/Biml

Azure Data Integration Pipelines – A Deep Dive

From Paul Andrew

Having worked with Azure Data Factory and now Azure Synapse Analytics data integration pipelines ever since the resources first appeared in the Microsoft cloud platform, I’ve definitley earned (more...

Creating metadata-driven data pipelines using Azure Data Factory

From SQLShack

In this article, we will learn how to build metadata-driven pipelines using Azure Data Factory. Introduction The data management approach has evolved over the years in many iterations like...

MDX/DAX

IF – DAX Guide

From SQLBI

IF: Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE. https://dax.guide/if/

PowerPivot/PowerQuery/PowerBI

PowerShell for the SQL Server DBA ? Environment Setup

From MSSQL Tips

In this article we cover some basics about getting...

Add an Animated GIF to Your Power BI Reports

From eHansalytics

It is easy to add an animated GIF to your Power BI Reports. However, if you just add it as an image, it won’t animate. You’ll just get a...

What’s this Power BI report filtered by???

From Guy in a Cube

Struggling with understanding what is filtering yo...

?? Power BI tips from the Pros – LIVE w/ Paul Turley (October 23, 2021) (Member Chat 2nd Half)

From Guy in a Cube

Join us live as we answer your questions about Pow...

Power BI Report Automation

From MSSQL Tips

In this article we look at how to get Power BI to Auto-Create a report for your based on data input or copied into a new dataset.

SQL CLR

SQL Server CLR Introduction

From MSSQL Tips

In this article we cover some of the basics of SQL Server common runtime language also known as CLR to give you an idea where and how you might...

SQL Server News

Cumulative Update #27 for SQL Server 2017 RTM

From MS SQL Server Blog

The 27th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to...

T-SQL

Functional Dependencies in SQL GROUP BY

From Java, SQL and jOOQ.

The SQL standard knows an interesting feature wher...

Learning SQL CROSS JOIN with Examples

From MSSQL Tips

Learn various ways you to do Cross Joins in SQL Server to get every combination of records between all tables.

A Faster PIVOT for SQL Server?

From It's All Just Electrons

While working with some poorly performing code in T-SQL that used a PIVOT operator, I wondered if there was a more efficient way to get a result set of...

SQL Server NOT Equal Operators

From MSSQL Tips

Learn about writing TSQL statements using the not equal operator along with various examples of using not equals.

Changes Coming To STRING_SPLIT: Optional Ordinal Position

From Erik Darling Data

Blueprint In 2016, we got the STRING_SPLIT function. That was nice, because prior implementations had a lot of problems But out of the gate, everyone looked at what we got and...

Pulling PSE Outage Data Into SQL Server

From Steve Stedman

As part of documenting the craziness of this storm I have created a script that I run every 5 minutes that pushes data into a SQL Server database. Here...

SQL COUNT Function

From MSSQL Tips

In this article we look at various ways to use the SQL COUNT function in SQL Server to get row counts.

Inline Table Valued Functions And Catch All Queries

From Erik Darling Data

This Is Not A Solution Right off the bat, I want you to know that this is not a solution, and I’ll get to why in a minute. I’m writing...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -