(Dino Esposito) Whether you’re a system administrator, a designer, or a developer, your job will be significantly affected by AJAX. Administrators have to ensure that the security bar is still high enough to face new types of possible attacks. Intranet administrators have to guarantee that JavaScrip
Other News
Setting Up Delegation for Linked Servers
(Gregory A. Larsen) If you are like most, you probably have looked into using Windows Authentication as a method to authenticate users to SQL Server 2005. Windows Authentication is the preferred and more secure method of connecting to SQL Server. If your goal is to use Windows authentication for eve
Synonyms in SQL Server 2005
(Keyvan Nayyeri) Naming conventions are always a big concern for developers whether they’re an application developer or database developers! Naming tables, columns, views, stored procedures and other objects in a database sometimes gets harder than what we think, especially when we’re working on mu
IDS Label-Based Access Control, a practical guide, Part 1: Understand the basics of LBAC in IDS
(Carmen K. Wong, Stan Musker, Manjula Panthagani and Joseph W. Baric, Jr.) Apply Label-Based Access Control (LBAC) to protect your data from illegal access, yet have the flexibility to allow users to restrictively access data. Create these and other LBAC solutions in this step-by-step guide based on
How to Corrupt a SQL Server 2005 Database
(Linchi Shea) How can you corrupt an online SQL Server 2005 database? Okay, why would you want to do that? Well, let’s say because you want to test out some DBCC commands.
Spool operators in query plan…
(Umachandar Jayachandran) I came across a question in the relationalserver.performance newsgroup where a customer was wondering about the spools seen in a recursive query execution plan. The query is shown below:
How MySQL executes ORDER BY
(Sergey Petrunia) In last couple of weeks there has been a tide of ORDER/GROUP BY-related optimization bugs, where I was the fixer or the reviewer. This wasn’t an easy job because there is no sane description of how GROUP BY/ORDER BY handling is supposed to work.
Informix DBA: IDS 11 Races Ahead
(Lester Knutsen) A lot has happened in the last month; I started this article on a plane trip to Beijing, China, and finished it after attending the IDS “Cheetah” T3 training at the IBM lab in Toronto, Canada. By the time you read this, IDS 11 (code-named “Cheetah”) will have been released. I though
Good Enough Upgrade Thoughts, SQL Agent, SQL 2005 Admin Tools
Featured Article(s) Understanding the SDLC Phases of a Software Project [Part III] This is the concluding part of this series that discusses the remaining SDLC phases and sums up what we have learnt so far in this series of articles on the standard SDLC phases in the life cycle of a Software Project. Watch Now: Using SQL Agent to Automate […]
Importing CSV Files, SQL Server Management Tools
Don’t Miss the Weekly SQL Server Show… Released on Fridays, available now. Watch it here. Featured Article(s) Importing a .csv File into SQLExpress Using Bulk Insert Have you wondered how to import text file data into SQLExpress without using DTS or SSIS? This article will show you a possible approach using the T-SQL Bulk Insert Command. Report Distribution Options Get […]