[Video] Office Hours Speed Round: 21 Answers in 15 Minutes
HONK HONK! It’s time for a fast round of answers to concise questions y’all posted and upvoted at https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:19 TheyBlameMe: Hi Brent. What is your view on using Dacpac diff …
Office Hours Speed Round, Easy Text Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento have easy one-line answers. Let’s knock ’em out: George: Hi Brent, what recently has been the most challenging/surprising/new-to-you performance issue you have encoun …
SQL Prompt Safety Net Features for SSMS: SQL History
The post SQL Prompt Safety Net Features for SSMS: SQL History appeared first on SQLServerCentral.
Create an Empty Database Using SQL Server Integration Services
Recently, we were working on a small project. The requirement was to create an empty copy of an existing database, meaning the new database could contain only database objects without data. The database was smaller and less complicated, so we completed …
Use DDL Triggers to Automatically Keep SQL Server Views in Sync
The post Use DDL Triggers to Automatically Keep SQL Server Views in Sync appeared first on SQLServerCentral.
Finding and Tuning Expensive Stored Procedures using SQL Monitor
The post Finding and Tuning Expensive Stored Procedures using SQL Monitor appeared first on SQLServerCentral.
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 …