Nitin In this series, we will learn basics of PowerShell. This Blog will focus on some of the basic terminology and how we can work with Variables in PowerShell. Introduction to PowerShell PowerShell was introduced with Windows 2008/R2. Since then, many versions of PowerShell have launched and with every new version, new features have been introduced. … Read more
Whenever a SQL login is created using password, it is assigned a unique SID and then converted into a hexadecimal hash value.
Cannot connect to SQL instance.
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
Error Number: 18452
Severity: 14
State: 1
Replication is one of the trickiest things in SQL Server and especially when you don’t know the solution of the issue. One such issue we faced a few days back which we were able to solve using a small trick. Here is what happened.: Snapshot got generated on publisher but failed to apply on subscriber. … Read more
As a DBA, how often we check SQL error logs. I would say Mutiple times in a single day. And how many of us really know who to check and read the error logs effectively.
This code will execute IndexOptimize stored procedure and will reorganize or rebuild indexes based on default fragmentation values ( i.e., 5 and 30% – rebuild). However, this will not update statistics as default set to null.
Issue Summary A few days back, a user complained that SSRS report is not working for him and he is getting below error message: An error has occurred during report processing.(rsprocessingAborted) Query execution failed for dataset ‘DataSet1’.(rsErrorExecutingCommand) Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ Initial Investigation When we initially started looking into the issue, we … Read more
In our last post we discussed an approach on what we should do to find whether there is a memory issue or a way to identify if there is a memory crunch which is causing bad SQL performance. However, not always the thing we see on the surface is the root cause. Though there may … Read more
We in the first post saw how capturing and analyzing wait statistics can help a SQL DBA to look for potential performance issue. In the second post we looked at some of the example and potential scenario of wait stats which were similar to a production environment. In this post, we will see how we … Read more
In our last post, we started a journey for SQL Server DBAs so that they can establish an approach for performance tuning issue. We went through some of the basic wait types are and shared links for downloading queries to gather those. Now that you have gathered total wait statistics from a SQL Server instance, … Read more