Question: What is the Biggest Limitation of ISDATE() Function?
SQL Server Management Studio (SSMS) – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service
After installing the latest version of SSMS (17.2), I was not able to connect to SQL Server Integration Services SSIS on my local machine.
SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated
This blog explains what needs to be done when there are tools which can monitor and report issue about SPNs. Once a client informed that SCOM (System Center Operations Manager) is connected to the databases on SQL Server and raising below warning regarding the SQL Server (Service Principal Name) SPNs:
SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero
Puzzle: Write a Shortest Code to Produce Zero.
SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016
One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.
SQL Authority News – Community Hub by Redgate
It is not possible that readers of SQLAuthority.com is not aware of amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our efficiency. Redgate software along with helpful tools also produces a very interesting content for DBA and Developers. I am excited to see that Redate has recently announced Community Hub.
SQL Server Management Studio – New Feature – Object Explorer Query Tracking
A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard. In this blog post we will learn about the brand new feature called Object Explorer Query Tracking.
How to Allow Only Alphabets in Column? – Interview Question #136
Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.
SQL SERVER – 3 Different Usage of DBCC SQLPERF
Have you ever wondered what does DBCC SQLPERF do in SQL Server?
SQL SERVER – Cluster Patching: The RPC Server is Too Busy to Complete This Operation
If you have ever contacted me via email, you would know that I am very active in replying to emails. Many of the emails are for suggestions and I don’t get much time to help everyone, but I do reply to them letting them know the alternatives. If you are following my blog, you would know that I do provide “On Demand” services to help critical issues. This blog is an outcome of one of such short engagement. This is how it started and it is about RPC Server.