Splitting a SQL Server Table Over Multiple Files
In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.
2019-10-30
Additional Articles
Planning for SAP HANA Deployments in Public Cloud Environments
Learn about the factors that should be taken into account if you are considering hosting SAP HANA in a public cloud.
2019-10-29
Recreating Databases from Scratch with SQL Change Automation
Phil Factor starts with the basics how to rebuild a set of development database from scratch, using SQL Change Automation, and then demonstrates how to check for any active sessions before rebuilding, import test data using BCP, and secure passwords if connecting to the target with SQL Server credentials.
2019-10-29
Establishing a DevOps Organisation
DevOps might sound intimidating if your organisation has not yet begun on its DevOps journey. In this article, Rahul Varshneya explains some of the benefits and reviews the stages all DevOps organisations go through to achieve it.
2019-10-28
Using the SQL Compare command line with Argfiles
Phil Factor demonstrates how using XML argfiles to pass parameters to SQL Compare cuts out a lot of the tedious scripting involved in modifying a database schema comparison and deployment process, as required for each target database.
2019-10-28
DevOps falling short?
Organizations are looking for help with their DevOps implementation, including Redgate tools, knowing where they want to go with their production and deployment but not sure where to start. Clear Measure have designed a 30-point DevOps Inspection & Report to provide you with the feedback and guidance you need to take your software development and deployment to another level. Request your inspection now.
2019-10-25
Inventory SQL Server Agent Jobs for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.
2019-10-25
SQL and Scope
Understanding scoping rules is a basic skill for developers. In this article, Joe Celko gives a bit of the history of scoping in early programming languages and shows how scoping applies to SQL queries as well.
2019-10-24
Where SQL Server monitoring fits into your tech stack
This article explains the basic components of a tech stack, and the decisions and requirements that affect how and where monitoring tools generally, and a specialist SQL Server monitoring tool like SQL Monitor, in particular, fit into your stack.
2019-10-24
Troubleshoot Slow RDS SQL Servers with Performance Insights
In this article we look at using AWS Performance Insights to help monitor and troubleshoot SQL Server performance issues when running on RDS.
2019-10-23
Blogs
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers