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

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.

As machine-learning applications move into the mai...

“I admit my opinion on this is quite radical in some places.” The post IoT: An AI Pump Theory appeared first on SAS Blogs.

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

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

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

I don’t know about you, but as Microsoft has pro...

Some years ago, I wrote about what it means to be ...

(Be sure to checkout the FREE SQLpassion Performan...

So far we have been working on data or worksheets,...

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

Virginia's the first on deck since California's CC...

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

There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.

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

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

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

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

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

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

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

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

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.

You've got multiple fact tables in your Power BI d...

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

Here I will share one of my business case scenario...

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

In this video, we look at Power BI for report cons...

This book aims to explain the various versions of SQL Server in Azure, how does it fare?

This is a post that looks at how to compare data c...

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

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.

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

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

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.

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.

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

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

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.

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.

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

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

Shortcomings illustrate the lack of security rigor in critical infrastructure environments.

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

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

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

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

Total: 0 Average: 0The current article focuses on ...

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

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

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

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

Dearth of semiconductors has forced several US car...

Terabyte-using customers doubled from 7% to 14% as pandemic wore on.

Smartphone optics have been pretty much the same f...

Sec. 230 reform bills are already pouring into this Congress.

Welcome to T-SQL Tuesday, the brainchild of Adam M...

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

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

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

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

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