From the blog

Articles from our expert staff on a wide range of topics

Use randomized data to increase a test data set

Recently I was tasked with evaluating several possible solutions for a SQL Server search engine to search a database of students. For a proof of concept, I had a small snapshot of approximately 200,000 students. I needed to expand this data to simulate a much larger...

Oracle EXCEPT expression? Try MINUS

Recently while trying to get in some extra practice using set operators (EXCEPT, INTERSECT & UNION) and querying data with Toad for Oracle; I came to a shocking realization. There is no EXCEPT expression in Oracle! If you are not familiar, the EXCEPT operator in...

SQL Shrink Database… hung up or just slow?

Ah, SQL database maintenance… always so much fun! Well, for DBAs, anyway. I can’t speak for DBAs, but I know that one of my pet peeves as a System Administrator has been the lack of progress bars on SQL. Especially with commands such as Shrink Database....