MDX Guide for SQL Folks: Part I - Navigating The Cube
Learn all you need to know about MDX, by drawing only on your current SQL knowledge.
2014-06-13 (first published: 2012-11-01)
28,377 reads
Articles
Setting Up Your SQL Server Agent Correctly
It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges’, and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.
2014-06-13
3,563 reads
SQL Server Performance Tuning with Hypothetical Indexes
Daniel Farina demonstrates how to create and test hypothetical indexes with the undocumented DBCC AUTOPILOT command.
2014-06-13
3,858 reads
Logging in Maintenance Plans
Enabling and Configuring Reporting and Logging for Maintenance Plans in SQL Server 2012
2014-06-12
3,576 reads
Database Delivery Patterns and Practices
The articles collected here will help you understand the theories and methodologies behind every stage of the database delivery pipeline, starting when database changes are checked in, and ending when they're deployed to production.
2014-06-12
4,888 reads
Survey: Which new database platforms are you adopting?
Database technologies are always improving, which database platforms will you be using tomorrow? Red Gate wants to stay ahead to make sure you have the tools you need to do awesome work. Help us by completing this short survey.
2014-06-12 (first published: 2014-05-29)
5,447 reads
Traits of a DBA - Part One – The Technical Side
What does it take to become a database administrator, or what kinds of traits should I be looking for when I am hiring a DBA. Those traits can be summarized it two categories: Technical and Personal. In this article, Greg Larsen discusses the technical traits a DBA should have.
2014-06-11
5,342 reads
Display All Errors Fired in a Restore Procedure
Display all errors thrown within a catch block by a restore statement in a stored procedure using extended events
2014-06-10
3,796 reads
On Comparing Tables in SQL Server
How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.
2014-06-10
5,867 reads
SQL Monitor Custom Metric: Ad Hoc Queries Running Once
This metric measures the total number of ad hoc queries in the plan cache that have only run one time. The value is only accurate for the instant the query is run, and the value can change radically from one capture time to the next.
2014-06-10
2,042 reads
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers