Data Oriented Cloud Security Mechanisms
Introduction Cloud Computing escalates the security risks of an organization. This happens because of the extended trust boundary associated with deploying IT assets beyond the data centers of the asset owners. The trust boundary exposes organizations …
Three Use Case Examples for SQL Subqueries
The post Three Use Case Examples for SQL Subqueries appeared first on SQLServerCentral.
[Video] Office Hours: Ask Me Anything About Azure SQL DB & MSSQL
Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me answer. Here’s what we discussed today: 00:00 Start 01:40 prasad: Hi Brent, I want to become a full fledged database architect. I have been read …
SQL ConstantCare® Population Report: Spring 2023
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates? Let’s find out in the spring 2023 version of our SQL ConstantCare® population report. Out of 3,002 …
How to secure legacy ASP.NET MVC against Cross-Site(CSRF) Attacks
Cross-Site Request Forgery (CSRF) attacks are widespread, and even some BigTech companies suffer from them. Netflix suffered in 2006 with CSRF vulnerabilities. Attackers could change login credentials, change the shipping address and send DVDs to a new …
PASS Data Community Summit registrations are open!
The post PASS Data Community Summit registrations are open! appeared first on SQLServerCentral.
WIT Engagement Survey For Female Speakers
The post WIT Engagement Survey For Female Speakers appeared first on SQLServerCentral.
Announcing Live Office Hours on Wednesdays & Thursdays
It’s time for summer school! I’m doing live streaming on my Twitch channel on Wednesdays & Thursdays this summer, and the recordings will go live later on my YouTube channel. I’ll take questions from PollGab, do live coding, work …
PostgreSQL Schema: Learning PostgreSQL with Grant
An important aspect of building and managing a database is organizing the objects within your database. You may have tables that support different functions, for example, a schema for warehousing operations and another for sales. Some logins may need a …
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers
A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part of this series, we spoke about MySQL Replication, the different types, replication formats, benefits, and downsides, as well as a brief introduction …
Enhancing SSIS ETL Tools with SolarWinds Task Factory
The post Enhancing SSIS ETL Tools with SolarWinds Task Factory appeared first on SQLServerCentral.
How to work with ChatGPT in Visual Studio Code
ChatGPT in Visual Studio Code In this article, we will play with a ChatGPT extension for Visual Studio Code to create code. We will play with the T-SQL code and show what this extension can do. If you are not familiar with ChatGPT, you can check our pr …
Ordered Columnstore Indexes in SQL Server 2022
Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches
The post Democratizing Self Service Cloud Analytics and ELT Supporting Modern Cloud Data Management Approaches appeared first on SQLServerCentral.
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary cost …