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
Articles
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
SQL Server 2016 Build List
A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.
2022-06-21 (first published: 2017-01-25)
24,269 reads
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
1,007 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
Training: Maximize the power of SQL Prompt with SQL Toolbelt Essentials
Watch this 30-minute training session to discover how you can use SQL Prompt in combination with other tools in SQL Toolbelt Essentials to boost productivity, simplify collaboration, and deliver accurate database changes faster.
2022-06-20 (first published: 2022-06-04)
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers