(Manoj Pandey) Today I got an email from someone regarding an issue he was facing. He was trying to Backup SQL Server database to URL i.e. the Azure Blob Storage, by issuing below Backup command:
Tag: sql server
When to Use Row or Page Compression in SQL Server
(Thomas LaRock) Introduced with SQL Server 2008, page and row compression are turning ten years old this year. In that time, the internet became littered with posts describing both features, how they work, the performance gains, etc.
Scripts to check SQL Server instant file initialization and lock pages in memory for all servers
(Pablo Echeverria) As you may know, there are some performance boosters for SQL Server, and you need to check if you have them set up, or determine if you need to enable them on some of your servers. So after reading this article, I wondered if there was a way to check SQL Server versions prior to 2
SQL Server User Already Exists – Back to Basics
(Jason Brimhall) One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions.
Azure Cosmos DB Partitioning
(Marcin Policht) One of the most important design decisions that must be made when planning deployment of Azure Cosmos DB involves logical partitioning of data that will populate target collections, graphs, or tables.
SQL SERVER – DMV to Get Host Information – sys.dm_os_host_info
(Pinal Dave) There was a time when SQL Server used to run on only Microsoft Windows. However, the time has changed, and SQL Server now runs on Linux as well. This is indeed a great move as I believe database such as SQL Server should be running on multiple platforms.
Developing and Debugging Desired State Configuration Scripts for Azure VMs
(Michael S. Hansen) PowerShell Desired State Configuration (DSC) scripts are a popular way to configure Virtual Machines in Azure. In previous blog posts, I have made extensive use of them to configure SQL Server Always On and Team Foundation Server in Azure among other scenarios. These deployments
Database Fundamentals #16: Removing Data With T-SQL
(Grant Fritchey) Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.
Download & Install SQL Server Reporting Services (SSRS) 2017 (decoupled from SQL Server engine setup)
(Manoj Pandey) In one of my [previous blog] post related to SQL Server 2017, I mentioned regarding SQL Server Reporting Services (SSRS) that it will no longer be installed from the main feature tree of SQL Server engine setup, just like SSMS.
SQL SERVER – What Does SET NOEXEC Do?
(Pinal Dave) Just the other day I received an email with a question – What Does SET NOEXEC Do?