Azure Synapse, Microsoft Exam DP-900 and more in Database Weekly (2021-10-30)

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

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.

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...

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...

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.

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...

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

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

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...

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...

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...

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

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...

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...

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.

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!

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...

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

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...

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...

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...

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...

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

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

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...

Struggling with understanding what is filtering yo...

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

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.

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...

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...

The SQL standard knows an interesting feature wher...

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

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...

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

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...

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...

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

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...