Check your SQL Agent history settings before it’s too late!
A little while back I was doing some research into a failed job and ran into a slight problem. The...
2014-02-10
883 reads
A little while back I was doing some research into a failed job and ran into a slight problem. The...
2014-02-10
883 reads
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right?...
2014-02-03 (first published: 2014-01-27)
2,162 reads
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...
2014-02-02
1,350 reads
I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I...
2014-01-29
887 reads
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...
2014-01-23 (first published: 2014-01-20)
3,282 reads
While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in...
2014-01-22
1,074 reads
I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary key?...
2014-01-20 (first published: 2014-01-13)
4,460 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2014-01-15
894 reads
So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an...
2014-01-13 (first published: 2014-01-06)
6,619 reads
I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...
2014-01-08
1,381 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
How to install mysql-connector-python-8.4.0.zip it does not have setup.py. Checked also: mysql-connector-python-8.4.0.tar.gz
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers