Block the DBA?
Can you block a DBA from performing certain actions on a server if he has sysadmin rights? The real answer is no, but this article shows you how to block an unknowledgable DBA from performing certain actions.
2003-01-28
6,863 reads
Administration
Another Disaster (Almost)
Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.
2003-01-14
7,052 reads
Building a Demo System - Part 3
Continuing on looking at demo servers, this article presents an interesting solution to ensuring consistent demos that was deployed out in the field for a client company.
2003-01-13
3,631 reads
Query Analyzer Tricks
Query Analyzer is a great tool for developing SQL code. There are a number of little tricks that can greatly increase the amount of work you can do with very little effort. This article starts looking at some of the features of this tool.
2007-10-02 (first published: 2003-01-07)
70,267 reads
Managing DTS packages - Editing, Scheduling, and Viewing Package Logs
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
2006-10-06 (first published: 2003-01-02)
41,668 reads
Beware of Mixing Collations: Converting Collations
With SQL Server 2000 you are able to create databases or columns with a different collating setting than the server. This article will explain a couple of methods Greg has used to successfully change collation settings.
2002-12-30
8,733 reads
Freeware Extended Sproc to Read and Write to a Text File
This free extended stored procedure can read and write to a stored text file. Perfect for writing error logs!
2002-12-24
124 reads
Backup and Restore Back to Basics with SQL LiteSpeed
This article analyzes the various options available for your backup and recovery process with SQL Server 2000 as well as an enhancement to your SQL Server backup and recovery process using a highly efficient backup and restore utility that provides significant time and disk space savings called SQL LiteSpeed.
2002-12-23
11,156 reads
Using SQL Trace to Audit Database Access
As a new DBA, you will probably walk into an environment that is poorly documented and nobody has any idea of how many SQL Servers are on the network. In the first series of articles, Haidong Ji talks about how to audit logins in your SQL Server.
2002-12-20
19,170 reads
Beware of Mixing Collations - Part 1
A few months ago Greg Larsen ran across a big problem with SQL Server collation when querying. He shares his bruises in this quick article.
2002-12-19
12,736 reads
Blogs
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
When is the perfect moment to build a data strategy in a company?
The post When is the perfect moment to build a data strategy in a...
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Forums
Migration of on-premises SQL Server to an AWS PostgreSQL database
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Question of the Day
Renaming a Database
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers