[Note from Pinal]: This is a 61st episode of Notes from the Field series. One of the common question I receive every other day is – I have learned BI but I feel that there is no automation in the BI field, what should I do? How do I go beyond learning…
Read MoreSQL SERVER – Finding Tables Created Last Week – DBA Tip
My conversations with my DBA friends are always interesting. They have unique ways to solve problems and organizations take them for granted. Most of the DBA’s want to be in control of their environment. There is no second thought on it when it comes to delivery from their side. In…
Read MoreSQL SERVER – Filter In-Memory OLTP Tables in SSMS
Earlier I had written a blog about SQL SERVER – Beginning In-Memory OLTP with Sample Example which covers the basics of working with In-Memory OLTP. Though that post gets you started, one of my colleague asked me if there was an easier way to identify In-Memory Tables when working with SQL…
Read MoreInterview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name
Two years ago I wrote a book SQL Server Interview Questions and Answers with my very close friend Vinod Kumar. It is a very popular book of mine and has sold many thousands of copies so far. Every single day I still get quite a many different interview questions in…
Read MoreSQL SERVER – UNION With TEXT DataType Returns Error but and UNION ALL Works – Reasons
Earlier I demonstrated a very interesting behavior in my blog post – UNION and UNION ALL with TEXT DataType – Observation, where we see that UNION clause with TEXT datatype returns Error but with UNION ALL it does not return an error. I did not know that earlier before I posted that blog…
Read MoreSQL SERVER – Year 2014 Reflections by Tim Radney – Notes from the Field #060
[Notes from Pinal]: New Year’s Resolutions is a funny word. Everybody makes it on January 1st but breaks it in very few days. I used to make resolutions too, but for a while, I have stopped this practice. Tim Radney is my great friend and I asked him that what…
Read MoreDeveloper’s Life – You Don’t Need a New Year to Change
Today is a special day – a new year which will define the year 2015. I request my close friend Vinod Kumar, who is SQL Server Expert and thought leader to write a blog post on this first day of the year. I asked Vinod – “What one should change in this year to progress in life?“. If you know Vinod, he is a very positive person and inspiring personality. He immediately responded that – “One does not need a new year to change”. I asked him to elaborate on this subject and our conversation turned out to be an amazing blog post.



