Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Varchar Null
ITMS 구축기 1편 — DB 설계, 테이블 구조와 설계 결정
DB 설계 전 고민 처음에는 테이블 하나로 시작했다. CREATE TABLE server_assets ( id INT AUTO_INCREMENT PRIMARY KEY, ip_address VARCHAR(45) UNIQUE NOT NULL, server_name VARCHAR(100), status VARCHAR(20), ... ); 간단하게 시작했지만, 기능이 늘어나면서 문제가 생겼다. CPU·RAM·디스크 정보를 추가하니 컬럼이 20개가 넘어갔다 SSH 접속 정보를 같은 테이블에 넣으면 수정할 때 서로 영향을 준다 변경 이력을 남기려면 별도 테이블이 필요했다 계정 신청 정보는 서버 1개에 계정 여러 개라 1:N 구조가 필요했다 결국 역할별로 테이블을 분리하는 방향으로 설계를 바꿨다. 현재 ITMS는 총 14개 테이블을 사용한다. 테이블 전체 구조 sqld 개발자 자격증을 공부하며 ERD를 먼저 그리고 DB를 설계할 것이라 다짐했었는데 현실은...
Creating a SQL Stored Procedure to Load a SCD2
Image created using ChatGPT, but everything else in this blog post is all my own imperfections & hallucinations. This is a blog that I am writing for future me and hopefully it’ll help a few of you save some time too! It’s not often that I get to build out a data warehouse from scratch, but when I do, I want to make sure I do it well with best practices in place.
Extracting Practical Observations from Impractical Datasets
[This is a Guest Diary by Curtis Dibble, an ISC intern as part of the SANS.edu BACS [1] program] Figure 1: A heatmap showing the date and frequency a given set of commands input to the honeypot Spoiler alert, sugar costs money, and syntactic sugar is the most expensive type. Fortunately, we live in an era where a developer’s laptop tends to come with resources unheard of in the server realm a decade ago [2] and a vibrant open-source community to make use of all that shiny new silicon.
PowerShell To Get Active Directory Users And Groups into SQL – SQLServerCentral
Where I work, we have a number of applications that use Active Directory and a Single Sign On methodology. Each application has a table with the user's login and mappings to various internal roles, used determine what parts of the application the user can access. Also, except for a handful of applications that need SQL logins, SQL Server access is granted via AD Groups or AD Logins.
Create Table DDL via TSQL – SQLServerCentral
Everyone has noticed this: there's no easy way to get a table's definition via TSQL. You can use sp_helptext for procedures/functions/views, but what do you do when you want the table definition in TSQL? Whether in the middle of a procedure or anywhere in TSQL code, there's no simple utility for a Table's definition. Yeah, there are band-aids and workarounds, but nothing for a simple inline SQL.
Enumerate Windows Group Members – SQLServerCentral
I think the best practice is that, whenever possible, you create an Active Directory group and grant that group permissions in your SQL Server. If you have twenty developers, I like seeing one group , i.e. [mydomain\it-developers] instead of twenty individual logins. Over time however, things sometimes get a little disjointed, and you've added six, seven or more different Windows groups, and are never really sure who is in what group.
Understanding Tinyint Vs Int In Sql Examples
Explore practical examples of using varchar data type in SQL Server, focusing on its application with tinyint and int data types. The framework for autonomous intelligence In SQL Server, the VARCHAR data type is used to store variable-length strings. This flexibility allows for efficient storage, as it only uses as much space as needed for the actual string length, plus two bytes for length information.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Varchar
Contact Varchar, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack