Category Archives: Uncategorized

Back to basics: a New browser with a familiar feel.

Over 15 years have passed, and here it goes again: a new browsing experience hits me! It is fun how something that is now so┬átrivial can still surprise you. I am browsing all day, be it to perform work,┬ásearch things, … Continue reading

Posted in Uncategorized, Windows | Tagged , , , | Leave a comment

Some SQL Server performance goodies

Hi folks. It’s been a long time, but Databases Never Die (this could be a movie name, don’t you think?). Below are a few performance articles to think about performance. First one is SQL on Windows vs. SQL on Linux. … Continue reading

Posted in Uncategorized | Leave a comment

Get all job steps in SQL Server

Originally posted on Sufian's Diary:
Someday you might need to see the steps of any specific job or find in which step of which job does a specific query is used. Confused! Following query will show you all the…

Posted in Uncategorized | Leave a comment

New year, new post, new MongoDB

Everytime I think of MongoDB I remember Sheldon Cooper playing Bongo on TBBT tv series. Just for fun, because of the sound of the words. But to start a new year nothing better than a new DB system. Please take … Continue reading

Posted in Uncategorized | Leave a comment

2014 in review

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. (They did not have much work, only 18 posts this year. Gotta increase that number.) Here's an excerpt: The Louvre Museum has 8.5 million visitors per year. … Continue reading

Posted in Uncategorized | Leave a comment

SQL Server: Service Packs and Database Mirroring

Usually the Mirroring feature of SQL Server is pretty resilient to random failures at several parts of the link between the two servers. It is so resilient because it uses only built-in features that are not affected by the outside … Continue reading

Posted in Uncategorized | Leave a comment

Free Microsoft exams: get your voucher now!

I was not able to check if there is some exam for SQL Server, but this can help someone anyway. http://vouchers.cloudapp.net/mcp/default.aspx Quick recap of conditions: Offer good until December 31, 2014 for up to a total of 10,000 vouchers distributed … Continue reading

Posted in Uncategorized | Leave a comment

Enable / Disable Users (not Logins) in SQL Server

Originally posted on Jim Humphries:
A DBA friend of mine came across a strange problem the other day. He discovered that one of the users in a SQL server database was disabled, thats a database user not a server login.…

Posted in Uncategorized | Leave a comment

MS SQL: Find total server disk space in T-SQL

Hello. Quick post today. I needed to find the total disk space for a remote server with access only to T-SQL. No PowerShell or file system sneak-peek was allowed. Actually I would send my queries to someone else run it, … Continue reading

Posted in Uncategorized | 2 Comments

Windows 2012 deduplication – turning it off (completely) and recovering your space!

Originally posted on HayesJupe's Blog:
A while back i wrote a post about data deduplication in 2012…. generally a very good feature, but as that specific post talked about, there was a collection of .iso and compressed data that…

Posted in Uncategorized | Leave a comment