[Note from Pinal]: This is a 94th episode of Notes from the FieldĀ series. When I read the title of this article – I was extremely intrigued with it – Rewriting Database History! When I was a kid, history was my favorite subject and till today when I have to deal…
Read MoreSQL SERVER – How to Migrate Existing Database to Contained Databases
Most of the queries that land into my inbox are based on something I have already written or something people want to explore more on. When it comes to learning and exploring the skills, there is no better way compared to people asking me some tough questions. This blog is…
Read MoreSQL SERVER – PowerShell – Knowing SQL Server Information
If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include: Using PowerShell and Native Client to run queries in SQL Server Identify Disk Latency on SQL Server Box Using PowerShell How to Find Logical and Physical…
Read MoreInterview Question of the Week #032 – Best Practices Around FileGroups
Here is another question I just heard during a recent interview in the multinational company. I have observed over 1000s of interview, but this is the first time I have heard this is being discussed and I was very much glad to hear it. I have listed the answer of…
Read MoreSQL SERVER – How to Identify Locked Table in SQL Server?
Here is a quick script which will help users to identify locked tables in the SQL Server. SELECT OBJECT_NAME(p.OBJECT_ID) AS TableName, resource_type, resource_description FROM sys.dm_tran_locks l JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id When you run above script, it will display table name and lock on it. I have written…
Read MoreSQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol
The journey for IT started way back in my college days more than a decade back. It was a booming time and it was exciting to see everyone eyeing the Computer Science stream. Almost every other person in those days always wanted to take this new trend. Riding the waves was one part of excitement, while the other was to be unique in whatever we do. It is easy to get stereotyped with someone and we can never be different from the herd. I always believed in doing the basics right ā this blog project that I started more than 8 years was to bring these basic learnings back. I am glad I have been doing this. Let us learn about Write Ahead Logging.