This week was Microsoft Build. After four years, it was back in person in Seattle and available online. I didn't attend in person, but I did watch a number of sessions and also went through the Build 2023 Book of News. You can download the book if you want, as it provides a lengthy list […]
2023-05-26
2,834 reads
This article explains different methods to move a SQL database into a new directory of Ubuntu Linux. This article covers the following topics. How to install SQL Server 2022 on Ubuntu Linux. How to add a new drive in Linux. Attach the StackOverflow database using the database. Install SQL Server 2022 on Ubuntu I have […]
2023-05-10
1,824 reads
I've found myself to be very distracted this week. Concentration on the task at hand has proven to be a challenge. I'm pretty sure the cause is that I just came off of three weeks of travel, which can be exhausting. Concentration, like so many things in life, requires energy. No energy, no concentration. So, […]
2023-05-06
104 reads
We are proud and honored to announce DPWIT-Mental Health and Wellness Day, May 5th,2023,
2023-04-28
Firebase is a NoSQL database, while Supabase is a relational database. The type of software you’re constructing determines which database is best for your project.
2023-04-19
Today and tomorrow, as I write this, the Green Country Hamfest will be running up in Claremore, OK. Tomorrow morning, I'll be there to check out the tables and maybe pick up some new radio gear. I'll also be volunteering to help run the doors. Largely it involves just checking to be sure people paid […]
2023-04-08
71 reads
Many organizations struggle with democratizing access to data and analytics in the cloud, particularly for self-service purposes. As a result, data and analytics projects often require significant IT involvement, leading to delays, bottlenecks, and inefficiencies. Additionally, data analytics, ELT, and BI tools often require specialized technical expertise, making them inaccessible to a broader range of users. To address these challenges, organizations can adopt cloud-based data and analytics platforms that provide self-service capabilities and support modern cloud data management approaches.
2023-04-07
The CASE expression is one of the most valuable tools in your T-SQL toolbox. I use it in almost every query I write. However, there isn't a direct equivalent of CASE in DAX. Since it's a different language entirely, I don't expect it. As my grandmother used to say, I am not surprised, just disappointed. If you don't know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use? Please stay tuned.
2023-04-03
When working with Snowflake, it is important to understand the different types of tables available and when to use each one. In this tutorial, we will compare Snowflake temporary and transient tables, highlight their similarities and differences, and provide examples of when to use each type of table.
2023-03-31
Learn how you can shrink your transaction log files serially, one by one.
2023-03-31
3,572 reads
Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
I tried to find an appropriate forum to post the question. This one seems...
Comments posted to this topic are about the item Resolving Access Denied Errors During...
Comments posted to this topic are about the item The Lesser Used Functions
If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)
See possible answers