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.
SQL SERVER – Patch Installation Error: The version of SQL Server instance does not match the version
Applying a patch is something which is part of everyone’s life in the software industry. One of my clients reported below error related to Patch Installation Error.
Identify Used Space in Log File- Interview Question of the Week #090
Question: How to identify Used Space in Log File?
Answer: Use following command to display used log file size and total used space in the log file.
PowerShell – Reading Tables Data Using Script
Earlier in this blog, I have written a number of posts by using PowerShell. The more you play around with this scripting language more are the hidden gems that come out. Personally for me, everyday is like a new learning that needs to be discovered working with SQL Server and PowerShell.
SQL SERVER – How to Join a Table Valued Function with a Database Table
Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016’s new WideWorldImporters database. The question was – “How to Join a Table Valued Function with a Database Table?” This is indeed very interesting as this particular feature was introduced in SQL Server 2008, so what you will see in this blog post applies to every version of SQL Server after SQL Server 2008.
SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance
As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it is critical to help people who needs help NOW. Well let us learn in this blog post about how I recently helped a customer to improve performance by turning off AUTO_CLOSE Database Option.
SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT
In this blog post, we are going to talk about how to hide the number of rows affected messages with the help of SET NOCOUNT.
SQL SERVER – Puzzle – Change in Date Format with Function
Last week we had amazing time with an interesting puzzle about Datetime. You can see the puzzle over here. The puzzle was extremely well received and lots of people asked me to bring another puzzle which can help us learn something new. Looking at the request of everyone, here is another very simple puzzle with Date Format.
SQL SERVER – How to INSERT or SELECT Copyright Special Characters in SSMS?
I answer every email I receive in six hours and that is why sometimes I end up working over 18 hours in a day. However, sometimes I receive emails such that makes me wonder, how come I do not know some very simple stuff. Here is for example – today I received email where user asked how to INSERT or SELECT Copyright Special Characters in SQL Server. Trust me, in my early career, I used to know the answer to this, but I was not able to answer the user immediately. After quick googling, I was able to find out the appropriate character string.
How to Find Missing SQL Server Configuration Manager? – Interview Question of the Week #089
Question: I just installed the latest version of SQL Server and now I am not able to find SQL Server Configuration Manager. What should I do?