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
Articles
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,482 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,023 reads
SQL Database Overview
Learn about what a SQL database is, what is stored in a database and how to interact with a database.
2022-06-17
SQL Monitor supports Amazon RDS Monitoring
SQL Monitor works with your SQL Server data, wherever that data exists, from local instances to AWS RDS and AWS virtual machines. You can keep an eye on your estate, regardless of where the data is.
2022-06-17
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers