Nolock vs snapshot isolation
We all experienced blocking one way or the other, in the old days, the only method is wait J
This is...
2017-01-19 (first published: 2017-01-16)
8,336 reads
Blog Posts
Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for the SQL Admin. At the core of the session...
2017-01-19
2 reads
Speaking at PowerShell Virtual Group of PASS
This month I’ll be speaking to the PowerShell Virtual Chapter of PASS. The session is on Linux OS Fundamentals for...
2017-01-19
352 reads
SQL Server - Monitoring Table Size
There are many situations when we want to know the size of our database tables or just need a list...
2017-01-19
692 reads
Webinar: Introducing Minion CheckDB!
Minion CheckDB is available for download as of February 1, 2017! In celebration, we’re having a Minion CheckDB webinar on two...
2017-01-19
832 reads
What is a Database Master Key?
The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...
2017-01-19
16,913 reads
What is COPY_ONLY?
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...
2017-01-19 (first published: 2017-01-16)
2,540 reads
Attending VTUG at Gillette Stadium Tomorrow
If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG)Winter...
2017-01-18
345 reads
Automating DBCC PAGE, part 2 – determining object names on pages
In a prior blog post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option....
2017-01-18
403 reads
Do I have a Database Master Key in a database? #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-01-18 (first published: 2017-01-13)
2,117 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers