2023-02-15
3,737 reads
Uncategorized
Constant Learning
Yesterday, I had the opportunity, and the privilege, to attend an all-day workshop put on by Bob Ward teaching all about SQL Server 2022 (you can take this too, Bob is presenting it at SQLSaturday Austin and SQL Bits, and there will be more). It was a great day. Bob is an excellent teacher. Even […]
2023-02-11
109 reads
Steps to add a new disk to SQL Server failover cluster instance and move a user database to it
In this article, we look at the steps to add another disk to an existing Windows Failover Cluster used for SQL Server and also how to move an existing database to this new disk.
2023-02-10
2023-02-17 (first published: 2023-02-10)
10,653 reads
Index Types in PostgreSQL: Learning PostgreSQL with Grant
In this article I’m going to go over the different types of indexes and some index behaviors. We’ll get into what the indexes are, how they work, and how best you can apply them within your databases. I’m hoping you’ll develop an understanding of which indexes are likely to work better in each situation.
2023-02-08
Schedule Jobs on a Clustered SQL Server
In this article, you will learn how you can schedule jobs in a clustered environment that will only execute on the primary node.
2023-02-06
5,439 reads
Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1
This tip will review the different ways of granting privileges in SQL Server, Oracle, and PostgreSQL, the differences in the concepts of roles, schemas, and owners, and the way to grant permissions on the whole schema.
2023-02-06
692 reads
Outsourcing Operations
When I first started working in technology in the 90s, it was a time of outsourcing lots of work overseas. Many large companies followed the wave of manufacturing in the 70s and 80s by many companies, including lots of semi-conductor manufacturers. I watched as a number of jobs moved overseas, though fortunately not mine. In […]
2023-02-06
144 reads
2023-02-06 (first published: 2023-02-04)
223 reads
Extend your Power BI Reports with Analysis Services 2022 Data
This tip walks through the steps of how to combine data from SQL Server Analysis Services SSAS 2022 with other data using Power BI Desktop.
2023-02-03
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers