Saying goodbye to a friend, number series generator, and more in Database Weekly (2021-01-16)

 Database Weekly for January 16, 2021 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News Hand-picked content to sharpen your professional edge Editorial  Who is my customer? My final job in my previous career was at a hospital. I worked there for five years in the 90s before getting my first position as a developer. While I didn’t love the career I was leaving, I did appreciate what I learned from that last job. Part of the onboarding included a short class on customer service. Going in, I didn’t expect to learn much, but I soon found out that I hadn’t really understood customer service or who my customer was. In this case, customer service didn’t mean handling complaints, but a mindset of how to work each day. Sure, the ultimate customers at a hospital are the patients, but many hospital employees have little or no patient contact. In my case, I didn’t interact with them but what I did directly affected patients. I also needed to realize that how I worked with and treated others in the department and beyond also affected patients. The culture at this hospital was wonderful. For the most part, I saw efficiency, cooperation, communication, and respect which led to wonderful customer service. I’ve worked at a few places that didn’t have the same culture of internal customer service. I depended on another team back when I was a DBA for things like new servers and internal IP addresses. One of the team members would never provide timely updates, sometimes not even when the task was complete. Once a server for a project was ready for a week or so without anyone letting me know it was ready. I was told that he didn’t bother communicating updates to others in IT, only to other departments. He didn’t understand (or maybe care) that not communicating about the server was stopping progress of a project that ultimately affected the company’s paying customers. After complaining about this and other similar incidents, his manager said that I shouldn’t expect to receive the same level of customer service that I provided. I think that an essential part of customer service means treating the others that you work with the same way that you would want to be treated. I learned about customer service almost 30 years ago, and that lesson has served me well ever since.  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 [Automating SQL Compare Snapshots using SQL Snapper]( If you have SQL Compare, then the SQL Snapper utility is very valuable 'extra' for certain team activities, because it can be freely distributed. It means that any developer can create a SQL Compare snapshot from databases that are on their local workstation and store them on the network. AI/Machine Learning/Cognitive Services [Jumbled-up sentences show that AIs still don’t really understand language]( Many AIs that appear to understand language and that score better than humans on a common set of comprehension tasks don’t notice when the words in a sentence are... Administration [SQL Server Linux]( If you have come from a windows background you may... [Simplifying Archival Processes]( Long List Of Demands Many suggestions for making changes or improvements to a process in a database are met like orders that mean, if not certain, then likely death.... [How does Query Store capture cross database queries?]( Query Store is a configuration that is enabled per database, and the plans and stats for queries executed in that database are stored in the database itself. So what... The... Azure CosmosDB [How to retrieve data from Azure Cosmos DB Analytical Storage](     Analyzing data in Azure Cosmos DB by using one of its API used to be the only way to analyze data. Using OLTP Database as source of... Azure DevOps [Build and Deploy Database Projects with Azure DevOps]( I’ve been spending the past couple of weeks going over how to add your database to source control using Azure Data Studio... Career Growth and Certifications [Which Microsoft Certification Should You Get?]( You work with data, and you’re thinking about getting a Microsoft certification. Which one should you get? If you need the certification to get a job… Then get the... DMO/SMO/Powershell [What the Shell is Happening?]( The PowerShell community is beginning another year in the world of PowerShell 7... [How to make Excel hyperlinks using PowerShell?]( Last week I have mentioned the new functions waiti... Data Mining / Data Analysis [My predictions for 2021 – Data and analytics]( Year 2020 has had a tremendous impact on our lives and has driven many changes. Since last year was a year of radical changes (which we were or were... [let's improve this graph!]( As we share what we’ve learned—and continue to learn—on how to bring data to life, we recently added a new makeover page, which illustrates concrete tips with real-world examples.... [the most important dataviz decision you make]( Welcome back to our journey of five questions to ask yourself when designing a graph for explanatory purposes. In yesterday’s post, we saw the importance of stripping away non-essential... Data Science [Data Science from scratch]( Data Science From Scratch: First Principles with Python by Joel Grus I absolutely loved this book. It has chapters introducing many aspects of data science, and then has many... Data Warehousing [Avoid These Mistakes on Your Data Warehouse and BI Projects: Part 2]( Click to learn more about author Wayne Yaddow. In Part 1 of this series, we described how data warehousing (DW) and business intelligence (BI) projects are a high priority... Database Design, Theory and Development [Heaps in SQL Server: Part 4 PFS contention]( When inserting rows into a heap, SQL Server must sometimes update the PFS page which can PFS contention and affect performance. In this article, Uwe Ricken demonstrates how to measure PFS contention. DevOps and Continuous Delivery (CI/CD) [Git in 10 commands to do 99% of gitting and keeping out of trouble]( Git is hard, probably harder than it needs to be but I have been using it for about 5 years and have a workflow that works for me. I... The... [Database version control: Getting started with Flyway]( Flyway is a multi-platform, cross-database version control tool. Carlos Robles explains Flyway’s history and shows how it works. ETL/SSIS/Azure Data Factory/Biml [These little things about Azure Data Factory]( Small data that is hard to be notic... [Connecting to SharePoint Lists with SSIS]( SharePoint lists are popular and simple tools for ... Machine Learning [How AI Empowers Machine Learning to Be More Democratized]( Click to learn more about co-author Adam Carrigan. Click to learn more about co-author Jorge Torres. Traditionally, machine learning tools were only available to enterprises with the necessary budget... PowerPivot/PowerQuery/PowerBI [Writing calculations on a real-time streaming Power BI dataset using DAX measures]( In the previous article and video, I explained a m... [Power BI Helper Version 12 (2021) Feature Summary]( Happy New Year. We wish this be a year full of hap... [Power BI: Data Model Optimization]( Saving the Day from Delay Part 1 Optimizing your data model can be a daunting task. If you read the intro to this series, you know one of the... [Getting started with Power BI Paginated Reports (2021)]( Not sure what Power BI Paginated Reports are or ho... [Handling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query/Power BI]( Some time ago I wrote a pair of popular posts about using the Query and RelativePath options of the Web.Contents function in Power Query and why they are important... [Power BI XMLA endpoint, End-to-End diagram, Dataflows and more… (Roundup | Jan 11, 2021)]( Thanks for watching this week's Power BI news roun... Professional Development [Sometimes a change is as good as a break : T-SQL Tuesday #134]( James McGillivray (blog|twitter) wants us to give ... [TSQL Tuesday #134 – Taking a break]( This month’s TSQL Tuesday invite is from James McGillivray – he asks people to write about what they were/are doing to take a break during this crisis ridden time... [A blog post about writing blog posts]( I recently wrote about how I teach, in response to a T-SQL Tuesday post from 2010. This is a continuation of that theme, suggested by my own editor. Thanks,... [T-SQL Tuesday #134–Taking a Break]( I’m a day late for T-SQL Tuesday this month, literally because I was taking a break. Yesterday I took a holiday to go snowboarding with a friend. The weekend... The... Python [Install Python on Windows]( Python is the most famous development language tod... R Language [Little useless-useful R functions – Countdown number puzzle]( The famous countdown game loved among mathematicians and people adoring numbers and why not find a way to check for solutions. [What's new with AzureR]( by Hong Ooi This is an update on what’s been happening with the AzureR suite of packages. First, you may have noticed that just before the holiday season, the... SQL [SQL Server interview questions for experienced developers]( SQL Server tech interview questions must be well crafted to make sure the candidate actually knows the topic. In this article, Sergey Gigoyan provides his favorite questions for interviewing SQL Server developers. SQL Memorial [Farewell, Gareth Swanepoel]( Not easy to say, Gareth passed away a few days ago... [We Lost Gareth Swanepoel.]( Thirteen years ago, I met Gareth Swanepoel (@Garet... [RIP Gareth Swanepoel and GoFundMe]( Last week we lost another SQLFamily member. Gareth... [RIP Gareth Swanepoel]( Gareth Swanepoel passed away on 8 Jan 2021, He was an enthusiastic and joyful member of the speaker community, who has attended and spoken at many events over the years. An updated memorial is the link. SQL Server Security and Auditing [Security update for all supported versions of SQL Server (CVE-2021-1636)]( Microsoft announced updates today for all supporte... T-SQL [Number series generator challenge solutions – Part 1]( Last month I posted a challenge to create an efficient number series generator. The responses were overwhelming... [Query to list all the procedures and triggers not having SET NOCOUNT ON defined]( It is a tiny query in size but can play a crucial ... [A use case for sp_prepare / sp_prepexec]( There are features many of us shy away from, like cursors, triggers, and dynamic SQL. T [T-SQL query to find the list of objects referring Linked Servers]( T-SQL query to find the list of objects referring Linked Servers The post T-SQL query to find the list of objects referring Linked Servers appeared first on SQLServerCentral. [Virtual Columns and Functional Indexes]( Total: 1 Average: 5 Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very... [Tracking Row Changes With Temporal Columns]( Extra, Extra Temporal tables are cool, but keeping all that history can be stressful. Change Tracking adds overhead to every transaction, and requires Snapshot Isolation to be successful. Change... [Do You Make These Mistakes When Using SQL CURSOR?]( Total: 2 Average: 5For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in the details! You can read all sorts of blasphemy in the entire... [Understanding SQL Server ALTER TABLE ADD COLUMN Statement]( Total: 1 Average: 5 This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this statement is to add a new column to an existing...  [RSS Feed]( 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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -