Working with SQL Server Stored Procedures and .NET
The post Working with SQL Server Stored Procedures and .NET appeared first on SQLServerCentral.
Provisioning Microsoft Fabric: A Step-by-Step Guide for Your Organization
Learn how to provision Microsoft Fabric with ease! Unveiled at Microsoft Build 2023, Microsoft Fabric is a cutting-edge Data Intelligence platform that has taken the industry by storm. This article will cover a simple step-by-step guide to provisioning …
Import Text and CSV Files into SQL Server Database with SSIS Script Task
The post Import Text and CSV Files into SQL Server Database with SSIS Script Task appeared first on SQLServerCentral.
A LEFT OUTER JOIN in SQL: What Is It?
What is a LEFT OUTER JOIN? In SQL, a LEFT OUTER JOIN is a type of join operation that combines rows from two or more tables based on a specified condition and includes unmatched rows from the left table. It allows you to retrieve data from multiple tab …
[Video] Office Hours in Telluride, Colorado
We headed up to the mountains to get away from the Vegas heat. Before the sun rose, I took your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:36 Ozan: Hi Brent, how should Volume Snapshot …
How much has data technology changed over the years?
The simple answer to this question is “a lot.” The funny part, however, is that everyone who reads that question will have similar but very different thoughts on those changes. Unless your job (or hobby) is keeping up with the current trend …
Office Hours: Before Heading Out on Vacation
I took a break from packing my bags long enough to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 02:42 T-man: Hi BO. A friend has multiple Distributed AGs (on separate business division …
Managing Change
Change is inevitable… Change for the better is not. (Jeff Moden) Time has taught me to view change (and the decisions that drove change) in a more kindly light. Things that seemed desperately important then seem less so now. Put it this way, Betamax …
PASS Data Community Summit 2023 – Sessions are available to view!
The post PASS Data Community Summit 2023 – Sessions are available to view! appeared first on SQLServerCentral.
The PASS Summit Lineup Is Out and Registration is Open!
This year’s PASS Data Community Summit is November 13-17 in Seattle. (No online version is available this year – you gotta be there in person.) If you’ve attended in person before, you already know the value: it’s like a family …
Discover the Microsoft Fabric Data Wrangler
The Data Wrangler is as interesting as hidden inside Microsoft Fabric. It’s not easy to find and activate it, but it is worth the trouble. Before digging into the Data Wrangler, let’s analyze the data features in the query environment. Data …
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,” I mostly mean the set of tables within a database.) I sometimes need to retrieve or update data across …
Bing vs Bard (Chatbot wars)
Introduction about Bing vs Bard You heard it well Chatbot wars, the war between Bing vs Bard. Ladies and gentlemen, in the Google corner we have the challenger, Bard! And in the Microsoft corner, we have a powerful AI-based in ChatGPT 4, the stupendous …
Managing the challenge of migrating to the cloud
The post Managing the challenge of migrating to the cloud appeared first on SQLServerCentral.
Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability
The post Dive into RDS Custom for SQL Server – Leverage your existing licenses and high availability appeared first on SQLServerCentral.