PowerShell is quite an interesting capability that is added as part of Windows. I wonder how many of us really appreciate the power of this tool being out of the box. The more I see it being used in customer locations, the more I get intrigued by what it can do. Let us learn about Querying SQL Server From Command Line via powershell.
SQL SERVER – What is Trace Flag – An Introduction
Last week I published below blog where I talked about a trace flag. Backup Randomly Failing with Error 112 (There is not enough space on the disk.) One of the reader commented, whether he needs to enable trace flag every time SQL Server is restarted?
SQL Server 2016 – Introducing AutoGrow and Mixed_Page_Allocations Options – TraceFlags
I have been playing around with SQL Server 2016 for a while now and I have seemed to have learnt a number of interesting options when playing around with the new version. One of the readers after reading – SQL Server 2016 – Enhancements with TempDB asked me if the option of TraceFlags of 1117 and 1118 not available when working with user defined normal databases. This was a valid and appropriate question for sure. I was not sure where to start. Let us see traceflags related to AutoGrow and Mixed_Page_Allocations.
SQL SERVER – Disabling 15000 Partitions (15k)
I am really having fun working with customers who are pushing the learning barrier in my new consulting role. The more customers I meet; merrier I am because I am getting interesting challenges that push me from the normal comfort zone I am in. Learning is never stopped, but the learning can never be facilitated if we are not in that zone to learn. This customer had a requirement of upgrading to a newer release and in the process was looking at disabling the 15k partitions he had enabled on the DB because this was out-of-box supported in the latest versions. I thought this was important to bring to life am I talking here. In this blog we will learn about Disabling 15000 Partitions.
SQL SERVER – Steps to Migrate Clustered Disk / LUN
This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.
Primary Key and Null in SQL Server – Interview Question of the Week #071
Question: Can Primary Key on any table contain NULL values? Why? Answer: Primary key on any table in SQL Server can not contain a null value.
PowerShell – Backup SQL Server System Databases
I have been lately writing on powershell and didn’t know there are many more scenarios that can be enabled. I was traveling for a consulting assignment over the weekend for a customer location. Though this exercise was around performance tuning their systems, it was amazing to see that they had some of the basics not done either. In this blog we will be discussing about how to backup SQL Server System Databases.