As a regular reader, you may know that I now a days work with MySQL and SQL Server both at the same time. Working with two different products have changed quite a few things in how I write code. Here is an example of that – I changed myself about how I CONCAT strings.
Developer – 10 Phrases Developer Use Too Often
If you are working in IT industry, you must encounter software developer around every corner of the office. I am developer myself and pretty much my all friends are developers too. I have created a list of phrases which developer use often. Feel free to add one of yours as a comment as well.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
I work with both the technologies – SQL Server and MySQL and I enjoy working with both of them. In industry you will find few people talking about how one technology is better than other but the reality is that both of them have their greater share. Sometimes when I…
Read More
SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health
One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology…
Read MoreSQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008
[Note from Pinal]: This is a new episode of Notes from the Field series. When SQL Server is slow we think we can improve the performance of the server by just increasing the performance of queries. However, sometimes the queries are already doing good and there is no increase in…
Read More
SQL – A Career in Database Forensics
A growing field in the information security domain – Database Forensics offers a comprehensive and highly sophisticated skill set that allows professionals to uncover and trace data security breaches of the highest order and complexity. Many enterprises are looking to hire such professionals nowadays.
SQL SERVER – Learning More About SQL Wait Stats
I was recently visiting my customer for my day job in Delhi. During the meeting, I had a great time to meet a few of the technical domain experts of the leading organization. We discussed lots of different things while we were there and much of the conversation was surrounding…
Read More
SQL SERVER – What Permissions I have on Database I am Connected to?
Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know…
Read MoreDeveloper – Nine Things Developers Hate to Hear
1. Uh oh… No one likes hearing this – not parents, not repairmen, not developers. They don’t like hearing others say it, and they don’t like hearing it come out of their own mouths. It usually means bugs. 2. Can you fix my computer? This question is the bane of…
Read MoreSQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7
This is the seventh part of a series regarding Redundant Indexes. If you have not read the earlier parts – there is quite a good chance that you will miss the context of this part. I suggest that you should quickly read the earlier four parts. On my production server…
Read More