Cache SQL Server Data in a .NET Web Application
The post Cache SQL Server Data in a .NET Web Application appeared first on SQLServerCentral.
Common Table Expression Basics
Introduction Firstly, we need to understand what is a common table expression. Common table expressions, also abbreviated as CTE, are virtual tables which are formed by collecting and formatting data from one or multiple source table(s). These virtual …
The Journey to Team-based Development with Flyway
The post The Journey to Team-based Development with Flyway appeared first on SQLServerCentral.
REPLACE versus TRANSLATE for SQL Server Text Data Manipulation
The post REPLACE versus TRANSLATE for SQL Server Text Data Manipulation appeared first on SQLServerCentral.
PostgreSQL Basics: A Template for Managing Database Privileges
In the first two articles of this series about PostgreSQL privileges, we reviewed how to create roles, grant them privileges to database objects, and how object ownership is an important aspect in managing access and control within the database. When i …
[Video] Office Hours: Professional Development & Training Questions
A lot of today’s questions from https://pollgab.com/room/brento have a common theme, but it’s just a coincidence: Here’s what we covered: 00:00 Start 07:40 Maciej: Hi Brent, when you are working on the course/training how do you know …
[Video] Office Hours: 45 Minutes of SQL Server Q&A
It’s a long one, folks! I went through almost 30 of your questions from https://pollgab.com/room/brento to get your learn on: Here’s what we covered: 00:00 Start 00:30 Jr Wannabe DBA: Hi Brent, recently you talked about linters; do y …
Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty
Introduction In today’s rapidly evolving digital landscape, organizations increasingly rely on cloud platforms like Amazon Web Services (AWS) to host and manage their databases. According to a recent Cloud adoption study, 94% of enterprises use cloud s …
It’s Been 6 Months. SQL Server 2022 Still Isn’t Ready Yet.
Six months ago today, Microsoft announced that SQL Server 2022 was ready. Except it wasn’t. And it still isn’t ready. See, look at the very first hero in their list of 2022’s new features: The very first one is “Business continu …
Changing log growth strategy in SQL Server 2022
When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for log file growth, I was excited. When I later learned it only applies to automatic growths, and only those of 64 MB or less, I was a little less excited …
7 ways businesses can improve the quality and speed of database releases
The post 7 ways businesses can improve the quality and speed of database releases appeared first on SQLServerCentral.
How to Improve Database Design to Speed Up SQL Queries
Mistakes in database design can spell long-term issues that jeopardize efficiency and effectiveness. For online transaction processing (OLTP), in which many transactions must be executed concurrently, throughput and speed are key. Good database design …
Star Schema vs Snowflake Schema Considerations
The post Star Schema vs Snowflake Schema Considerations appeared first on SQLServerCentral.
Understanding how to Successfully Sell the Cloud
The post Understanding how to Successfully Sell the Cloud appeared first on SQLServerCentral.
How to Find the SQL Server Instance Startup Time
This article explains the different methods to find the startup time of an SQL Server. We can use any of the following specified methods to find the instance startup time: Create the date of TempDB. The log from Windows event viewer and SQL Server Erro …