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.
2022-10-12
Articles
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.
2022-10-12
Rethinking SQL Explicit Transactions
This article looks at a simple example of using explicit transactions when modifying data in SQL Server tables.
2022-10-10
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.
2022-10-07
3,498 reads
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.
2022-10-07
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?
2022-10-07
Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance - Part 6
This article covers tips on establishing, enhancing, and empowering collaboration, communication, and governance on Cloud Transformation projects.
2022-10-05
Transaction locking and row versioning guide
In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.
2022-10-05
How to work with Python in Azure Data Studio
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
14,419 reads
Convert Problematic Data in SQL Server
In this article, we look at various ways to convert problematic data in SQL Server by using TRY_CAST, TRY_CONVERT, and TRY_PARSE.
2022-10-03
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
PowerBI Question - Data Sources
I don't see a PowerBI forum, so I'm posting here. I have a need...
SQL Server Certificates
Comments posted to this topic are about the item SQL Server Certificates
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers