Poking the Bear

If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you.

That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done so in the past. It's literally none of my business and I was wrong to have presumed otherwise. I'm sorry.

However, if you're teaching Trace Events to the new kids, I think you're wrong.

I totally understand why you want to continue using Trace. See above. I support you. I don't understand why you would choose to have new people, who are likely only ever going to work on newer versions of SQL Server, and working with cloud technology, learn a technology that hasn't grown or improved in 14 years and only partly works in the cloud. The only exception, if you're teaching these new people 2008R2 or less (and if so, I'm sorry for your pain).

These are new, fresh, people, learning cool new tech, why inflict old school methods on them? You wouldn't trot out Query Analyzer (also from SQL Server 7) as a way to write queries in SQL Server 2022. Why teach them a monitoring tool from 1998?

Grant Fritchey

Join the debate, and respond to the editorial on the forums

This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.

This article dives into all the math required to convert historical times between time zones.

In this article, I will introduce two JavaScript frameworks that can be used to build backend projects.

Tomaz Kastrun continues an advent series on Azure ...

EDC CEO says AI will stimulate all of NYC's core industries, including retail and health care.

In today’s competitive landscape, customer experience can make or break a business, and companies need to know more about their customers than ever before. One way to do so...

Learn about how SQL Server stores data on a data p...

Introduction These are my SQL Server Diagnostic In...

In this article, I want to talk about a topic that...

This tip will show how to configure auto-failover ...

For a couple of years now, I’ve taught my SQL Se...

There was a time when a new release of SQL Server ...

The filter arguments in CALCULATE can be written a...

This video explains the more common errors in CALCULATE filter arguments and how to solve them.

Learn how to use the Apache Spark ecosystem to fil...

With our last blog post, we started discussing Sno...

In this article, we look at constraints in Snowflake such as PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and NOT NULL and how they are enforced in Snowflake.

This article will explain various business continuity options available for Azure SQL PaaS services (SQL databases and SQL managed instances). Today we will learn about several options so that...

Azure offers you the ability to run your SQL Server workloads with optimized costs, greater flexibility, scalability, and availability along with a strong security and compliance posture all the...

The connections established to Azure SQL Database from applications or client tools may be unexpectedly terminated and impact user environments due to internal (System) maintenance work, client networking, application-related...

The other day an exalted customer shared that they...

Row Level Security is a very key requirement for m...

Problem The first issue that developers in my team...

Reading Time: 6 minutes In this post I want to do a six-minute crash course about Synapse Studio. I wanted to do this follow-up post for a couple...

by Jasmine Omeke, Obi-Ike Nwoke, Olek Gorajek Int...

If you want to use cloud resources efficiently, le...

Is Alibaba Cloud a worthy alternative to the Big 3 public cloud providers? We examine its benefits and disadvantages to help you decide if it's right for your organization.

Flyway Desktop is the newest way to automate database deployments. In this brand new course Kathi Kellenberger provides an overview of DevOps, including definitions, tools, and demos of some of the advanced features available in Flyway Desktop.

However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them.

Anyone who has ever sifted through the Windows Eve...

One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading

It’s rare, if not impossible, to find a business that does not have a digital presence. The convenience factor of digital is accelerating the pace at which businesses are...

In 2022, the world adjusted to and worked to recover from a global pandemic and international conflict that displaced millions of families. Energy costs increased sharply and supply chain...

Building on a previous post on how the seqmc action can be used to mine frequent sequences, SAS' Amod Ankulkar explores an alternative algorithm. The post Using the cspade action...

From sparking innovation to reducing operational i...

Preconditions, postconditions, and invariants, oh ...

With qualified DevOps engineers in short supply, b...

Our goal was to transform a 'serial' and manual development and release process into one that supported parallel development work and automated releases. This article explains step one: migrating...

The Cool Pi 4 features the RK3588S chipset in a fo...

Solid-state drives don’t last forever. Here are ...

PowerShell can retrieve valuable information about...

For PGSQL Phriday #003 (the last one of 2022), Pat...

+OK

In this article, we do a comparison of Power BI and Tableau, and which tool may be a better choice for your report and dashboard development.

Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter's question on how to create a two-line dynamic title! Dynamic...

From personal observation and experience, most peo...

Believe me, every heart has its secret sorrows, wh...

I was given 4.5 months notice this past June and w...

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The type of engagement you choose affects the pace and deliverables of the project, and the...

The Go language is an open-source project started by Google. It is a statically typed, compiled language that feels like a dynamically typed, interpreted. First appeared on Go Language for...

In the late November 2022 Microsoft announced, tha...

Some are tried-and-true and others are newer, but all eight of these Linux tools should be in every ITOps engineer's tool belt.

Patients transferred and operations canceled follo...

Security researchers share their biggest initial screwups in some of their key vulnerability discoveries.

A ransomware attack on the company's Hosted Exchange environment disrupted email for thousands of mostly small and midsize businesses.

A bunch of Android OEM signing keys have been leaked or stolen, and they are actively being used to sign malware. Łukasz Siewierski, a member of Google’s Android Security Team,...

This article speaks about correlated subquery and why we need it when querying a SQL database. Additionally, we are going to understand the difference between simple subqueries and correlated...

Read through your most complicated SQL files to le...

Louis Davidson explains how bit operations work in...

This article is from The Checkup, MIT Technology Review’s weekly biotech newsletter. To receive it in your inbox every Thursday, sign up here. Like many other people, I’m pretty...

In early 2021, Crown Prince Mohammed bin Salman of Saudi Arabia announced The Line: a “civilizational revolution” that would house up to 9 million people in a zero-carbon megacity,...

Correction: this story has been updated to include...

When I met Jenni Svoboda, she was in the midst of designing a beanie with a melted cupcake top, sprinkles, and doughnuts for ears. “It’s something you’d probably never...

From security to quantum, AI and edge to cloud, our digital world is evolving and expanding more quickly than ever. With so much “noise,” it can be hard to...

The term robotics conquers up images of armies of humanoid machines, intent on taking over the world. Movies like Terminator, I Robot, and Star Wars suggest that robots are...

Kubernetes is an infrastructure platform commonly ...