Spot the Five Differences and Win a Summit Ticket
Spot all five differences in the two images and enter our prize draw competition to be in with a chance of winning a 3-day pass to PASS Data Community Summit 2023. Click here to enter the contest and we hope to see you in Seattle this November. …
[Video] Office Hours: Really Long (and Really Short) Answers
Today’s batch of questions from https://pollgab.com/room/brento requires some really long answers, and some are right to the point. 00:00 Start 02:13 Eh? Aye…: As DBAs, how can we best prepare for the AI world in terms of data? Should we st …
Sessions for Summit 2023 are now LIVE!
The post Sessions for Summit 2023 are now LIVE! appeared first on SQLServerCentral.
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 …