Log Your Changes
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,425 reads
Articles
Moving Databases to a New Server
Got a plan for moving your data to the new server? Try this one! Andy Warren offers step by step instructions on how to move your data without doing a backup/restore or using detach and attach.
2001-04-30
9,467 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,693 reads
Book Review: Guru's Guide to T-SQL
This week, Brian Knight reviews the book Gurus Guide to Transact SQL.
2001-04-29
5,529 reads
Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,955 reads
Automatically Gathering Server Information Part 7
The seventh part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-27
4,933 reads
Invisible Comments
I ran into a dilemma when I was told that I should not allow potential competitors to view my JavaScript comments. If they want to figure the code out; make them work for it.
2001-04-26
3,566 reads
Automatically Gathering Server Information Part 6
The sixth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-25
5,667 reads
Computer Problem Report Form
This humorous form was originally desgined for Network Admins, but it works for DBAs as well.
2001-04-25
3,467 reads
Keeping Your Developers Under Control
Everyone needs a stable environment. This article discussed ways to keep your team on the same page.
2001-04-25
5,810 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Strange String Splits
Comments posted to this topic are about the item Strange String Splits
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers