Randomizing the Day Inside a Month Using T-SQL
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
2022-06-24
1,752 reads
Articles
DevOps 101 webinar: The role of Automation
Join Grant Fritchey to discover how automating your database deployments enables you to speed up software delivery with repeatable processes that stop your database being the bottleneck.
2022-06-24
Python Try Except Code Samples
In this article we look at how to use exception handling when writing Python scripts along with many different examples using try, except, else and finally clause.
2022-06-24
2021 Session video library available
Want to get a flavor of the type of quality training sessions offered at PASS Data Community Summit? Dive into the full video library from Summit 2021 of over 250 sessions. Take your pick from sessions covering the following themes, Reach for the Clouds, Level Up and Back to Basics, presented by top data experts from around the world.
2022-06-22
How to run Kubernetes clusters locally on Windows
Kubernetes production clusters are typically run on cloud platforms. However, running and deploying Kubernetes applications on cloud platforms such as Google Kubernetes Engine is costly. These high costs can restrict the Kubernetes learning process for beginners. However, running Kubernetes clusters locally helps you efficiently test applications without disrupting the production environment or paying for cloud services.
2022-06-22
Power BI Report Builder Expressions - Build In Fields and Functions
This article continues looking at various expressions that are available in the Report Builder. We cover some build in functions as well as various logical operators.
2022-06-20
4,684 reads
10 Benefits of Database Monitoring for Business Leaders [Video]
A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns.
2022-06-20
Automating Flyway Development Chores using Database Diagrams
If you can generate a quick Entity-Relationship diagram for any version of a database, you'll have a simple way to 'sanity check' it for unreferenced tables, missing keys and other design flaws. This article shows how to auto-generate these diagrams when running a migration, using Flyway Teams and PowerShell.
2022-06-20 (first published: 2022-06-06)
Insights from the SSRS database
The SSRS database contains a wealth of undocumented information that can help administrators. In this article, Edward Pollack explains how to get to the data and ways to use it.
2022-06-20
Fixing "The Distributor has not been installed correctly" Error with AWS
When migrating a database from SQL Server on premises to AWS, you might receive this error. Learn how to get rid of it.
2022-06-17
6,146 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers