(Marcin Policht) The majority of Azure SQL Database related features reach their General Availability (GA) stage relatively quickly (even when measured in the Azure hyper-accelerated terms).
Tag: sql server
SSRS Subscription Schedules
(Jason Brimhall) Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can be delivered in various formats and can even be scheduled to be delivered at various times. I even recently wrote about creating more advanced custom schedules.
SQL SERVER – Event ID 1045 – No Matching Network Interface Found for Resource ‘Cluster IP Address’ IP address ‘10.10.10.10’ (Return Code was ‘5035’)
(Pinal Dave) One of my clients implemented AlwaysOn Multi-subnet listener. This is one of the message which I have heard from few other AlwaysOn availability group customers who are having multi-subnet deployment.
What is plan regression in SQL Server?
(Jovan Popovic) Plan regression happens when SQL Server starts using the sub-optimal SQL plan to execute some T-SQL query. Usually you will see that some T-SQL query is executing really fast, but then it gets slower without any obvious reason. In this post you will see how can plan regression happen
SQL SERVER Transactional and Merge Replication internal and work flow explained
(Vikas Rana) Recently Sravani and I delivered session on SQL SERVER Transactional and Merge Replication and covered following topics:
Azure Import Export Services – Notes from the field
(Denny Cherry) One of my clients recently had the need to upload tens of terabytes of data into Azure Blob Storage. This gave us the perfect opportunity to use the Azure Import Export service to get these several terabytes of data into Azure by using the Azure Import/Export Service.
Azure Automation Methods
(Tim Radney) Over the past year, I have presented many sessions on Azure SQL Database as well as authoring numerous articles and blogs. I’m often asked if database maintenance is still an important factor when using Azure SQL Database. Yes – tasks such as index maintenance, statistics updates, and c
SQL SERVER – My Thoughts – Autogrow of File ‘SQLAuth_Log’ in Database ‘SQLAuth’ was Cancelled by User or Timed Out After 30020 Milliseconds
(Pinal Dave) If you are seeing this error in the ERRORLOG on your production server then you must read this blog. I have collected some information about the message and its causes. Let us learn about Autogrow of file.
How to Read the Transaction Log File
(Greg Larsen) Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Well there is a way to read the transaction log file using an undocumented function. In this article, I will show you how to browse the transaction log using this undocumen
Why shouldn’t I shrink my database log file?
(Kenneth Fisher) TL;DR: It’s pretty pointless and can cause performance issues.