How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a...
2010-01-31
4,041 reads
Blog Posts
Interview Questions On Sql Server -Part 2
1. What is the difference between the Union and Union All?
1) Union is used to select distinct data from the...
2010-01-31
1,992 reads
Interview Questions on Sql Server -Part 3
1. What are the Sql Joins?Sql Joins are the way to get data from many tables based on some logical...
2010-01-31
1,940 reads
Interview Questions on sql server -Part-1
1. What is the Normalization?Normalization:-Normalization can be defined as the process of organization the data to reduce the redundant table...
2010-01-31
2,179 reads
Professional Association of SQL Server (PASS)
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...
2010-01-31
2,026 reads
Reading in 2009
I saw a blog post from my friend Paul Randal recently in which he recounted the books he’d read in...
2010-01-31
1,765 reads
Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It...
2010-01-31
1,718 reads
Stored Procedure to Get SQL Job Execution Status
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,543 reads
SEO my SQL Server Blog
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,649 reads
Try Catch within an SSIS Script Tasks and Components
Using a Try/Catch/Finally within your Script Components and Script Tasks is just good coding practice. The thing you want to be able to do is push...
2010-01-30
2,590 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU GANG TENGAH TLP/WA 083800209966
Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
PT. Adira Ampah,Telpon/wa 0822-7774-3331
Jl. Pahlawan, Ampah Kota, Kec. Dusun Tengah, Kabupaten Barito Timur, Kalimantan Tengah 73652
PT. Adira Dinamika Multi Finance, Tbk,Telpon/wa 0822-7774-3331
Hub_Cs.Resmi (0814)2201_9055, Jl. Persemaian, Lanjas, Kec. Teweh Tengah, Kabupaten Barito Utara, Kalimantan Tengah 73814
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers