When a DBA is managing many different SQL Server boxes, it can be a tedious job to find the port numbers used by all of the SQL Servers. In this article, I would like to discuss several methods for finding the Port numbers used by SQL Server.
2005-01-28
1,942 reads
Microsoft SQL Server Reporting Services is a powerful new tool allowing developers to move reporting solutions online for truly global access. This paper explains the key advantages, similarities, and differences between Microsoft Access reports and Reporting Services reports for organizations considering migrating to Reporting Services. (22 printed pages)
2005-01-28
1,323 reads
SQL Server excels in many areas, including the tight integration of it's internal SQLMail system with Outlook and Exchange. But if you want to use another mail system, SMTP, Lotus Notes, or Groupwise, you are left to your own resources to configure your system. Fortunately new author Chris Shepherd has taken time to dig in and document how to get SQL Server to work with Novell's Groupwise mail system. Read about his setup and troubleshooting tips.
2005-01-27
7,945 reads
SQL Server 2000 Reporting Services is one of the most exciting new enhancements to SQL Server in quite some time. The addition of a robust and flexible reporting environment is something that most DBAs and developers are pleased to see. New author Andy Leonard brings us a technique for scheduling the execution of a report asynchronously, so your application or system can get back to work while the report is being generated.
2005-01-26
9,736 reads
I recently ran into a need to run a report in SQL reporting services from the command line. The Report took four (4) input parameters and I had to export it to Microsoft® Excel and save it to disk. I had to rummage through the product documentation and the Microsoft® SQL Reporting newsgroup to get this right. For running reports from the command line, SQL Reporting services provide a utility called “rs utility”.
2005-01-26
2,602 reads
How many times have you had to estimate space for a new SQL Server database? How much time did you spend on it? Was it a thumb-in-the-wind guess or did you actually examine a schema and calculate some values. If you have asked someone to estimate the space their database will need, they probably guess more than compute, but now Andre Vigneau gives us an easy way we can teach those developers to put some thought into the process.
2005-01-25
11,840 reads
Detailed error reporting from stored procedures can be extremely valuable when debugging problems in your application. I will share different levels of detail that you can build into your stored procedures. You can choose the level of detail appropriate for your situation.
2005-01-25
2,903 reads
SQL Server does a wonderful job of tuning itself, selecting the optimum query plans and in general performing very well under a variety of conditions. That does not mean the a good DBA cannot add value by setting up the system and ensuring the optimizer receives the information that it needs. New author Gordon Pollokoff brings us a short case study from a project he as recently involved in where a new application required a bit of tuning.
2005-01-24
12,484 reads
SQLServerCentral.com is having a sale. Support the site and get some valuable information for your library.
2005-01-24
2,626 reads
Table partitioning is a powerful new feature in SQL Server 2005. It is primarily a manageability feature, but my interest here is in the performance and scalability of table and index partitioning for use with very large tables.
2005-01-24
1,462 reads
By Steve Jones
We’re a week late, once again my fault. I was still coming out of...
By Steve Jones
I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...
By Steve Jones
I’m in the UK today, having arrived this morning in London. Hopefully, by this...
Comments posted to this topic are about the item Learning From Breakage
Comments posted to this topic are about the item Python in Action to Auto-Generate...
Comments posted to this topic are about the item Adding and Dropping Columns I
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GOI decide to add two new columns for the StateProvince and Country. What code should I use? See possible answers