(Greg Low) I have a number of clients that I spend a day or two with each month. I like this style of engagement as I get to know the staff and their systems over a period of time, can see the improvements that we make over time.
Tag: sql server
Monitoring Linux Compute workloads within an Azure Infrastructure
(Scott Hanselman) Scott talks to Khalid Mouss about how you can monitor your Linux machines within an Azure infrastructure. Large numbers of Linux machines run on Azure with great success, so how can you best monitor the CPU and Disk access of your Linux workloads?
Stretch DB – SQL Server 2016
(Devi Prasad) Stretch DB feature in SQL Server 2016 helps to move a part of a SQL Server table to the azure for Archival.
SQL SERVER – Process ID X was killed by hostname ABC, host process ID Y
(Pinal Dave) Errorlogs are an awesome place to learn something new every time. It springs up with some new errors which you might have not seen ever. I am a big believer of the fact that one needs to monitor and take a look at the logs from time to time.
Using Sequences in SQL Server
(Richard Carr) SQL Server 2012 introduced the concept of sequences. These allow the automatic generation of series of numbers. They are similar to identity columns but do not need to be linked to a column.
Remote Profiling support in Azure App Service
(Hamid Safi) Azure Web Apps as well as API Apps and WebJobs can now be remotely profiled. If your process is running slower than expected, or the latency of HTTP requests are higher than normal and the CPU usage of the process is also pretty high, you can remotely profile your process and get the CP
SQL Server Reporting Services Expression Builder to Reformat or Convert Text Box Values
(Dallas Snider) I need to reformat or convert the data returned by a stored procedure to my SQL Server Reporting Services (SSRS) report, but I am not allowed to alter the stored procedure. What options are available?
Using Sequences in SQL Server
(Richard Carr) SQL Server 2012 introduced the concept of sequences. These allow the automatic generation of series of numbers. They are similar to identity columns but do not need to be linked to a column.
Remote Profiling support in Azure App Service
(Hamid Safi) Azure Web Apps as well as API Apps and WebJobs can now be remotely profiled. If your process is running slower than expected, or the latency of HTTP requests are higher than normal and the CPU usage of the process is also pretty high, you can remotely profile your process and get the CP
SQL Server Reporting Services Expression Builder to Reformat or Convert Text Box Values
(Dallas Snider) I need to reformat or convert the data returned by a stored procedure to my SQL Server Reporting Services (SSRS) report, but I am not allowed to alter the stored procedure. What options are available?