For my upcoming training, I was trying to deploy SQL Server 2008 R2 Cluster in my client’s lab machines. I encountered a strange error and I was clueless. Let us learn about Rule Windows Server 2003 FILESTREAM Hotfix Check failed on Windows 2012 R2 Cluster.
How to Introduce Time Delay Between Two T-SQL Commands? – Interview Question of the Week #091
Question: How to Introduce Time Delay Between Two TSQL Commands?
PowerShell – Create a User with Read Rights on a Database
I have written a number of PowerShell script in the blog and they have been used by many. Most of these scripts are there because someone wanted something different and I got about creating something simple. After I create something for a given use case, I tend to share it in the blog so that people can start using the same.
SQL SERVER – Simple Example of BCP Command Line Utility
I was recently asked if I know the fastest way to export data from SQL Server table. This was very interesting question personally, as I have not run any such tests in the past. However, everytime when I had to export data, I have used in past BCP command line utility and I have found it does a pretty good job.
SQL SERVER – SSMS Trick – Switching Columns in Grid Output
Yesterday when I wrote about what I learnt from Vinod’s session at the SQL Server User Group meeting, one of my friends wrote back asking what else was discussed. Though I knew some of the tips and tricks he showed as part of the sessions, there were few that stuck in my mind. His session around security and how some of the fundamentals were shaken was worth every minute. In this blog we will discuss about how we can switch column in grid output.
SQL SERVER – Hidden SSMS Gem: Find Dialog’s Unknown Functionality
I have an eye for details and I try to keep looking for something new to some of the tasks I have been doing for years together. This exploration and quest to learn new techniques is what has made me survive longer in this industry I suppose. So let me talk about my learning from the recent SQL Server Bangalore UG Meet. I was sitting with my SQL friends and there were topics around what one must try some of the new tooling capabilities that SQL Server 2016 has brought to the table. I am always intrigued by some of these conversations as it gets me a different perspective. This is when I saw my good friend Vinod Kumar (MTC Architect) get on stage to show some cool tips for being productive. Let us learn about Hidden SSMS Gem.
SQL SERVER – How to Find Out When Your SQL Login Will Expire?
If you are a SQLDBA, you must have created a login and you must have known about enforcing password policy to SQL Logins. Once of my client asked to provide script to find expiry details about SQL Login. It was an easy task. I went to books online and used LOGINPROPERTY function and passed name to all the possible parameters. Below would work for SQL 2008 onwards.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.