This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article.
SQL SERVER – Andy Defines Basic RDBMS: Isolation in Processes – Notes from the Field #038
[Note from Pinal]: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. This note is from Andy and as we all know he is amazing person when we have to understand the fundamentals. He…
Read More
SQL Authority News – Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching
In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. This comes in addition to various in-memory technologies outside of the SQL Server world, such as…
Read MoreSQL SERVER – Finding Object Dependencies in SSMS – SQL in Sixty Seconds #071
While we are doing development, we create and drop objects. We build new things and we need to understand the relationships between database objects when we are doing various activities in SQL Server. Well, it is indeed very hard to know all, the relationship between various objects in SQL Server.…
Read MoreSQL SERVER – Free Entry to SQLPASS 2014 is Possible
The other day, I received an email from Dell and I was extremely delighted to read it. It contained details how one can go for FREE to SQLPASS. What is SQLPASS? The three-day event will be marked by a lot of learning, sharing, and networking, which will help me increase both my knowledge…
Read More
SQL SERVER – SSMS: Activity – All Blocking Transactions
Working out of India has its own challenges and I enjoy here despite these challenges thrown at me. One of the biggest advantage I have working with Pluralsight is, I can still get my job done by working-from-home occasionally. And this is one of the perks I wish most of…
Read More
SQL SERVER – Activity Reports – Dormant Sessions
With schools starting for my daughter, I rarely get involved in her daily routine activity. But there is one thing that I don’t try to miss – the parents-teachers meet. Sometimes it is not about the report card on how my daughter faired against the rest in the class but it is more than that. I am curious to understand how she behaves in the class, how she makes friends in class, how her extra-curricular activities are, is she disciplined overall etc. Those are key attributes and traits I am looking at getting as feedback from the teachers in that hour of interactions. Let us learn about Dormant Sessions in this blog post.