Category Archives: Uncategorized

Azure DW and cloud database alternatives

Quoting a great and concise article from SQLServerCentral: http://www.sqlservercentral.com/articles/Azure+SQL+Data+Warehouse+(ASDW)/172251 It is always good to know the options available when you are considering the best cloud provider for your needs. See below a summary of each option available currently. Azure DWH part … Continue reading

Posted in Uncategorized | Leave a comment

A new global threat: Meltdown and Spectre

Yes, the post title is singular, but there are two threats. It’s a joke, because both are kinda similar. In this day and age, we all should be familiar with the importance of digital security. Almost every year there are … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

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