MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,683 reads
Windows 2008 Server : Moving Cluster Quorum Disk to New SAN
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,476 reads
SQL Server: Measuring The Index Fragmentation
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,714 reads
SQL server: Deciphering Wait resource
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
32,168 reads
SQL Server - Index Fragmentation - Understanding Fragmentation
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,318 reads
Caveats of a CONTROL SERVER permission
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,943 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,952 reads
SQL server 2005 Database Mail stopped functioning after installing Service Pack 3
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,250 reads
How do you secure the SQL Server instance after enabling xp_cmdshell ?
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,547 reads
Importing images to SQL server database using T-Sql
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
11,317 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers