(Andre Vigneau) Haven’t you dreamt about a way to prevent the change of some parameters by some people that still have system administrators privilege and that can seriously put in danger your SQL Server and applications running on them. I know I have this nightmare. (R)

(Bogdan Crivat and Jamie MacLennan) Microsoft Excel becomes more and more versatile with each release and solves a wider variety of business needs. Its flexibility and programmability let you integrate different technologies to better understand and process the data in your spreadsheets. From its in

(ORCS Webteam) Sometimes you cannot log in locally to a SQL server, so you need to make a remote connection. Usually this is over the Internet using TCP/IP. Tools that you can use to connect to a remote SQL server are Enterprise Manager, Query Analyzer, or even through code. Enterprise Manager and Q

(Narayana Vyas Kondreddi) The ERP vendor, a global provider of customized enterprise solutions developed Aircraft maintenance solutions. Its Enterprise Asset Management for aviation, consists of modules covering all areas of enterprise management for the fixed wing aircraft and helicopter maintenanc

(Brad M. McGehee) There are a lot of DBAs who want to learn how to cluster SQL Server. There are also a lot of companies who may have a production SQL Server cluster, but not a test SQL Server cluster. In both cases, the reason for this is that clustering hardware is very expensive, and setting

(Rahul Sharma) Have you ever had to access data from either a non-SQL Server source or from a separate SQL Server database (either residing on the same instance or on a separate instance)? Rahul Sharmas discusses how to bridge the gap between two different SQL Server instances or between heterogenou

(Gregory A. Larsen) In my first article in this series, I discussed how to store different statuses in a single integer column. In this article, I will expand on the topic of using integer columns for storing statuses and will discuss how to update the integer status column to change or remove a

(Chris Cathers) I am in a unique situation where I work. I ware two hats. Of course, I’m the local DBA doing everything SQL, from administration to development. But, I also ware the MCSE hat. As such, I often get asked many various things from my CIO. Everything from “Can you fix the email and give

When working with parameterized SQL Server stored procedures by using a data access technology such as ActiveX Data Objects (ADO), the members of the Parameters collection of the ADO Command object can be referenced by using either the name of the parameter or its numeric index into the Parameters c

(James Crowley) Trees can be an intuitively simply way of organising large amounts of information. We’re exposed to them everywhere – from directories in file systems and categories in a web directory to hierarchies in organisations and family trees! Something like XML handles hierarchical data well