Transaction Log Stairway Series available as a book
Red Gate Books has released SQL Server Transaction Log Management, a free eBook on maintaining and troubleshooting the enigmatic transaction log based on the Stairway Series.
Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
Backup and Restore SQL Server with the SQL Server 2012 PowerShell cmdlets
There are plenty of occasions when it makes a lot of sense to do backup and restore scripts in PowerShell. Microsoft have put effort into making it much easier, as Allen White demonstrates.
Data Mining Introduction Part 5: the Neural Network Algorithm
This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.
Data Mining Introduction Part 5: the Neural Network Algorithm
This is the 5th article about Data Mining with SQL Server. This chapter is about Neural Networks.
Understanding HA
Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.
Paging Data with T-SQL
Greg Larsen shares a number of different TSQL methods to provide paging functionality, for when your application requires that you display only one page of data at a time.
How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
Power View for Cubes
This document evaluates the latest functionality provided by Microsoft SQL Server 2012 With Power View for Multidimensional Models[1], this SQL Server 2012 CTP release allows connections between Power View and Multidimensional Models ( cubes) and not just Tabular Models.
Centralizing SQL Server Express Job Scheduling
I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Windows Task scheduler on each SQL Server Express since SQL Agent does not come installed on Express Editions. Is there an alternative where I can utilize my existing SQL Server infrastructure?
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers