Fix SQL Server Log Shipping After a New Database File has been Added
The code in this tip will demonstrate how to continue SQL Server Log Shipping after a file has been added to the primary SQL Server database.
2014-02-05
2,846 reads
Articles
GenesisOne T-SQL Unscrambler
This industry-first T-SQL source code unscrambler automatically reads the details hidden in T-SQL stored procedures without altering the source code. With this granular information, it generates organized and precise data flow diagrams along with plain-language descriptions of each programming step within any database object. Resulting documentation can be generated in PDF, Word or HTML.
2014-02-05
4,014 reads
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.
2014-02-04
4,376 reads
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.
2014-02-04
4,531 reads
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.
2014-02-03
316 reads
New Cartoons at SQLServerCentral
SQLServerCentral has commissioned a new cartoon that will be coming later this week.
2014-02-03
2,566 reads
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?
2014-02-03
2,729 reads
Database Mirroring Setup
This great tutorial shows how to set up database mirroring across two instances in a virtual environment.
2014-01-31 (first published: 2011-04-12)
14,355 reads
Reduce Time for SQL Server Index Rebuilds and Update Statistics
This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.
2014-01-31
5,471 reads
Finding “Active” Rows for the Previous Month (SQL Spackle)
SQL Server MVP Jeff Moden walks us through the classic problem of finding all the "Active" rows for the previous month using start and end dates. This is excellent for those new to T-SQL.
2014-01-30
8,778 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers