Why Do Apps Perform So Slow?

 This presentation is for technical managers, directors, executives. Hence, please share the link with your colleagues. This presentation is not really for DBA's, however, if you are a DBA and you want to watch then by all means go ahead. Thank you for your support. 

 CORRECTION: article on nolock hints was written by Priyanka Chauhan. Though Erin Stellato has written articles on this topic as well. Shout out to Priyanka Chauhan for the article. 

 https://ola.hallengren.com/ https://www.brentozar.com/responder/https://www.brentozar.com/training/ https://tsql.lucient.com/ https://www.sqlskills.com/sql-server-... https://www.littlekendra.com/2018/02/...https://www.littlekendra.com/course/r... https://www.sqlservercentral.com/arti... https://www.experts-exchange.com/arti... https://retool.com/blog/isolation-lev... https://blog.sqlauthority.com/2007/12... https://www.brentozar.com/archive/201...https://www.brentozar.com/archive/201... https://bertwagner.com/author/bert-wa... https://docs.microsoft.com/en-us/sql/... https://www.brentozar.com/archive/201...https://www.brentozar.com/training/th...https://www.brentozar.com/training/st... https://www.sqlshack.com/cardinality-... https://www.sqlservercentral.com/blog... https://www.erikdarlingdata.com/sql-s... https://www.erikdarlingdata.com/sql-s... https://blog.quest.com/demystifying-c... https://en.wikipedia.org/wiki/Isolati... https://weblogs.sqlteam.com/dang/2007... https://www.sqlshack.com/sql-server-b... #SQL #SQLserver #DBA #data #databases #microsoft #sqlserverdba #databases #sqldba #databaseadministration #sqldeveloper #sqlserverdeveloper #suppportyoursqlservergurus

Comments

Post a Comment

Popular posts from this blog

Teaching Computers to Play Tic Tac Toe: A Reinforcement Learning Approach

Image
 You can see the full code on GitHub: https://github.com/SQLNoggin/Smart-TicTacToe-RL_NaomiA.git This Python script implements a reinforcement learning agent to play the game of Tic Tac Toe. The agent is trained through Q-learning, a type of model-free reinforcement learning that uses a Q-table to estimate the value of taking specific actions in particular states. Let's break down the key aspects:   Overview The script uses the Tkinter library to create a graphical user interface (GUI) where the Tic Tac Toe game can be played. NumPy is used for numerical operations, and the pickle library is used to save and load the Q-table to/from a file. Constant and Hyperparameter Definitions PLAYER_X and PLAYER_O : Constants representing the two players (1 for X and -1 for O). EMPTY : Constant representing an empty cell on the Tic Tac Toe board. ALPHA : The learning rate used in the Q-learning updates. GAMMA : The discount factor used in the Q-learning updates. EPSILON_START, EPSILON_END,...
Read more

Run Queries in SQL Server Using Python!

Image
By Naomi A. This is a fairly quick one - all of the info needed on how the script works is in the comments! The full script is ready for download on GitHub: (LINK) # Import the pyodbc module. #This module allows Python to connect to an ODBC database, like SQL Server. import pyodbc # The variables hold the server name, database name, username, and password. # This is necessary in order to connect to the SQL Server database. server = 'ServerName' database = 'DBName' username = 'user' password = 'password' # Connection string: # This is a formatted string that the ODBC driver uses to know who is connecting (username and password), # where they are connecting to (server and database), # and what driver they are using to make the connection (ODBC Driver 17 for SQL Server). connection_string = f 'DRIVER= {{ ODBC Driver 17 for SQL Server }} ;SERVER= { server } ;DATABASE= { database } ;UID= { username } ;PWD= { password } ' # DRIVER={{ODBC Dri...
Read more

How to Create a Neural Network for Recognizing Hand-Drawn Shapes

Image
  by Naomi A. In this guide, we will walk through the process of developing a neural network that identifies hand-drawn shapes. The tutorial is broken down into three main sections: Preprocessing the hand-drawn shapes. Training a neural network to recognize these shapes. Creating a simple user interface to predict the drawn shapes.   All code is available on github under the MIT License. (LINK TO REPO)  1. MNIST Maker: Preprocessing Hand-Drawn Shapes Objective : Convert the images of hand-drawn shapes into a standardized format for machine learning. Steps: Load the images from a specified directory. Convert them to grayscale and resize them to 28x28 pixels. Normalize the pixel values. Label the images based on their filenames. Shuffle and split the data for training, validation, and testing.  SCRIPT for creating the MNIST Dataset: import cv2 import numpy as np import os import random # Path to the shapes directory base_folder = r"C:\yourpathgoeshere" shapes...
Read more