[Note from Pinal]: This is a 66th episode of Notes from the Field series. Azure Mobile Services is a very critical aspect and not many people know about it. When I read this article, I find it humorous at points and some of the examples also reminded me of my past experience. If you are in data security, you will have a great time reading these notes, but if you are not, you will still love it.
SQL SERVER – How to fix the SQL Server Error 8657 or 8658?
It is sometimes very difficult to troubleshoot error which are relating to memory. In a recent query from one of my customer DBA, he sent me an error message which read like the ones below: Error: 8657, Severity: 17, Could not get the memory grant of %I64d KB because it…
Read MoreSQL SERVER – Script – When/Who did Auto Grow for the Database?
What happens when you try to copy a large file from different hard disks? The operating system tries to see if the destination location has enough space available for the copy to be successful. If we don’t have enough space, then it is second to human nature to make space…
Read MoreSQL SERVER – How Can Deadlock Happen on Same Table?
Interesting TRUE Story As part of learning I get inspiration from the activities we do daily and see how it can be mapped to SQL Server. This in a way many say is an obsession for the subject I love – SQL Server. But I think it is part of…
Read MoreInterview Question of the Week #005 – List All the Tables with Name Containing Specific String
The other day, I received an email from a blog reader. When he appeared for an interview, he was asked to retrieve all the tables where the name of the table contained the words ‘tbls_’. This was a very interesting scenario. As the organization had earlier adopted a specific naming…
Read MoreSQL SERVER – 8 Performance Related Articles on Logical Reads
Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subject of SQL Server Performance. I have really enjoyed writing them and I am very confident…
Read More
SQL SERVER – FIX – Error 3201 – Cannot open backup device. Operating system error 3
This blog is in continuing to use the default values. Earlier this week I wrote a blog which talked about the failure of Create Database Command. Let see in this blog post how we can solve the error 3201.
While working on the reproduction of the issue, I changed the parameters and later realized that the backup database command was also failing. If you rely on the default values for folders that don’t exist, this will raise an error message as shown below.
Developer – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 3 of 3)
I am very fortunate that I know John Sonmez in person. He is one of those individuals who understands the young mind of developers and depth of software development industry. I am a regular follower of his books, videos and ideas. I have personally implemented many of his ideas in my…
Read MoreSQL SERVER – The Basics of the SSIS Script Task – Notes from the Field #065
[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…
Read MoreDeveloper – 3 Tips Every SQL Expert Needs to Know to Land the Perfect Job (Part 2 of 3)
I am very fortunate that I know John Sonmez in person. He is one of those individuals who understands the young mind of developers and depth of software development industry. I am a regular follower of his books, videos and ideas. I have personally implemented many of his ideas in my…
Read More