(Grant Fritchey) Invariably, either while building a new database, or while maintaining old ones, you will find that the business needs change or that you’ve made a mistake. Either way, you will need to modify the tables that you’ve created.

(Kenneth Fisher) T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked a subject Lets get all Posh!.

(Allan.Miller) When a Azure SQL Data Warehouse is paused, all running queries are canceled. If there are queries running that have data movement, rollback operations will likely happen. These rollbacks can take many hours to complete.

(Manvendra Singh) In this tip I will show the installation process of SQL Server vNext on a SUSE Linux server.

(James Serra) In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out writes. So what are your options when you have a tremendous amount of writes that scaling up will not handle, no matter how big your server is?

(Robert Sheldon) Get equipped to take advantage of the addition of graph database features in SQL Server 2017 to use graph structures to represent the relationships between different data elements.

(Anoop Kumar) Data with 4 Vs – variety, volume, velocity and veracity is known as Big Data. As we know, there are lots of tools and techniques available to handle big data. Big data is shifting the data paradigm and increasing the expectations with data analytics.

(Pinal Dave) This blog explains what needs to be done when there are tools which can monitor and report issue about SPNs. Once a client informed that SCOM (System Center Operations Manager) is connected to the databases on SQL Server and raising below warning regarding the SQL Server (Service Princi

(Jorg Klein) One of the major benefits of Azure is scalability, the cloud has been built to be elastic to be as cost-effective as possible. Azure solutions can be scaled in ways that would never be possible with your own hardware.

(Don Castelino) This blog covers the steps to migrate the On premise SQL Server database to Azure SQL database using Database Migration Assistant v3.2 (DMA) tool.