SQL Azure Point-in-Time Restore
Point-in-Time Restore is a new feature of the SQL Azure Service Tiers
Database Deployment Problems Survey
Red Gate is looking to build tools and features to help reduce the risk of database deployment. In order to achieve this, we need to get a better understanding of the most common deployment problems you are encountering when moving changes from development to production. Please help by filling in our two-page survey.
Questions about Primary and Foreign Keys You Were Too Shy to Ask
It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
SQL Monitor Custom Metric: Buffer Pressure
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.
Document, then Install
Should we declare what we want installed and then have every instance configure itself? Steve Jones talks about the need to ensure we know what is running before we install rather than documenting it afterwards.
Fine Products for the Modern Drudge
As working hours in tech trend upwards, we look at some ways to make life easier.
Linked server creation to MySQL Server
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
PASS Summit, Seattle, WA
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.
Understanding How to Use the UPDATE Statement to Change Your Data
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
Fun Data Analysis
This week Steve wants to know if you'd have some issues when analyzing data and you've mistaken correlation for causation.
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers