Agile Development – A DBA’s Initial Thoughts
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
609 reads
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
609 reads
If we could take a picture of the HA solutions currently offered in SQL Server, database mirroring would be the...
2015-08-27 (first published: 2015-08-18)
2,379 reads
Most database professional recognize they have a good career path, and mostly enjoy the work they do. It’s possible to cross the...
2015-08-11
4,648 reads
If you’ve been a DBA for more than a day, you probably have a pretty good idea of what a...
2015-08-04
5,883 reads
SQL Server has the ability to monitor both server and database level events via the SQL Server Audit feature. Audited...
2015-08-06 (first published: 2015-07-28)
3,441 reads
Your servers are either provisioned or racked, your sys admin has taken care of installing the Failover Clustering feature and...
2015-05-25
473 reads
I recently was involved in a discussion about whether or not to enable the ‘Optimize for Ad Hoc Workloads’ server...
2015-05-19
804 reads
Last week, I took the 70-461: Querying Microsoft SQL Server 2012 exam. I decided recently to try and achieve getting...
2015-05-12
781 reads
The run-time metric gets all the love, and for good reason. It’s easily witnessed by end users and the one...
2015-04-29
1,028 reads
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve...
2015-03-24
699 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...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
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
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