Quick tip: sp_configure and sys.configurations
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,098 reads
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,098 reads
Replication is one of the more complex of the SQL native “HA/DR” technologies. There are a lot of moving parts....
2012-05-15
1,672 reads
I was working with a group of students on a design brief. The brief was to partially implement a database...
2012-05-10
1,021 reads
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql...
2012-04-30
2,606 reads
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
596 reads
While researching the steps required to service pack SQL Server on an active active cluster I came across a lot...
2012-04-16
903 reads
A while ago I blogged about instant file initialization. A colleague of mine pointed out that there is a small...
2012-04-16
887 reads
The other day I was asked to restore a production database into a development environment and then check the database...
2012-03-21
823 reads
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
In a previous blog post we went through how to build a Docker container...
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
Comments posted to this topic are about the item The Marked Transaction
Comments posted to this topic are about the item What happens when we drop...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers