I want to count the number of lines of code for all of our non-CLR procedures, views and UDFs in a database, how can I do this? I also want to exclude comments and empty lines from the counts.
What are the common DBA tasks suitable for SQL Server PowerShell? How can I start to learn about these tasks in SQL Server?
From time to time you may see replication error 20598 for DELETEs. This a pain to fix manually and we often do not want to resort to having to redo the snapshot or skip the error. In this tip I show how you can deal with this error.
When using SQL Server replication, from time to time we will see replication error 20598 which is a pain to fix without having to resort to snapshot synchronization or error skipping. In this tip I show you an easier approach to fix these issues.
It's a common task that DBAs need to drop SQL Server logins after a user leaves a company or some business scenario changes. Usually this is not a big task, but in a worst case scenario the SQL Server login may have database user accounts in multiple data
We have a customized database index maintenance job that runs every night, however from time to time the index maintenance job will block other business jobs or sessions and can cause business problems. In this tip we look at how to setup a process to det
When you have a lot of SQL Server instances to manage and servers are retired and new ones are added, it becomes a headache to manually maintain these registered servers in SSMS. In this tip we look at how to use a control file that lists the structure t
Each time, when we get a production SQL Server reboot incident, we need to investigate and prepare an Incident Report in which the DBA Team must report the duration when the SQL Server service was unavailable, is there an easy way to determine the downt
The SQL Server error log is notorious for growing really large when certain things happen; like repeated login failures, stack dumps or other errors. When the log gets big, it makes it difficult to find real issues, much slower and it can fill up your dis