SQL Monitor Custom Metric: Table size (MB)
This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.
2015-07-21
2,899 reads
Press Release
MS15-058: Vulnerabilities in SQL Server could allow remote code execution
A vulnerability has been released that can affect SQL Server 2008, 208 R2, 2012, and 2014.
2015-07-15
5,871 reads
Press Release: Redgate brings expert SQL Server training to London and Seattle
Cambridge, UK, 2 July 2015 – Redgate, the SQL Server and .NET software company, returns to London and Seattle in October with its enormously popular training event, SQL in the City.
2015-07-03
513 reads
SQL Monitor Custom Metric: Memory Used By Ad Hoc Queries Running Once
This metric measures the amount of memory used by the total number of ad-hoc queries that are currently in the plan cache. If the value is high, it indicates memory is being wasted by storing the execution plans of queries that will never be run more than one time.
2015-06-25
2,334 reads
How do you use change scripts for your database deployments?
Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.
2015-06-16
3,886 reads
SQL Monitor Custom Metric: WriteLog wait time
This metric shows Writelog wait time in ms, per elapsed second. Writelog wait types occur when the log cache is being flushed to disk. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored.
2015-06-09
2,958 reads
Take our SQLServerCentral Users Survey
Each year SQLServerCentral runs a survey to get some insight into what who our readers are, what they like about the site, and what can be improved. Please take a few minutes to complete this survey by June 12 and get the opportunity to win one of three $50 Amazon vouchers.
2015-06-02 (first published: 2015-05-26)
13,214 reads
The MidnightDBAs release Minion Backup
The MidnightDBA team is announcing the release of a new, free backup solution for SQL Server: Minion Backup. We created Minion Backup (or MB, for short) to be the most flexible, feature-rich backup solution possible.
2015-06-01
1,634 reads
SQL Monitor Custom metric: Average I/O stalls
This is a good general indicator of performance problems. High stall times indicate I/O problems, which can be attributed to busy physical disks or queries that return large data sets to the client.
2015-05-26
6,171 reads
Webinar: How to safely manage application and database changes with continuous delivery
Join Brian A. Randell, Grant Fritchey and Steve Jones in this panel discussion to hear tips, ideas and share your questions on managing application and database deployments with continuous delivery. This Free webinar will be on May 27th at 4PM BST, register while space is available.
2015-05-26 (first published: 2015-05-21)
13,036 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers