Restoring the Master Database
This article shows you in a step-by-step manner how to restore the master database.
2001-04-29
8,924 reads
Articles
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,908 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,543 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,625 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,452 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,793 reads
Automatically Gathering Server Information Part 5
The fifth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-24
6,946 reads
Stuff Computer Support People Love
For anyone who supports desktops, this document shows how to sarcastically please your IT department.
2001-04-24
3,672 reads
Using InterDev's Toolbox
If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant
2001-04-24
3,060 reads
Introduction to DSN's
This article by Andy Warren is an introduction to DSN's; what they do, how they work, and where they are stored. Also pick up some ideas about how using a File DSN might save you a lot of administration!
2001-04-23
8,426 reads
Blogs
Denver Dev Day – Best Practices for Database Deployments Resources
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
A New Word: desanté
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
What happens when we drop a column on a SQL Server table? Where's my space?
This article was initially posted on SQLServerCentral @ 2024-04-26. Short answer: The column is marked...
Forums
Advice: how to script out existing Azure (logical) SQL Server logins
Advice on how to script out existing Azure (logical) SQL Server logins and mapped...
Abort Package after specified timeout project parameter
Hi I have a sequence container which contains an execute package task which loads...
JSON escape characters
Hello, I'm tasked to generate JSON files with the FOR JSON Clause of SQL...
Question of the Day
Adding Hints with Query Store
I have a query that is being tracked in the SQL Server 2022 Query Store. I want to add a hint to this query to ensure that the MAXDOP for this query is one. How can I do this with minimal code changes
See possible answers