Additional Articles


External Article

SQL Server 2005 Part 1 - Security (Authentication)

In this installment of our series covering new and improved functionality of SQL Server 2005 Beta 2, we will focus on the topic of security, which has been becoming increasingly prominent among the issues on every database and system administrator's agenda. A new approach to software development started with the Trustworthy Computing initiative launched in early 2002, necessitated by the growing number of exploits directed at the Microsoft operating system and applications, resulted in a "secure by default" product with highly customizable security features further increasing the degree of protection. We will start with the features related to authentication (the process of identifying logins connecting to the SQL Server and users accessing databases), and continue with authorization (determining the level of permissions granted once the initial connection is established) and encryption in the future articles. In particular, we will cover here, password policy implementation and management as

2005-02-01

5,709 reads

External Article

Connect to Lotus Domino using SQL Server Linked Server

Many Enterprises create and maintain applications that reside on "IBM Lotus Domino Server." Since the Lotus Domino server has the capability of handling applications and messaging, it has become a prime requirement for a SQL Server DBA to cross- reference data or import and export data to and from the Domino database and SQL Server databases. In this article, I am going to discuss how to use SQL Server Linked server to connect to databases that reside on the Lotus Domino server. The steps involved in connecting to the Lotus notes mail server database can be used for connecting to other databases that reside in "Lotus Notes Domino" server.

2005-01-31

2,430 reads

Technical Article

What's New and Different for the Access Developer Moving to SQL Report

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

Technical Article

Microsoft SQL Reporting Services – Running a Report from the Command L

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

Blogs

Using T-SQL Snapshot Backup - Are Snapshots Backups?

By

Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...

Developer Q&A: Dika Fei of Jelly Pixel Studio

By

"Let me know where you get your magic pixie dust from!"

A New Word: Flashover

By

flashover – n. the moment a conversation becomes alive and real, when a spark...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

It's Time to Play

By Ryan Booz

Comments posted to this topic are about the item It's Time to Play

Call Dates Effective Range

By Yash34

Hi Everyone, I have the data in the below form : Desired output: Here...

Visit the forum

Question of the Day

Synapse Analytics History III

What was the originally name of the appliance that eventually became Azure Synapse Analyics?

See possible answers