Discussing Security with Boris Hristov on SQLHangout #29
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
521 reads
Over the years I’ve done a number of posts on various aspects of security. In fact the first thing I...
2015-01-12
521 reads
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...
2015-01-08 (first published: 2015-01-05)
6,249 reads
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...
2015-01-07
1,278 reads
I work for a large organization that over the last few years has been doing a LOT of reorgs. And...
2014-12-31 (first published: 2014-12-29)
5,859 reads
The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-12-30
919 reads
So I’ve written my second article for SQL Shack. This time instead of an overview of auditing options in sql...
2014-12-29
1,205 reads
‘Twas 4:45 Friday, and all through the office
not a creature was stirring, not even the bosses.
The code was checked in,...
2014-12-25 (first published: 2014-12-16)
5,351 reads
The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...
2014-12-23 (first published: 2014-12-17)
5,828 reads
This is just something I was curious about. I ran my tests and got an answer and now I thought...
2014-12-15
1,317 reads
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...
2014-12-11
3,379 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