Ms SQL Server

Resource Waits: Lock Waits: waiting for a shared lock on a table - 'LCK_M_S' IO Waits: waiting for a page to be read from disk.   'PAGEIOLATCH_SH' Memory Waits: waiting for a semaphore to be released to access memory   'RESOURCE_SEMAPHORE' Queue Waits: CPU Waits: waiting for another process to complete.  its work - 'CXPACKET' Memory Waits: waiting for an external memory allocation to be released.  'MEMORY_ALLOCATION_EXT' Wait for Tasks: Backup and Restore Waits: waiting for a backup or restore operation to complete - 'BACKUPIO', 'RESTOREIO'   External Waits: Waiting for a CLR or extended stored procedure - 'CLR_AUTO_EVENT', 'EXTENSIBLE_HASH_LOAD' Synchronization Waits: Waiting for a semaphore or a latch - 'LATCH_EX', 'ASYNC_IO_COMPLETION' User Waits: Waiting for user input or action - 'WAITFOR', 'SLEEP' Network Waits: Waiting for network resources or connectivity - 'ASYNC_NETWORK_IO', 'NET_WAITFOR_PACKET

One of the MNC looking for following position Job Title: Product Architect Location : Kerala Trivandrum Primary Skill: C#,.Net,WebApi,jQuery,Java,SQL Year exp : 10+ Years Shoot your CV: sqlfeathers@gmail.com

SQL Feathers: Fatal error during installing SSMS or Vsts https://www.sqlfeathers.com/2021/07/fatal-error-during-installing-ssms-or.html

Multiple positions open for SQL BI (SSAS/SSRS) support Engineer at Microsoft India. Location Bangalore/Hyd Candidates having experience 5-12 years can be referred. Share your resume on mukundbhashkar92@gmail.com

Opportunity with an MNC in Infopark, Cochin We are Looking for Java Backend Developers having 3-8 Years of experience with Java/J2EE. We provide excellent opportunity to grow, learn and upgrade your skill sets by working with an international team Job Location: Kochi,Infopark,Kerala,India Requirement: Total experience of 3-8 Years with Java/JEE out of which at least 1 year in REST APIs using Spring/ Spring boot. Experience on working with RDBMS like MS SQLServer. Experience with GIT or Bitbucket, maven required. Experience with agile development technologies. Excellent analytical and problem solving skills. Able to work independently with minimal supervision and able to take ownership accordingly. Able to write well designed, testable and efficient code. Knowledge about tools like Docker, Bamboo will be an added advantage. Interested candidates please send resume to sqlfeathers@gmail.com

https://t.me/SQLFeathers

https://www.mssqltips.com/sqlservertip/6993/power-bi-email-reports-power-automate-rls/?utm_source=dailynewsletter&utm_medium=email&utm_content=headline&utm_campaign=20211006

https://www.sqlfeathers.com/2014/04/rownumber-rank-denserank-ntile-in-sql.html?m=1

https://www.sqlfeathers.com/2021/07/fatal-error-during-installing-ssms-or.html?m=0

1.DevOps Architect 2.DevOps - Senior Engineer 3.DevOps Engineer 4.DevOps Infrastructure Senior Engineer 5.Linux Platform Architect 6.Android Application Lead 7.ADAS Architect 8.Infotainment Software Lead for Kanzi 9.Infotainment System Platform Architect 10.Python MicroServices Engineer/Lead 11.QT c++/QML 12.ML Engineer 13.Data Architect 14.Java Full Stack / Core Java 15.UI Technologies-Angular / Reacts 16.Cloud Technologies 17.C#.Net/WPF 18.C++ (Windows / Linux) 19.Infotainment Test Engineer (Automotive) 20.NET Full Stack 21.Technical Architect - Python Full Stack (Power Domain) 22..NET Core 23.Data Engineer 24.Data Architect - Hadoop, Cloud Native & NoSQL experience 25.Tech Lead - Data engineering Tableau 26.Senior Data Engineer Opening in one of the MNC in Kerala if anybody looking for job change share your CV to sqlfeathers@gmail.com,please mention job titile in header.

https://www.sqlfeathers.com/2020/04/finding-blockinglocking-queries-in-sql.html?m=1

https://www.sqlfeathers.com/2018/05/sql-query-optimization-tips.html?m=1

https://www.sqlfeathers.com/2021/04/reduce-null-value-space-in-sql-server.html?m=1

https://www.sqlfeathers.com/2021/02/what-are-basic-data-types.html?m=1

https://www.sqlfeathers.com/2020/11/sql-data-base-in-restoring-mode-after.html?m=1

https://www.sqlfeathers.com/2020/11/how-to-get-next-business-day-after.html?m=1

https://www.sqlfeathers.com/2020/11/different-query-method-in-sql-server.html?m=1

SQL Feathers: Find the SQL server Version https://www.sqlfeathers.com/2020/10/find-sql-server-version.html?m=1

Hi All, Excellent opportunity for MS SQlDBA(3--8years) Hyderabad location Client : Mindtree Mode : Permanent position with Mindtree Exp – 3 to 8 yrs Notice – 0 to 30 days Work location - Hyderabad Interview Date :23-August-20(sunday) Interview mode:webex Discussion Please find the detailed Job Description - SQL DBA The person in this position will work in a team environment to support Customers using MS SQL Server. · 3-8 years of Microsoft SQL Server Database Administration experience in SQL Server 2008R2/2008/2012/2014/2016. · Installed SQL Server 2005/2008/2008R2/2012/2014/2016/2017 on new 32-bit and x64-bit Operating System. · Experience in Migrating from SQL Server 2008 to SQL Server 2012 and from SQL Server 2012 to SQL Server 2014/2016. · Experience in upgrading SQL server software to new versions and applying service packs and patches. · Proficient with SQL Management Studio, Enterprise Manager, Query Analyzer, rescheduling jobs with SQL Server. · Creating DB Maintenance plans, rebuild/reorganize indexes & performing integrity checks. · Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans. · Experience with High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering. · Proficient in implementing different types of Replication models like Snapshot, Transactional and Merge. · Experience in Implementing Always On in SQL Server 2012, 2014, 2016 and 2017. · Experience in Implementing Database Mirroring in SQL server 2005/2008/2008R2. · Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008R2 and SQL Server 2012 in Active/Passive. · Auditing database configuration and security configurations. · Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler, Database Engine Tuning Advisor, Windows performance monitor, DMVs, Resource Governor, Data collection Reports, crystal reports, DBCC and Custom Script, Built-in performance Report and Activity Monitor. · Experience with Database Backup and Restore. Key success factors include: Customer management and teaming skills, supporting customers on phone and written correspondence regarding technical questions and issues Logical and Critical thinking skills Deep technical and troubleshooting skills Passion for technology and learni Communicate efficiently both written and verbally with wide variety of the customers Subject of mail" Ms SQl Dba "Hyderabad If you know of people who would be a good fit and intersted please ask them to reach out to sveta@primusglobal.com

https://www.sqlfeathers.com/2020/08/where-are-temp-table-and-table-variable.html?m=1