Geeks With Blogs
Jim Giercyk May 2017 Entries
Getting SQL Server MetaData the EASY Way Using SSMS
So, you are asked to find out which table uses up the most index space in a database. Or how many rows are in a give table. Or any other question about the metadata of the server. Many people will immediately jump into writing a T-SQL or Powershell script to get this information. However, SSMS can give you all the information you need about any object on the server. Enter, OBJECT EXPLORER DETAILS. Simply go to View –> Object Explorer Details OR hit F7 to open the window. Click on any level of ......

Posted On Thursday, May 11, 2017 11:41 AM

Adopt a SQL orphan
All DBAs have been asked to copy a database from one SQL instance to another. Even if the instances are identical, the relationship (SID) between the logins and table users are broken. Microsoft includes sp_change_users_login to help mitigate this problem, but using the stored procedure must be done database by database, or even user by user, which can take a significant amount of time. Consider the time it takes to migrate an entire server, or create a secondary instance. Why not automate the process. ......

Posted On Thursday, May 4, 2017 10:08 AM

Deleting old AZURE backups with Powershell
As companies begin migrating to AZURE, DBAs are tempted to save terrestrial (non-AZURE) backup files to “the cloud” to leverage the unlimited amount of space that is available. No more alarms in the middle of the night due to a lack of disk space. Ole Hallengren has even added this option to his maintenance solution (https://ola.hallengren.com/). Others have also followed suit. The trouble is that most backup solutions do not have a way to clean up old blob backup files. This little script will clean ......

Posted On Monday, May 1, 2017 3:26 PM

Copyright © Jim Giercyk | Powered by: GeeksWithBlogs.net