How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks
The post How to secure legacy ASP.NET MVC against Cross-Site (CSRF) Attacks appeared first on SQLServerCentral.
Updated First Responder Kit and Consultant Toolkit for August 2023
Turns out y’all actually work over the summer – there are actually cool new features this month! I think I’m actually going to have to record updated sp_BlitzIndex, sp_BlitzLock, and sp_BlitzQueryStore modules for my “How I Use …
Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration
I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. In fact, I prefer to use visual resources when possible. On my first contact with Fabric Lakehouse I discovered to convert Files into Tables I need to use a n …
Learning PostgreSQL With Grant: Introducing VACUUM
While there are many features within PostgreSQL that are really similar to those within SQL Server, there are some that are unique. One of these unique features is called VACUUM. In my head, I compare this with the tempdb in SQL Server. Not because the …
Database Monitoring for Developers
The post Database Monitoring for Developers appeared first on SQLServerCentral.
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 …