History has its own way to define now civilizations thrived. Most of the cities flourished in the river side and transporting lumber was one of the key activity. Most of the cities like Seattle and many others have this boom and bust life. The idea here was to cut the timber upstream and use the natural flow of rivers to transport to factories downstream using the river. These are classic and wonderful examples of how we typically work with Log-Shipping in SQL Server too. This blog is about Transaction Log Shipping Status report.
SQL SERVER – How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio
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.
Developer’s Life – Every Developer is a Wonder Woman
We have focused a lot lately on this “superhero series.” I love fantasy books and movies, and I feel like there is a lot to be learned from them. As I am writing this series, though, I have noticed that every super hero I write about is a man. So…
Read MoreMySQL – How to Format Date in MySQL with DATE_FORMAT()
MySQL supports formatting the datetime values into a different formats using DATE_FORMAT() function. This function accepts date/datetime values as a first parameter and returns into a specific format defined as a second parameter. Let us explore this with the following examples which are self-explanatory Define a DATETIME variable SET @date:='2014-06-16…
Read More