(Pinal Dave) The other day during one of my old clients sent me an email about if I know any trick to get the second row from the resultset. I know why he was asking this question as I had worked with him before Comprehensive Database Performance Health Check.

(lukaseder) One of Java’s big strengths, in my opinion, is the fact that most naming conventions have been established by the creators of the language.

(Eli Leiba) The requirement is to create a T-SQL script to report when a SQL Server Windows login password will expire.

(Ranga Babu) In this article, we will review how to set up Geo-Replication on a Transparent Data Encryption (TDE) enabled Azure SQL database.

(Pinal Dave) Just another day in my life when I got involved in the SQL Server Performance Comprehensive Database Performance Health Check, where I ended up with a server with a high amount of malicious Wait Type. In this blog post, we will learn about how to fix the performance issue with the malic

(Itzik Ben-Gan) The ROW_NUMBER window function has numerous practical applications, well beyond just the obvious ranking needs.

(Kenneth Fisher) I’ll admit, I’m a lot more comfortable with tracing and the profiler than I am with EE (extended events) and the viewer. It’s something I really want to get past but haven’t yet.

(Alejandro Cobar) If your manager or a colleague asked you:

(Pinal Dave) A few days ago, I wrote a blog about the issue with the SQL Server upgrade where issue was due to Reporting Services installation in a bad state. Here is the link for that blog. SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service.

(Mohammed Moinudheen) I have a number of Azure SQL Server resources to manage. My manager has asked me if it is possible to categorize the Azure resources based on the various departments within the company and also to consolidate the resource billing information by department within the organizatio