Microsoft SQL Server Management Tools

The writers of this blog are a part of the Microsoft SQL Server team. We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server management tools

Browse by Tags

Tagged Content List
  • Blog Post: SQL Server Management Studio October 2015 Preview

    We invite you to download and install SQL Server Management Studio October 2015 Preview Details: https://msdn.microsoft.com/en-us/library/mt238290.aspx Download Link: http://go.microsoft.com/fwlink/?LinkId=624652 Try out this preview and send us your feedback via SQL Server Connect - https://connect...
  • Blog Post: SQL Server Management Studio September 2015 Preview

    We invite you to download and install SQL Server Management Studio September 2015 Preview from here Details: https://msdn.microsoft.com/en-us/library/mt238290.aspx Download Link: http://go.microsoft.com/fwlink/?LinkId=623262 Try out this preview and send us your feedback via SQL Server Connect...
  • Blog Post: Powershell script to generate Policy based Azure Storage access token

    We have written a powershell script to generate policy based azure storage token. You can copy the code from https://github.com/sethusrinivasan/azure/blob/master/powershell/create_storage_access_token.ps1 You can use this token to create a SQL Server credential that can be used to create SQL Server...
  • Blog Post: Index rebuild on large database - SQL Agent Powershell job

    Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one when index fragmentation is greater than 30%. Related newsgroup thread: http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/thread/4faae7c8-3e58-4117-8538...
  • Blog Post: Gathering failed job history using power shell

    How to use this powershell script: - Launch SQL Server PowerShell ( Start -> Run -> sqlps.exe) - Copy the following powershell script and save to file (Ex c:\JobHistory.ps1) - in SQL powershell window, type in script file path ( Ex: c:\JobHistory.ps1) to run the script Note: replace "machine\instance...
  • Blog Post: Email Query output as ANSI / UNICODE file attachment using Powershell and Database Mail

    #launch sqlps.exe to run the followign script #update servername,email profile, recipient list that matches your environment $instanceName = "MACHINE\SQLINSTANCE" $targetFileAnsi = "c:\temp\result_ansi.csv" $targetFileUnicode = "c:\temp\result_unicode.csv" $dbQuery = "select SERVERPROPERTY...
  • Blog Post: Backing up a database in a DB Mirroring configuration

    Background: Database Mirroring in SQL Server is used to increase database availability. You can read more about database mirroring at http://msdn.microsoft.com/en-us/library/ms189852.aspx . Database can be backed up only on the primary instance. On mirrored instance, database backup cannot be performed...
  • Blog Post: Limit resources used by SQL PowerShell Jobs using Resource Governor

    Resource governor in SQL Server can be used to limit resource consumption by specific application / user. Long running queries / tasks in SQL PowerShell might consume more SQL server resources. If you would like to set limits, you can do by enabling resource governor, define classifier function to assign...
  • Blog Post: Scheduled Policy Evaluation on multiple servers using MSX/ TSX in SQL Agent

    One of our customer was looking for ways to schedule a policy evaluation on multiple servers using their existing MSX/TSX infrastructure. I thought it would be better to blog an article that could help others looking for similar information Before we get into details, here are some basics. Please...
  • Blog Post: Database Mail – Validating your SMTP mail server configuration using powershell

    Database mail relies on .NET framework's SMTP client API to send emails. You could write a simple power shell script like this to test out if you are able to send mails using your smtp server Sample Powershell Code to send email: 1: $smtpServer = "emailserver" 2: $smtpPort = 25 ...
Page 1 of 1 (10 items)