반응형
#주형권#MSSQL#SQL Server#데이터엔지니어#BigQuery#빅쿼리#airflow#MySQL#ETL#gcp#군고구마#데이터#Python#data#aws#databricks#DW#데이터브릭스#SQL Server 2016#PerfMon#빅데이터#데이터웨어하우스#성능#오라클#oracle#와우#Wow#데이터레이크#데이터 엔지니어#big query#Embulk#클러스터링#MSSQLServer#json#backup#백업#데이터 취업#데이터파이프라인#data engineer#Datalake#boto3#Docker#파라미터 스니핑#GCS#bucket#스니핑#nosql#Clustering#Restore#월드오브워크래프트#취업#BI#DBA#Google#데이터 엔지니어 취업#databricks s3 size#databricks s3 space#show tables dropped#databricks drop table#dataengineer#Cloud Build#빅쿼리 운영#BigQuery 운영#CloudTrail#Bigquery 비용#빅쿼리 성능#data pipeline#데이터 파이프라인#mysql to bigquery#데이터분석가#data proc#stackdriver#dataproc#grafana#Superset#RDB#Parameter Sniffing#MSSQL 2014#성능분석#TempDB#DistributedCOM#10010#MSSQL SERVER#teams#SQL Server 2012#Redshift#s3#Traces#교착#Iceberg#HYPERLINK#스케줄러#Athena#insert#crontab#트레이스#partition#sqlserver#파라미터#프로파일러#인덱스#블랑쉬#CSV#Dag#방화벽#SQL#Cluster#클러스터#모니터링#네트워크#삭제#파티션#운영#지도#복원#CPU#하이퍼링크#테스트#windows#network#데이터 취준#테스트 방법#여러 폴더#recursivefilelookup#external table#데이터 취업준비#databricks 운영#optimzie#데이터 관련#data 취업#data engineer 취업#data engineer 업무#databricks log#데이터브릭스 로그#데이터브릭스 성능#excutor#aceess.audit#databricks drop#databricks s3#databricks s3 how#데이터브릭스 s3#databricks dropped#databricks audit#power automate workflow#adaptivecard#databricks connection#databricks dbeaver#데이터브릭스 연결#python teams#teams 메시지#teams workflow#teams webhook#팀즈메시지#데이터개발자#데이터환경#데이터인프라#데이터 환경#데이터 구축#BEGIN END#데이터 경험#데이터 진로#데이터엔지니어 업무#데이터엔지니어 시작#데이터엔지니어 역할#데이터엔지니어 하는일#데이터엔지니어 경력#데이터엔지니어 경험#데이터엔지니어 주니어#data load#iceberg etl#iecberg elt#db to iceberg#awswrangler#AWS 운영#아테나 운영#Athena 운영#Qeury Scan#Query 사용량#athena쿼리 조회#AWS SDK#lookup_events#Your pagination token does not match your request#airflow oracle 연결#get extra#airflow extra#오라클연결#get_extra#슈퍼셋#Provider Service#Windows Management Instrumentation#iceberg insert#iceberg merge#TOO_MANY_OPEN_PARTITIONS#데이터옵스#lakeformaion permissions#list_permissions#svl_s3log#Spectrum Scan Error#Spectrum Scan Error code: 15007#Parquet schema: optional fixed_len_byte_array ddd#Column type: DOUBLE#contab 시간#linux시간#시간파싱#Datapipeline#BigQuery SLA should solve the problem#google.api_core.exceptions.InternalServerError: 500#80324028#채워진 지도#Looker Studio#ERROR: build step 1 "gcr.io/cloud-builders/gsutil#step exited with non-zero status: 1#git sync#DW 설계#데이터웨어하우스 설계#Snowflake Schema#Star Schema#vaccum#composer git sync#Parser terminated before end of string#Unknown token type#encoding=‘utf-8-sig’#BigQeury#No suitable driver found for jdbc:redshift#Could not connect with provided parameters:#Unable to proceed#DataOps#LakeFormation#쿼리 비용#cloudaudit_googleapis_com_data_access_#빅쿼리 인덱스#BigQuery clustering#빅쿼리 클러스터#어생승악#한라산어리목#한라산준비#bq mk#데이터옮기기#BigQuery 스키마#형태 추출#스키마 추출#데이터 parsing#데이터 파싱#JSON_VALUE#JSON_QUERY#${__data.fields[0]}#grafana value link#create absolute link with value#grafana hyperlink#AttributeError:#AttributeError: partially initialized module 'logging' has no attribute 'getLogger'#most likely due to a circular import#데이터 정합성#데이터 체크#건수체크#데이터체크#Bigquery perf#빅쿼리 비용#BigQuery 성능#BigQuery성능#google.api_core.exceptions#BadRequest: 400#INT64. Supported signature: ANY = ANY at#google.api_core.exceptions.BadRequest: 400 No matching signature for operator = for argument types: STRING#datastudio#mssql index#airflow 스케줄#데이터플랫폼#airflow2.0#service.firewalls#service.firewalls().list(project=project)#firewalls#GCP 네트워크#정합성#data studio#데이터 스튜디오#나락살이 영혼사냥꾼#나락살이#그늘사냥개#배부른 그늘사냥개#비전공자 IT#디비버#블랑쉬 위치#죽은블랑쉬#튼튼한 편자#룬 도관#각각다른서신#룬도관#마지막조각#마지막 조각#몹위치#참회의 사냥#ETL 하기#데이터 이관#MsSQL Relpace#airflow 실행#aroura#geojson#cx_oracle#idempotent#Error response from daemon: removal of container#Removal In Progress#docker 삭제#/var/lib/docker/containers#service docker stop#도커 삭제#docker rm -f#<HTTPStatus.OK: 200>#'Expected one of'#'Request failed with status code'#Google cloud storage#cpu high airflow#airflow 성능#airflow cpu on high#mysql csv 내려받기#mysql to csv#mysql to bigqeury#Json Parsing#Jinja#그라파나#1.3.17#1.3.15#or old ones used instead#Some index files failed to download. They have been ignored#스케일 아웃#에어플로우#성능모니터링#list_metric_descriptors#list_time_series#ms teams#멱등#멱등성#팀즈#Cannot allocate memory#failed; error='Cannot allocate memory'#errno=12#DBeaver#slack_webhook_url#slack channel id#task_instance#airflow 모니터링#not all arguments converted during string formatting#AWS MONITORING#AWS mon#cloud watch#partitioned#The server time zone value 'KST'#The server time zone value 'KST' is unrecognized or represents more than one time zone.#serverTimezone#embulk Error#SQLAlchemy#이티엘#ETL tool#엠벌크#csv export#s3 bucket#데이터셋#docker rm#http://dl.embulk.org/embulk-latest.jar#Invoke-WebRequest#read-only#The MySQL server is running with the --read-only option so it cannot execute this statement#Error Code: 1290#버킷 삭제#S##large bucket#remove bucket#Elastic File System#와우탈것#mssql email#sp_send_dbmail#줄 38#상태 1#수준 16#메시지 402#body_format#kubernetes#subnet marsk#Scale Out#지도데이터#SQL 2016#파티션 Truncate#Partition Truncate#Geography#google cloud platform#gloud#webhook#데이터처리#OracleXETNSListener#The Network Adapter could not establish the connection#Oracle Listener#Python3#cannot open shared object file: No such file or directory#error while loading shared libraries: libaio.so.1:#error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory#시스템테이블 설치#libaio#자동 삭제#AlwayON#Alwayson Automatic synchronization Login#40코어#License Core#Core Limitaion#jupyter#모니터링시스템#MSSQL 2012#복합인덱스#사용자 정의함수#데이터스튜디오#Oracle SELECT statement not working#table or view does not exist#ORA-00942#상시암호화#Always Encrypted#행수준 보안#Row Level Security#동적 데이터 마스킹#Dynamic Data Masking#2016 신 기술#MSSQL2016#MSSQL 2016#Poinr-to table#Temporal Table#템포랄#핸드세이크#오라클 계정#패드워드#오라클 패스워드#ORA-28002#Job 스케줄러#추적 플래그#시작옵션#/f#/c#TempDB 오류#T4022#T3608#17204#5123#dm_exec_sql_text#dm_exec_connections#sysprocesses#STOPAT#auto failover#페일오버#자동 페일오버#Cluseting#조건자 없음#조인 조건자 없음#NL Join#STATISTICS_ONLY#WITH STATISTICS_ONLY#DBCC AUTOPILOT#인덱스 가상화#가상 인덱스#Hypothetical Indexes#가상 디스크 서비스#VDS Dynamic Provider#.Trc#backup fail#로그온 실패: 알 수 없는 사용자 이름이거나 암호가 틀립니다#백업실패#18204#3041#sys.traces#sp_trace_setstatus#DBCC CEHCKDB#VERIFYONLY#RESTORE VERIFYONLY#RestartManager#Check for previous errors. The data is invalid.#FRunCommunicationsManager#시작 불가능#시작 안됌#SQL Server 재시작#Initialization failed with an infrastructure error#17182#17120#17826#7024#1069#System I/O#System Memory#Buffer Pool#SQL Serverf#Page Splits#Full Scans#Forwarded Records#SQL Server Perfmon Counter#OPIMIZE FOR#WITH RECOMPILE#Log 관리#perfmon 데이터 관리#backup 삭제#bak 삭제#delete_file#백업삭제#xp_delete_file#create tablespace#스페이스 삭제#테이블스페이스 삭제#테이블 스페이스#파일 자동삭제#폴파일#forfile#인메모리 시스템#SQL 2014#Hekaton#하케톤#헤카튼#OLPT#SELECT LOCK#X LOCK#MSSQL 튜닝#DB저장#성능수집#perfmon counter#카운터 저장#퍼프몬#비동기업데이트#AUTO_UPDATE_STATISTICS_ASYNC#DBCCSHRINKDATABASE#DBCCSHRINK#쉐링크#쉬링크#강제 매개변수#PARAMETERIZATION#CPU 제한#Resoure Manager#리소스 매니저#Relpace#DEALLOCATE#@@FETCH_STATUS#와일#whlie#Cusor#fn_trace_getinfo#자동증가 확인#테이블 Copy#Table Copy#MSSQL 복사#락 페이지 인 메모리#LPIM#Lock Pages in Memory#MS SQL 설치#DB 세팅#DB설치#DB설정#MSSQL 설정#SQL 설정#trivial plan#주형권mssql#CacheHitRatio#BufferCacheHitRatio#BufferManager#DB체크#CHECKDB#인덱스 리빌딩#통계업데이트#데브#데이터 분석가#리빌딩#sysprocess#RE_NAME#952#952ERROR#그룹백업#파일그룹#filegroupbackup#filegorup#동적관리뷰#RESTOREINSERT#결과넣기#주형권.SQLSERVER#EventLog#6008#TermDD#8021#EventID: 8032#ql2300#Application Error#EventID: 1000#EventID: 1030#1030#EventID: 9954#9954#EventID: 51#10009#MRxSmb#8003#Application Hang#Buffer Manager/#CSV파일 합치기#SHOW GRANTS#SHOW SLAVE STATUS#FLUSH PRIVILEGES;#유저등록#백업 스케줄러#System Database#DKNF#래디스#성능 카운터#sspi#17806#json 파싱#rds#작업 스케줄러#오라클 테이블#netfx3#비전공자#GroupPolicy#레디스#한라산 등산#Buffer Cache hit Ratio#한라산 설경#아이스버그#1100#설치 오류#bitnami#데이터분석#GCE#분산처리#재해 복구#몽고DB#성능저하#수도권지하철#컬럼순서#DBCC#서브넷팅#도관#checksum#적재#AlwaysOn#failover#colum#Redis#NET Framework#인증서 오류#인메모리#In-Memory#버킷#RTRIM#LTRIM#중복체크#퀀텀#automatic#1002#하이퍼스레딩#EXECUTE#schema#카산드라#parsing#교착상태#자동삭제#암호변경#어리목#파일백업#trouble shooting#가용성#workflow#New Features#Mongo#옵티마이저#취업 준비#Slack#cassandra#몽고#apt-get update#Composer#Monitoring#파싱#지역변수#서브넷 마스크#서브넷#subnet#테이블 복사#싱글모드#1100도로#매개변수#Databases#Pipeline#DataSet#NET Framework 3.5#subnetting#efs#Firewall#스케줄#I/O#파이프라인#정규화#비동기#공백제거#자동증가#넣기#browser#truncate#tnsnames#drop tablespace#Optimizer#tablespace#OLAP#404#합치기#UDF#손실#ODBC#인스턴스#TermServDevices#1114#Service Control Manager#replace#timezone#Profiler#SSL#쿼리#select into#데드락#탈것#등산준비#ip추적#LISTENER#DEADLOCK#제한#등록#시간표#쓰레드#가상#트랜잭션#변수#항목#인식#dbms#timestamp#실행#점검#커서#동기화#연결#메시지 전송#Import#튜닝#통합#설경#한라산#비용#위치#경로#스크립트#insert into#query#추출#클라우드#작업#복구#PostgreSQL#HTML#퀘스트#지하철#함수#error#데이터 복구#오류#체크#IT·컴퓨터#게임#통계#지표#관리#bulk#phase#NL#shrink#Index#select#Disk#Manager#Memory#Log#50#db#temporal#DMV#logging#Worker#NULL#external#Lock#trace#Bat#Synchronization#WMI#Database#Kill#1000#129#Task#job#server#elt#git#security#Syntax#DROP#RAID#Maria#Fact#File#51#2.0#F#Multiple#service#C#test
반응형