Interviewing
How should you interview for that new DBA job? What is appropriate and what should you leave out? Steve Jones shares some advice on interviewing that has helped him in his career.
OPENROWSET function in SQL Server 2005
mong other enhancements in SQL Server 2005, enhancements were made to the OPENROWSET function. This article illustrates BULK operations of the OPENROWSET function.
Microsoft Reporting Services 2005 Features and Enhancements
Reporting Services was one of the most popular add-ons to SQL Server 2000 and the next version has been greatly improved. Author Kamran Ali brings us a look at some of the new features and enhancements in this platform.
Transact-SQL in 2005
The March issue of the SQL Server Standard is now available for purchase, download, and should arrive in your mailbox any day. Check out the Table of Contents and read the editorial.
SQL Server Redundancy for SMBs
Building a highly fault tolerant and available SQL Server is expensive and difficult. This brings about unique challenges for small businesses who often lack the resources of large enterprises. Bilal Ahmed and Shivan Bindal discuss the various ways of building redundancy and the challenges of each.
The Dodgy GO Statement
Do you really understand what happens when you create a stored procedure? What if you have some extra code in your batch? This is an interesting article that shows an interesting effect of creating a stored procedure and where your GO statement is placed.
Microsoft Certification Second Shot Exam Offer Details
Now, you can get a free second shot at any Microsoft Learning IT Professional, Developer, or Microsoft Dynamics (formerly Microsoft Business Solutions) exam.
DTS and Global Variables
SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.
Boost Performance and Reduce Code Use With SQL Server Aggregate Functi
This article will acquaint you with aggregate functions such as MIN, MAX, COUNT, and AVG, which easily let you perform tasks that you may have thought needed extensive programming codes to accomplish.
Using the Distributed System Designers to Visually Design and Validate
he purpose this lab is to illustrate the benefits of the Distributed System Designers available in Whidbey to application architects, operations teams, and developers. These designers help application architects and developers construct service-oriented applications and prepare them for deployment in a target datacenter modeled by operations.
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers