Looking to Role Models - Data Platform WIT Day (2021-02-13 DBW)

 Database Weekly for February 13, 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  Looking to Role Models I've spoken at many conferences and user groups over the years. These have been one of the more enjoyable times in my career, and I encourage people to give it a try. You may not like it, but it can be exciting, rewarding, and certainly helpful in your career. One of the things that helped me start speaking and gain confidence that I could do it was seeing other people I personally knew deliver a presentation. They were a role model, and they gave me the confidence to start. In a few weeks, the Women in Technology virtual group is putting on a [Data Platform WIT Day]( with a lineup of speakers that are covering a wide variety of topics, and are great role models for anyone, but especially women in our industry. Many of us wander through our careers, and often look to others to help inspire us to set, work towards, and achieve goals. The SQL Server community has shared, inspired, and supported each other in a way I haven't seen in other areas. I am glad to see that we have different groups that continue to do this, even in this difficult pandemic time. Steve Jones - SSC Editor [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 [Comparing and Syncing Data using SQL Data Compare Command Line]( Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes. AI/Machine Learning/Cognitive Services [The battle of algorithms: Uncovering offensive AI]( As machine-learning applications move into the mai... [IoT: An AI Pump Theory]( “I admit my opinion on this is quite radical in some places.” The post IoT: An AI Pump Theory appeared first on SAS Blogs. Azure Databricks, Spark and Snowflake [Consuming Avro Data from Apache Kafka Topics and Schema Registry with Databricks and Confluent Cloud on Azure]( How do you process IoT data, change data capture (CDC) data, or streaming data from sensors, applications, and sources in real time? Apache Kafka® and Azure Databricks are widely adopted technologies in the industry, but they require specific skills and expertise to run Azure SQL Database [Azure SQL DB – Troubleshooting CPU issues]( When you have the need to find out real time what is causing high CPU issues within your Azure SQL Database, there is nothing better than using TSQL and... The... Azure Synapse (SQL Data Warehouse and Data Lake) [Azure Synapse Analytics – Feature Summary vs Status]( Updated – 10th Feb 2021 Following my previous blog post Is Azure Synapse Analytics Ready for Production? I was asked to summarize this understanding/opinion of Synapse into a simpler... [Release Your Inner Synapse]( I don’t know about you, but as Microsoft has pro... Career Growth and Certifications [Professionalism in the age of COVID-19]( Some years ago, I wrote about what it means to be ... Conferences, Classes, Events, and Webinars [SQLpassion Online Training about Locking, Blocking, and Deadlocking]( (Be sure to checkout the FREE SQLpassion Performan... DMO/SMO/Powershell [How to change Excel metadata using PowerShell?]( So far we have been working on data or worksheets,... [Query DB2 From PowerShell]( Story time: A few months ago I was in a meeting where we were all asked how we could take on a complex, but very necessary task. As they... The... Data Privacy, Compliance, and GDPR [Virginia is about to get a major California-style data privacy law]( Virginia's the first on deck since California's CC... [Data Protection Resolutions to Keep in 2021]( Click to learn more about author Sam Roguine. We’re all guilty of making New Year’s resolutions that we don’t keep. While you only hurt yourself if you don’t stick... DevOps and Continuous Delivery (CI/CD) [Ten tips for building a collaborative DevOps culture]( There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration. ETL/SSIS/Azure Data Factory/Biml [ADF, XML objects and XPath in the expression language]( When you use ADF, there are two sides to the coin. The first is the data itself that ADF does very well, from moving it from one site to... Excel [how to do it in Excel: adding data labels]( Today’s post is a tactical one for folks creating visuals in Excel: how to embed labels for your data series in your graphs, instead of relying on default Excel... Hardware [64 Cores of Rendering Madness: The AMD Threadripper Pro 3995WX Review]( Knowing your market is a key fundamental of product planning, marketing, and distribution. There’s no point creating a product with no market, or finding you have something amazing but... Performance Tuning SQL Server [Parse Time vs Compilation Time]( I’ve been messing around with long compilations recently, and a question was lingering in the back of my mind, based off of SET STATISTICS TIME ON… Is there a... [When Index Sort Direction Matters]( Ever Helpful I got a mailbag question recently about some advice that floats freely around the internet regarding indexing for windowing functions. But even after following all the best... [Statistics and the Ascending Key Problem]( I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly... The... [What’s a Size-of-Data Operation?]( Database professionals say, “That’s slow because it’s a size-of-data operation.” A size-of-data operation is when the database has to write all of the affected data again. What you’re asking... [DROPCLEANBUFFERS: A Better Test Of Storage Than Query Performance]( Relics When I’m tuning queries, people will often ask me what metrics I look at to judge efficiency. Usually, it’s just getting things to be done faster. Sometimes it’s... PostgreSQL [PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released!]( The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25. This release closes two security vulnerabilities and fixes over 80 bugs reported over the last three months. PowerPivot/PowerQuery/PowerBI [Handling MULTIPLE fact tables in Power BI]( You've got multiple fact tables in your Power BI d... [Grant or Revoke Permission on Power BI Report Server]( I have created two new PowerShell functions for Granting or Revoking permission on items in the Power BI Report Catalog. These two will be the probably be the last... The... [Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)]( Here I will share one of my business case scenario... [Zooming In on a Power BI Report]( Have you ever tried to use your browser to zoom in on a visual in a Power BI report? If you simply published your report and then zoomed in,... The... [Power BI for report consumers and end users (2021)]( In this video, we look at Power BI for report cons... Product Reviews and Articles [Book Review: Azure SQL Revealed]( This book aims to explain the various versions of SQL Server in Azure, how does it fare? [Using Data Compare with Recent Data Only]( This is a post that looks at how to compare data c... [Customizing Database Deployments using Flyway Callbacks and Placeholders]( How to customize a database deployment process using Flyway, demonstrating how to incorporate tasks such stamping a version number into the latest database build, or writing to the SQL... Product Upgrades and Releases [Security Cluster Connectivity Is Generally Available on Azure Databricks]( We’re excited to announce the general availability of Secure Cluster Connectivity (also commonly known as No Public IP) on Azure Databricks. This release applies to Microsoft Azure Public Cloud and Azure Government regions, in both Standard and Premium pricing tiers. [Microsoft365R: an R interface to the Microsoft 365 suite]( I’m very happy to announce Microsoft365R, a package for working with the Microsoft 365 (formerly known as Office 365) suite of cloud services. Microsoft365R extends the interface to the... Python [IronPython: First steps]( Python is one of the most popular languages. Julio Sampaio explains how IronPython allows you to integrate Python with .NET.… The post IronPython: First steps appeared first on Simple Talk. [Reusing your python code]( Reusing your ptyhon code I learned python in 2003 and used it for all the ETL work I was doing. It was beautiful and I would happilly wax to any... [Including a local python module]( Including a local python module As we saw in reusing your python code, you can create a python file, a module, that contains our core business logic and then re-use... R Language [Little useless-useful R functions – Use pipe %>% in ggplot2]( Using pipe %>% or chaining commands is very intuitive for creating following set of commands for data preparation. Visualization library ggplot in this manner uses sign “+” (plus) to... [Plotting multiple plots using purrr::map and ggplot]( Say we have a data frame where we would like to plot each numeric variables’s distribution. There are a number of good solutions outthere such as this one, or here, or here. [Image sizes in an R markdown Document]( At Jumping Rivers we recently moved our website from WordPress to Hugo. The main reason for the move was that since the team all very comfortable with Git, continuous integration and continuous development using a static web-site generator made more sense than WordPress. Additional benefits are decreasing the page loading time speed and general site security - WordPress sites are notorious for getting hacked if not kept up to date. [Little useless-useful R functions – Useless R poem for Valentine]( Gimmick not a poem, useless R code for your Valentine. Code for this heart shaped useless poem: And once you have the function persistent in your environment, just run:... [How to be Successful! The Role of Risk-taking: A Simulation Study]( When you ask successful people for their advice on how to become successful you will often hear that you have to take risks, often huge risks. In this post... SQL [DBA in training: SQL Server under the hood]( In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid. SQL Server Security and Auditing [Connect using Windows authentication across domains]( You’re a consultant or remote worker, and you’re connecting into your work or client network using a VPN. But when you try to connect to the SQL Server, you get this. Security News and Issues [Ransomware Profitability]( Analyzing cryptocurrency data, a research group has estimated a lower-bound on 2020 ransomware revenue: $350 million, four times more than in 2019. Based on the company’s data, among last year’s... [Best Practices for Enterprises to Prevent Social Engineering Attacks]( eWEEK BEST PRACTICES: Every organization will have its own definition of what an acceptable level of risk is and should make strong security decisions and investments backed by their... [Breached water plant employees used the same TeamViewer password and no firewall]( Shortcomings illustrate the lack of security rigor in critical infrastructure environments. [Web Credit Card Skimmer Steals Data from Another Credit Card Skimmer]( MalwareBytes is reporting a weird software credit card skimmer. It harvests credit card data stolen by another, different skimmer: Even though spotting multiple card skimmer scripts on the same online... Software Development [Building an MVP That Is Centered on User Behavior]( Click to learn more about author Tuhin Bhatt. Everyone from Uber to Facebook and even Amazon had their initial versions as MVPs (Minimum Viable Product). Building an MVP is considered... [Growth Engineering at Netflix?—?Automated Imagery Generation]( Growth Engineering at Netflix?—?Automated Imagery Generation by Eric Eiswerth Background There’s a good chance you’ve probably visited the Netflix homepage. In the Growth Engineering team, we refer to this as the top of... T-SQL [Sequence]( Introduction The Sequence operator reads all rows from all its inputs, in order, and without modification. It returns all rows it reads from its last input only. This operator... [Number series generator challenge solutions – Part 2]( Itzik Ben-Gan digs deeper into reader submissions to a recent challenge for an efficient number series generator. The post Number series generator challenge solutions – Part 2 appeared first on... [SQL Server DELETE – Removing One or More Rows from a Table with Slightly Advanced Scenarios]( Total: 0 Average: 0The current article focuses on ... [Signs You Need Dynamic SQL]( Nothing Works There are things that queries just weren’t meant to do all at once. Multi-purpose queries are often just a confused jumble with crappy query plans. If you... [OUTPUT Clause with an insert statement]( So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was just inserted. For instance... [CTEs Instead of Derived Tables]( The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an eight page print out... [Visualizing a set of SQL Server Graph tables by generating TGF Format]( In my last blog, I built some Powershell to take a graph that I had modelled and bring that into SQL Server in a format that could be imported... Tech News [White House hastens to address global chip shortage]( Dearth of semiconductors has forced several US car... [A terabyte isn’t what it used to be—14% of Internet customers use more]( Terabyte-using customers doubled from 7% to 14% as pandemic wore on. [A new lens technology is primed to jumpstart phone cameras]( Smartphone optics have been pretty much the same f... [Proposed Sec. 230 rewrite could have wide-ranging consequences]( Sec. 230 reform bills are already pouring into this Congress. Tools for Dev (SSMS, ADS, VS, etc.) [T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome]( Welcome to T-SQL Tuesday, the brainchild of Adam M... [T-SQL Tuesday #135 – The Tools That Make My Job Awesome!]( Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday.... [T-SQL Tuesday #135 – The Tools That Make My Job Awesome!]( Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday.... The... [T-SQL Tuesday #135 – Awesome Tools]( It’s blog party week for T-SQL Tuesday, and I think this is a good choice for a topic. The host this month is Mikey Bronowski, and his invitation is... The... [T-SQL Tuesday #135 – My tools to stay alive]( It’s February, it’s Tuesday, and we all know what that means. Time for another T-SQL Tuesday post. Our host today is Mikey Bronowski (b|t), who asks us to write... [T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome]( It’s been a while since I’ve posted on a T-SQL Tuesday topic and glad to see the topic being discussed by Mike Bronowski (blog) on tools. Throughout my career,... The...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -