[Video] Office Hours in Cartagena, Colombia
Before heading out to Old Town for sightseeing, I went through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:44 Haydar: Is there a good way to suppress part of TSQL batch from showing the qu …
The future of AI in solving database challenges
The post The future of AI in solving database challenges appeared first on SQLServerCentral.
Paging Data in T-SQL
Sometimes when working with very large sets of data, you may not want to return all of the data at once. I discussed using TOP in my previous article, which allowed you to only get a number of rows from the start of the results from a query. However, i …
It’s Monday. Do You Know Where Your PowerShell Training Is?
You’re over the hump! Just two weeks left to go. All month long, I’m giving away our newest class, Fundamentals of PowerShell for DBAs. Here’s what you’ll be learning this week: March 20, Mon: Parameters and Error Handling and D …
ChatGPT and PowerShell – Some practical examples
Introduction to ChatGPT and PowerShell In this article, we will show how to work with ChatGPT and PowerShell. In previous articles, we chat with ChatGPT, which is an extremely powerful language model with advanced AI, able to do a lot of tasks and code …
New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT
The post New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT appeared first on SQLServerCentral.
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in turn what is a PostgreSQL view. This article will help you to learn how to create/query/drop a PostgreSQL view, their syntaxes with working examples, an …
What are the biggest challenges organizations face in their digital transformation efforts?
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in their right mind would actually use this?” I was so horrified that I wrote a presentation about it and gave it at a couple of conferences: …
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of crite …
Recording What’s Changed when Running Oracle Migrations with Flyway
The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve w …
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. There is a good reason for such …
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough time because your work schedule is so busy and you can’t make 30 minutes of free time? Hey, maybe that’s because you’re a p …