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

Database Weekly for October 30, 2021 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. 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 Feed]([Twitter]( This email has been sent to {EMAIL}. 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -