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
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
PT Bank Central Asia TBK. Tlpn/wa:085373737551
Jl. Insinyur H. Juanda No.54, RT.001/RW.001, Margahayu, Kec. Bekasi Tim., Kota Bks, Jawa Barat...
BCA KCU THAMRIN. Tlp:(+62) 8218168235
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Cikarang Tlpn/wa:085373737551
Ruko Cikarang Plaza, Jl. Yos Sudarso No.5 Blok B, RW.6, Cikarang, Kec. Cikarang Utara,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers