SQL Server

Administration Amazon AWS Amazon RDS Azure Azure SQL Database Development Editorials SQL Server

Debugging Multi-Cloud Performance

We’ve been chasing issues with performance across a series of applications where there are multiple cloud providers (specifically AWS and Azure) in play. The application is a fairly typical .net web-based application that does calls to Azure SQL DB and AWS RDS at various times and places. The issue we’ll see from time to time surrounds lag time between the...

This content is for Pro Member, Pro, Standard Member, Standard, Free, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Part II: Overview of B- Tree and B+ Tree

Introduction to B+ Tree The drawback of the B tree used for indexing is that it stores a data pointer (a pointer to a block of a disk file with a key value) that matches a given key value, along with that key value in the B tree node. This technique significantly reduces the number of entries that can be...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Is it undermining or rude to email the boss to ask him to get his act together?

  A busy professional asked me this question:   Is it undermining or rude to email the boss to ask him to get his act together after 1am? This is one of the reasons- undermining management, the HR dismissed me for gross misconduct. I was a chef and finished very late every night.   I would not do it. It’s...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

PART I: Overview of B- Tree and B+ Tree

Introduction to B- Tree To implement dynamic multi-layer indexing, the B tree as well as the B + tree are often used.  B-Tree is a balanced research tree. Most other auto-matched search trees (such as AVL as well as red-black trees) assume that everything is in main memory. To understas well as the use of B-trees, we have to think...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Single Biggest Mistake You Are Making With Your Resume

You feel you’ve done a great job on your resume. Your career summary is modern, defines you as a professional, and covers those areas most relevant to your career level and job target. Your visual presentation and organization are fresh and just the right length.  You’re going in the right direction but you’re not done.  The key component to compel the...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2019 Profiler Optimization Tips

SQL Server 2019 Profiler Optimization Tips SQL Server 2019 Profiler is a graphical user interface for monitoring an instance of the Database Engine or Analysis Services. SQL Server Profiler allows to capture and save data about each event to a file or table to analyze later. In this article, you can find some helpful tips to performance tune and optimize...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Indexing

Indexing is used to optimize database performance by minimizing the number of disk access required when processing queries. An index is a kind of data structure. Used to quickly find as well as access data in a database table. Index structure Indexes can be created using some database columns. The first column of the database is a search key that...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

What if a new co-worker lied about me at a previous job?

I received this question from a busy professional: What should I do when I found out that the new co-worker was the one who lied to my boss that made me quit my job of 18 years? I realize that I do not understand the full background. But I would like to point out that you (and only you) can...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using jobs in SQL Server 2019

Tips for using jobs in SQL Server 2019 Consider using a centralized job server if you need to manage a large number of SQL Server jobs. Managing a large number of SQL Server jobs across a large enterprise environment can be very difficult. Centralized job server makes management easier by limiting the number of places you have to look to...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Hashing

In a huge database structure, it is very inefficient to search all index values ​​as well as obtain the desired data. The hashing technique is used to calculate the direct location of data records on disk without using an index structure. In this technique, data is stored in data blocks whose address is generated using the hash function. The memory...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register