Tips to Optimize Your SQL Statements - Part 1
Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.
Mobile BI with SQL Server Reporting Services
For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business Intelligence to tablets and smartphones using Reporting Services.
Survey on SQL Server Monitoring
If looking after the health of SQL Server is part of your responsibility, Redgate would love to hear your views on monitoring server health through this 10 minute survey. Complete the survey by May 15th to be in with the chance to win one of three $50 Amazon vouchers.
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
Data Mining Part 27: Microsoft Data Mining with Cubes
In the chapter 26 we created a cube. Now, we are going to create the Data Mining Model from it.
Email In The Bathroom: Not A Universal Good
Here are some fine, affordable products to completely destroy your work-life balance.
Learn Continuous Integration for Databases in Bellevue, WA
Redgate Software has teamed up with Northwest Cadence to present a workshop on May 15, 2015. Come learn how to implement continuous integration in your database development software pipeline.
Time Testing SQL Azure Point In Time Database Restores
If you need to do a time test for restoring an Azure SQL database from a point in time, and wonder about automating this through PowerShell, here are the guidelines that Tim Smith would you recommend?
Understanding Cross-Database Transactions in SQL Server
Microsoft 'Always On' technology does not support distributed or cross-database transactions. Why not? Grahaeme Ross shows how to investigate cross-database transactions to understand the problem in more detail, and concludes that a Cross-Database transaction can cause loss of data integrity in the commit phase of the two-phase commit.
Your Role Is Changing
The DBA role is changing with the growth of DevOps as a way to better build software in an organization.
Blogs
Monday Monitor Tips: Intelligent Alert Thresholds
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
Forums
String_agg not working as needed
I'm trying to get this string_agg to put all the 'comments' into one result...
Vectors in SQL Server 2025
Comments posted to this topic are about the item Vectors in SQL Server 2025
Odd Sequences
Comments posted to this topic are about the item Odd Sequences
Question of the Day
Odd Sequences
What values are returned from this code?
CREATE SEQUENCE NumericSequence
AS NUMERIC(5,1)
START WITH 1.0
INCREMENT BY 0.1;
GO
SELECT NEXT VALUE FOR NumericSequence
GO
SELECT NEXT VALUE FOR NumericSequence
GO See possible answers