I am used to exploring what is available in the technology of love – SQL Server. As I was exploring into one of the simplest set of DMVs which have been available for ages. There are several ways to get the OS information inside SQL Server. One of the ways is to use the DMV as shown below.
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
I have started blogging on my site long ago and my whole idea was to make script repository so that others can reuse it. Now when I look back, there are many scripts and many solutions which I have written. Personally, I have used many of them. Today I am sharing another script which I have used with one of my clients and it was very useful for me in troubleshooting a strange TempDB log file issue. Let us learn about Monitoring TempDB Space Usage.
SQL SERVER – SSMS Tip – Using Drag and Drop Capability
SQL Server Management Studio is an interesting tool. The more you work, the more you discover tricks from it. It doesn’t come as a surprise to how I get to know something new whenever I talk with someone. People have figured out new ways to work with SSMS. In this blog, let me talk about something interesting that has been with SSMS for ages but lesser known. Let us see today a time about SSMS related to Drag and Drop Capability.
SQL SERVER – Why Does Encrypted Column Show NULL on Subscriber?
While I was online on Skype last night, one of my old customers pinged me and wanted to know my opinion of a special issue which he was facing when Encrypted Column Show NULL on Subscriber.
Oracle to SQL SERVER Migration – Triggers Used While Migration
I am a big supporter of working on something that I get used. This is a trend I see that most of us are used to. When was the last time you switched loyalty from one phone to another? I know most of us have multiple devices that we use, but rarely that I have seen switch from an Android to iPhone to Windows to other devices. These are second to human nature. In the past 3+ years, I have been a big-time user from using Android phones. The model that I pick up depends on the price, hardware specification, specific features of my like and more. Let us learn about Oracle to SQL migration.
SQL SERVER 2016 – Trace Flag 1117 is Discontinued. Use the Options Provided with ALTER DATABASE
While doing performance tuning for one of my clients, I was looking at ERRORLOG files to understand about their system. I saw that trace flag 1117 and 1118 are enabled via startup parameter.
SQL SERVER – FIX – Error – Msg 4928, Level 16, State 1. Cannot Alter Column Because it is ‘Enabled for Replication or Change Data Capture’
One of my Facebook followers sent me an interesting situation, where he faced error related replication or change data capture.