Create a New SQL Server Maintenance Plan with the Maintenance Plan Designer
In this tip we look at how to use the SQL Server Maintenance Designer to build maintenance plans for your databases and instance.
2019-11-01
Additional Articles
Accelerating Database Recovery with SQL Server 2019
Learn how to turn on and use newer SQL Server database recovery option called “Accelerated Database Recover”.
2019-10-31
SQL Productivity with SQL Prompt
There is an old joke that upgrading to the latest SQL Server is wasted on some DBAs, because they will still stick mainly to what worked in SQL Server 2005. This type of DBA is becoming rare, in my experience, but there is still some truth in the idea that many of us don’t get the ‘full power’ from our SQL Server tools. We work with them as they come, ‘out of the box’, and use only a fraction of their features. The time to explore ‘new stuff’, at least as much as we’d like to, remains elusive.
2019-10-31
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
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
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
The New Database CheckDB
Comments posted to this topic are about the item The New Database CheckDB
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Comments posted to this topic are about the item MySQL’s BLACKHOLE Storage Engine: The...
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers