Database User Superfluousness In SQL Server
In this article, Thomas Knight analyzes and critiques the design of, and experience with, the "dual-level" user security in SQL Server. He then demonstrates a better theoretical alternative.
Zombie Data
Old data can come back to haunt you. Steve Jones talks about potential problems when data comes back to life.
Disaster Recovery and the Big Data Application
Ask database administrators how they implement disaster recovery in their big data environments and you'll get two typical responses: DR plans are not necessary and backups take up a lot of space. Despite this reasoning, a disaster recovery plan for your big data implementation may be essential for your company's future.
Big Data Comes to Hiring
Big Data is being used to analyze more and more data to produce better decisions. However that doesn't always work as people might expect. Steve Jones talks about some of the issues with using Big Data in hiring.
Data Mining Introduction Part 8: Microsoft Sequence Cluster
This is an introduction to the SQL Server Microsoft Sequence Cluster Algorithm.
Data Mining Introduction Part 8: Microsoft Sequence Cluster
This is an introduction to the SQL Server Microsoft Sequence Cluster Algorithm.
Mongo Jumbo Backups
Backing up MongoDB is akin to backing up SQL Server databases with a Windows tool such as Microsoft DPM. It removes almost all control over the database backup, and more critically, the database restore operation.
New Cartoons at SQLServerCentral
SQLServerCentral has commissioned a new cartoon that will be coming later this week.
Five Tips to Get Your Organisation Releasing Software Frequently
The frequency of releasing software varies widely in the industry. If the test and release process is made as reliable and predictable as possible, then everyone gains. But how do you get started?
Adding to SQL Server
This week Steve Jones wonders what you might want to add to SQL Server. With SQL Server 2016 likely in the early planning stages, where would you want to see the development effort focused.
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers