DB Ghost Packager
DB Ghost BUILDS, COMPARES and SYNCHRONIZES your SQL Server databases. It guarantees database integrity by building databases directly from your source control system.
2006-02-23
3,012 reads
Articles
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.
2006-02-23
10,982 reads
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.
2006-02-23
2,688 reads
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.
2006-02-22
19,819 reads
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.
2006-02-22
7,105 reads
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.
2006-02-21
6,015 reads
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.
2006-02-21
11,696 reads
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.
2006-02-21
3,274 reads
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.
2006-02-20
20,433 reads
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.
2006-02-20
2,951 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat BCA KCP Metro Pasar Baru Telp:0821°8200°203
Telp/Wa 628218200203 Gedung Metro, Jl. Samanhudi No.103 Lt. Dasar No. 101, 102, Ps. Baru,...
Alamat BCA KCP Kyai Caringin Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Balikpapan No.21 A-B, RT.9/RW.6, Petojo Sel., Kecamatan Gambir, Kota Jakarta Pusat,...
Alamat BCA KCP Tanah Abang Blok A Telp:0821°7555°651
Telp/Wa 628217555651 Pasar Regional Tanah Abang, Kios No.F-081 Blk A Basement I/G-063, F-080, Kp....
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers