SQL Server 2008 New DATETIME DataTypes
SQL Server 2008 introduces four new DATETIME datatypes as well as new DATETIME functions.
2007-12-11
3,145 reads
Additional Articles
Relational Databases 101
In this sample chapter, William R. Vaughn gives you a kick-start on designing relational databases that can perform better, be easier to maintain, and be more successful thanks to a combination of formal rules and informal suggestions to normalize your database.
2007-12-10
3,397 reads
TSQL Regular Expression Workbench
This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.
2007-12-10
4,542 reads
Best Practices for Credit-Card Software
Visa has developed Payment Applications Best Practices and will begin implementing mandates concerning them
2007-12-07
3,551 reads
CLR Inside Out: Writing Reliable .NET Code
When we talk about something being reliable, we're referring to it being dependable and predictable. When it comes to software, however, there are other key attributes that must also be present for the code to be considered reliable.
2007-12-07
2,581 reads
Why store sensitive data if you don't have to?
Storing sensitive data in your database leads to security risks. Learn how not storing sensitive data indefinitely is a form of data protection.
2007-12-07
2,968 reads
Moving the tempdb database
Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted.
2007-12-06
3,660 reads
2007-12-06
2,678 reads
SQL Server Reference Guide
Buck Woody's SQL Server Reference Guide is your "one-stop shop" into the world of Microsoft's SQL Server, providing you with the information you need to manage and program SQL Server.
2007-12-06
4,623 reads
File Management with Scripting Object
Once you get familiar with the File Scripting Object (FSO), managing files in Access is not so bad--getting started is the painful part. To help you along, this month's download includes sample code for both Access (early bound) and VB Script (late bound).
2007-12-05
4,203 reads
Blogs
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
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...
Forums
Alamat BCA KCP Gudang Peluru Telp:0821°8200°233
Telp/Wa 628218200233 Komp, Jl. Gudang Peluru Raya Jl. Kp. Melayu Besar Blok A No....
Alamat BCA KCP Bulevar Hijau Telp:0821°8200°203
Telp/Wa 628218200203 Ruko Sentra Niaga 2, Jl. Harapan Indah Raya No.1A Blok SN-2, RT.001/RW.024,...
Alamat BCA Rukan Patria Telp:0821°7555°651
Telp/Wa 628217555651 Rukan Patria Park, Jl. DI. Panjaitan No.6 RK 05, RT.6/RW.11, Cipinang Cempedak,...
Question of the Day
PostgreSQL psql Meta Commands: Tables
Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?
See possible answers