How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop
Learn how to build scatter plots in Power BI and use the clustering option to automatically find clusters within the report data for easy visualization.
The Basics of Inserting Data into a SQL Server Table
Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement.
Things I've Learned About the Cloud
Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.
Rethinking SQL Explicit Transactions
This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
Data Masking: Static vs Dynamic
Learn about how static data masking differs from dynamic masking and learn which one might be best for your organization.
Build Conditional Logic - SQL IF, BEGIN, END, ELSE, ELSEIF
Learn how to build conditional logic when writing SQL code using IF, BEGIN, END, ELSE, and ELSEIF logic.
Improving the Quality of Data Governance: Where to Start?
How do we set about improving the quality of data governance within an organization? What are the priorities? Data Governance is generally considered to mean providing clear roles, responsibilities, policies, principles, and organizational structures that can ensure that data is managed well, in a way that benefits the whole organization. Where do you start?
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers