In the technologically driven world of 2024, more individuals are finding themselves drawn towards the intricacies of database management. Central to this booming sector is SQL, a programming language exclusively...
2023-10-04
26 reads
Introducing the Fabric 5 from Data on Wheels Microsoft Fabric went to public preview this past summer. There has been content created around using the various cool features that...
2023-10-04 (first published: 2023-09-14)
336 reads
Running a bit late this month for T-SQL Tuesday (it’s not exactly Tuesday is it!) but that’s Grant Fritchey’s (blog|twitter) ... Continue reading
2023-10-04 (first published: 2023-09-14)
624 reads
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to this event last year and I’m glad to be going again. It’s a great event,...
2023-10-03
19 reads
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I...
2023-10-02
41 reads
Introduction
Power Query is a versatile tool found in both Power BI and Excel, facilitating data transformation and manipulation. Despite its efficiency in numerous data tasks, managing decimal values can...
2023-10-02 (first published: 2023-09-07)
489 reads
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...
2023-10-02 (first published: 2023-09-06)
454 reads
While working with WordPress and MySQL databases, users might occasionally encounter import errors during site migration. These errors may compromise the integrity of the database and disrupt the site’s...
2023-10-02
212 reads
I’m happy to announce that I will be speaking at SQL Saturday Boston on October 14th, 2023. This year’s session is Answering the Auditor’s Call with Automation
As DBAs, we’re...
2023-10-02
14 reads
ghough – n. a hollow place in your psyche that can never be filled; a bottomless hunger for more food, more praise, more attention, more affection, more job, more...
2023-09-29
50 reads
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers