(W. Jason Gilmore and Bob Bryla) Before the database can allow a person or an application access to objects or privileges, it must authenticate the person or application; in other words, the identity of who is attempting access to the database needs to be validated.
Other News
SQL CLR Integration in SQL Server 2008
(Paul Kimmel) Google is a great tool for finding information on the Internet. For developers Google (or Bing) are great tools for finding blogs that describe how to employ technical solutions. The biggest challenge is finding the correct and a complete solution. It is pretty straight forward to find
How to read an XML file in PowerShell 2010
(Vijai Anand) In this article we will be seeing how to read an xml file in powershell 2010.
IBM Cognos Proven Practices: Working with Prompt Parameters in the Adaptive Application Framework
(Simon Evans) Recommendations and tips on using prompt parameters in the IBM Cognos Analytic Applications. Filter structures in the warehouse model, their use by Adaptive Analytics, and report manager controls are discussed.
Custom sp_start_job to delay next task until SQL Agent Job has completed
(Kun Lee) The system stored procedure sp_start_job is a very useful T-SQL command that starts a SQL Agent job. The problem with this is that it starts the job and it doesn’t wait until the job is finished and sometimes I want to start a job and wait until the job is finished and move on to another j
Denali Includes Sequences
Featured White Paper(s) VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more) Featured Script admin script – change the SID of a login without loss of security settings To avoid problems with orphaned users when you need […]
Are YOU Headed to the Cloud?
New Fireside Chat – SelecTViews SQL Server 2011 upcoming features, SQL Server tip, recent news and more. [Watch the Show Here] Featured White Paper(s) An Introduction to Workload Tuning Workload Tuning is just what it sounds like: tuning the performance of all processes that comprise a database workload in one… (read more) Free On-Demand Webcast: Do It Right: Best Practices […]
A step by step guide in designing BCS entities by using a SQL stored procedure
(Jyoti Pawan Saikia) In this article, we will see how to design a SharePoint BCS entity from a SQL stored procedure that takes some inputs and returns a list of records. The scope of the article is to show the use of OOB features provided by SharePoint Server and SharePoint designer to achieve this.
Storing TSQL Queries in a table without losing the formatting
(Jacob Sebastian) One of the applications we worked on recently had to deal with storing TSQL queries in a table and executing them based on some business logic. It was not a very complicated project, but the development team had a tough time with the formatting of the queries stored in the table. T
Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective
(Michael Asher) I once walked into a bar, and saw two construction workers pounding each other to a pulp. The argument was over what was the better tool—a hammer or screwdriver. I feel a similar sensation when I see SQL developers arguing over whether to use natural or surrogate keys.