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.
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.
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.
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers