Showing posts with label azure. Show all posts
Showing posts with label azure. Show all posts
Monday, September 14, 2020

[Updated] Prepping the local SSD D: in an Azure VM for SQL Server TempDB

›
One of the few good, safe uses for the local SSD volume of an Azure VM is for SQL Server tempdb data and log files.  Note: this blog post ha...
6 comments:
Thursday, May 28, 2020

SOLVED! Untrusted SAS certs after SQL startup

›
If you've tried doing Backup to URL with SQL Server using a Shared Access Signature (SAS) certificate and received this error: Error...
Tuesday, March 05, 2019

Backup of an Azure SQL DB downloaded outside of Azure

›
From a dev colleague: “Asking for a client... d o you know how to get a backup of an Azure SQL DB downloaded outside of Azure?” Short ...
Sunday, September 25, 2016

SQL SSRS Express Edition Cannot Connect to Azure SQL Databases

›
This has bit a couple of clients recently, figured I'd put out a PSA. Express editions of SQL Server Reporting Service, from SQL 2016 ...
2 comments:
Tuesday, April 05, 2016

SQL Server PerfMon Counters Not Listed in dm_os_performance_counters

›
Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older places as well. SQL Server's performance...
1 comment:
Monday, January 27, 2014

Start/Stop Group of Azure VM's

›
If you've already configured your local machine's PowerShell environment to interact with your Azure subscription (see here:  https:...
4 comments:
Tuesday, December 03, 2013

Upcoming Special Events for the Baton Rouge SQL Server User Groups

›
I'm happy to announce a big slate of upcoming events for Baton Rouge User Groups and especially the SQL Server User Group in the next t...
Wednesday, April 13, 2011

Lightning Round - SQL Azure Overview

›
Here is the slidedeck for my April 13 presentation at the joint Baton Rouge SQL Server and .net User Group meeting on the campus of LSU.