ACID Rules in Sql Server
ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity states the principle of All...
2011-05-28
4,191 reads
Blog Posts
DML, DDL, DCL, TCL in SQL Server
Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...
2011-05-28
11,724 reads
Restoring a database from higher version to lower version SQL server
AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...
2011-05-28
3,035 reads
Using Views for Faster SQL Query Development
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
845 reads
Re-blog – May 20-26
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-27
833 reads
Search Active Directory (AD) from your desktop
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
685 reads
SQL University Troubleshooting Week: Having a Plan for Every Situation
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
725 reads
Endpoints Need Privileges Too
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,275 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning...
2011-05-26
4 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I...
2011-05-26
585 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Permata Kota Telp:cs.(0821)8171955
Whatsapp:08218171955 Komplek Permata Kota, Jl. Pangeran Tubagus Angke No.170 Blok L Kav 8 &...
BCA KCP Permata Ujung Menteng No.Tlp.083179431643
Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota Jakarta Timur,...
BCA KCP Dupak No.Telp:087757645171
Whatsapp:087757645171 Pertokoan Dupak Megah Jaya, Timur Gg. II III IV Blok B, No. 1,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers