SQL Server 2000 Reporting Services Service Pack 1 has been released. You can download it here.
http://weblogs.asp.net/sbchatterjee/archive/2004/06/22/162538.aspx
Read more →
EDIT: This stored procedure has been updated.
The below stored procedure will backup the transaction log for each of the databases that aren't being log shipped (you don't want to break log shipping by running a transaction log backup outside of the log shipping plan) and also aren't using SIMPLE for the recovery model.
Read more →
EDIT: This stored procedure has been updated.
Yesterday, I posted a stored procedure that performs a full backup on the databases. I mentioned that I had a SQL LiteSpeed version. This version backs up all databases except master, model, msdb, tempdb, pubs, NorthWind.
Read more →
EDIT: This stored procedure has been updated.
This stored procedure performs a full backup of the databases. It has two input parameters. The first input parameter is the path to where you would like to backup the databases.
Read more →
EDIT: This stored procedure has been updated.
Here's a stored procedure that will check the integrity of each of the databases. I've got it scheduled to run every night on each of our servers.
Read more →
PASS Webcast: SQL Server Yukon CLR for the DBA Tuesday, June 15, 2004 (12:00 pm EDT) In this session you'll learn about the new .NET Common Language Runtime integration with SQL Server 2005.
Read more →
I've been working on SQL Server 2000 Reporting Services for the past couple of weeks. I plan on blogging about my experience by providing tips.
Reporting Services Tip #1:
If you've created a report that you would like to deploy to a server without using Report Designer, you can upload the rdl file in Report Manager.
Read more →
Well it's over 90 degrees in San Diego, CA this week. I went to the beach yesterday to escape the heat as did thousands of others (I should have sold my parking spot when I left).
Read more →
MSDN Webcast: Protecting Your System From SQL Injection Attacks - Level 200
4/27/2004 5:00 PM - 4/27/2004 6:30 PM Language: English-American Live Meeting Webcast - (GMT -08:00) Pacific Time Online Event United States General Event Information Products: SQL Server.
Read more →
MSDN Webcast: Securing Applications with SQL Server 2000 - Level 300
4/22/2004 1:00 PM - 4/22/2004 2:30 PM Language: English-American Live Meeting Webcast - (GMT -08:00) Pacific Time Online Event United States General Event Information Products: SQL Server.
Read more →
Ever wanted to see the ERD for the system tables in MS SQL Server 2000? If you can't get your hands on the poster, then you can download a soft copy here.
Read more →
A question came up on SQLTeam that asked if anyone has a script to copy new backups to a remote server. Of course, you could do this in VBScript, but how would you know about backups that were put into a different directory than what your code is expecting?
Read more →
TechNet Webcast: The Guru's Guide to SQL Server 2000 Memory Management Intervals – Level 300
April 6, 2004
8:00 AM - 9:30 AM Pacific Time
Ken Henderson, Microsoft SQL Staff Member and Addison Wesley Author, Microsoft Coropration
Read more →
Why is it that you can pass a built string to xp_cmdshell but you can't build your string at the same time. What I mean is this:
This is legal:
Read more →
TechNet Webcast: Authoring Reports in SQL Server 2000 Reporting Services – Level 200
April 1, 2004
10:00 AM - 11:30 AM Pacific Time
Jason Carlson, Product Unit Manager SQL Server, Microsoft Corporation, Doug Harts, Cizer Software
Read more →
Duane Dicks has a script that can display an analog clock in Query Analyzer. Make sure your results are in text and your font is Courier.
Read more →
I attended the SQL Server Reporting Services event yesterday in San Diego. I hadn't downloaded the beta version of it, so this was my first look at the product. I was impressed with it.
Read more →
MS updated SQL Server 2000 Books Online again:
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
Legacy Comments
DavidM
2004-01-21
re: SQL Server Books Online January 2004 Update Thanks Tara!
Marcus Tucker
2004-01-24
re: SQL Server Books Online January 2004 Update Thanks for the heads-up!
Read more →
This webcast wouldn't benefit me (I'm a DBA), but... MSDN Webcast: Microsoft Tools for .NET Performance Tuning
1/28/200411:00AM-12:30PM Pacific Time, US & Canada (GMT-8)David McKinstry, Senior Consultant, BORN Applications are usually developed with specific performance and scalability requirements in mind.
Read more →
There are several things that a DBA sets up in a production environment, one of these things is rebuilding the indexes. This is done with DBCC DBREINDEX. Some systems can not afford the locks that are held for long periods of time with DBCC DBREINDEX so they use DBCC INDEXDEFRAG instead.
Read more →