(Ahmad Yaseen) I have a lot of tables in my database and I think some of them are not being used, how can I identify the unused tables in a SQL Server database?
Tag: sql server
#0374 – SQL Server – Removing string terminators (‘ ’) using REPLACE during string concatenation
(Nakul Vachhrajani) Recently, I was called upon to troubleshoot a strange behaviour demonstrated by a data conditioning script that involved string concatenations. The script ran fine without any errors, but the script did not appear to be concatenating string.
PowerShell – Disk Space Monitoring and Early Warning Reports
(Hareesh Gottipati) Disk space is one of those things that frequently runs out of space no matter how much you bump it up irrespective of the service you are running in the server. I know storage is cheap but who wouldn’t want to keep an eye on what’s cooking especially when it has the potential to
How to Monitor Azure IoT Hub Traffic
(Jon Gallant) You have a couple different options to monitor your incoming and outgoing Azure IoT Hub traffic.
SQL SERVER – SSMS Tip: How to Get Larger Fonts for Results in Grid Output
(Pinal Dave) A couple of weeks back, I was at the GIDS (Great Indian Developer Conference) speaking on my favorite topic of performance. Often as a speaker I make sure I attend a couple of sessions from friends or from people in the industry to learn something completely new.
PowerShell : Script Method Error -Method invocation failed because [Microsoft.SqlServer.Management.Smo.ServerRole] does not contain a method named ‘Script’.
(Prashanth Jayaram) I was working on generating scripts for logins, users and server roles and I could able to to generate scripts for users and logins but where as for server roles, the script() method is not working.
Back to Basics: What is a SQL Server Instance Name?
(Steve Endow) I regularly work with customers who do not know what the SQL Server Instance Name is for their Dynamics GP environment. For non-technical users, this is totally understandable–it isn’t something they would normally need to know.
Danger of maintaining SQL backup copies in different locations
(Jack Vamvas) Question: I’d like to find out whether I can maintain different backup sets in different backup systems. This may sound like a strange question but we are currently transitioning from one backup system platform to another platform. There will be a cross over period .
Import Active Directory Data to a SQL Server Table
(Douglas Correa) Active Directory has a lot of great information that can be used for other systems. In a previous tip we looked at how to export this data using PowerShell and in this tip we will look at how to load the XML data into a SQL Server table.
SQL Error – The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE
(Manoj Pandey) Today after setting up a new Database environment I ran into a small issue. While running a Stored Procedure I was getting following error: