Differential Backups Internals
Describes how data changes for differential backups are recorded using dbcc page
2007-12-11
4,395 reads
Administration
Moving the tempdb database
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
2007-12-06
3,660 reads
Fixing Orphaned Users
Migrating databases between production, test, development and train servers is something that a DBA needs to deal with constantly. During migration, one of the inevitable issues we need to deal with is concept of Orphaned Users.
2007-12-04
11,396 reads
So You're the New DBA
In a new DBA role, Daryl Quadros brings us a list of the first tasks you should perform.
2007-11-28
11,259 reads
Locate specific columns used in procs
SP to find object and line number that references column(s) of interest.
2008-01-24 (first published: 2007-11-21)
1,023 reads
Featured Blog: CHECKDB From Every Angle: Can CHECKDB repair everything?
What can't be fixed by CHECKDB? Read this great entry from the former SQL Server Storage Engine lead.
2007-11-21
2,282 reads
SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,310 reads
Distributing SQL Server Databases
Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.
2007-10-22
5,624 reads
Check owners, collations and backups
A script to check the owners, collations and backups on the server.
2012-04-16 (first published: 2007-10-19)
2,636 reads
2007-12-18 (first published: 2007-10-18)
2,684 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers