-
SQL Server database replication tutorial
SQL Server replication involves some decision making on the part of the DBA. What's the best method for your SQL Server environment -- snapshot, merge or transactional replication? Are there any ar...30 Oct 2008
-
New security features in SQL Server 2008 leave some work for you
Microsoft has certainly taken security in SQL Server 2008 to a higher level. But as IT security expert Kevin Beaver points out, just because SQL Server 2008 is secure to begin with, that doesn't me...27 Oct 2008
-
How to disable the Shrink Database task in SQL Server 2000 and 2005
Routinely shrinking your SQL Server database is not always the best strategy for saving space, and when a DBA realizes that, the next step is to figure out how to kill the automatic task. SQL Serve...23 Oct 2008
-
New datetime data types in SQL Server 2008 offer flexibility
The fifth and final tip in this series on SQL Server datetime values outlines four new data types supported by T-SQL in SQL Server 2008. SQL Server expert Robert Sheldon walks you through how to us...21 Oct 2008
-
SQL Server out of memory: Troubleshoot and avoid SQL memory problems
Ever get a SQL Server out of memory error message? If so, you know that most often this indicates a problem with the system, not simply a memory shortage. SQL Server MVP Denny Cherry shares methods...16 Oct 2008
-
Basic objects of T-SQL in SQL Server 2008
Discover the basic objects that drive T-SQL in SQL Server 2008 in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide." Author Dusan Petkovic discusses how literal values, delimiters,...15 Oct 2008
-
SQL Server 2008 function types in T-SQL
Functions in Transact-SQL can be either aggregate functions or scalar functions. This excerpt from "Microsoft SQL Server 2008: A Beginner's Guide" describes both and details the many numeric funct...15 Oct 2008
-
Additional T-SQL operations in SQL Server 2008
Learn how scalar operators, global variables and NULL values can be used in Transact-SQL, with examples to gauge your understanding of SQL Server 2008 objects and operators, in this book excerpt fr...15 Oct 2008
-
Using T-SQL data types in SQL Server 2008
Learn the numerous data types used in SQL Server 2008's Transact-SQL language in this excerpt from "Microsoft SQL Server 2008: A Beginner's Guide."15 Oct 2008
-
SQL Server 2008 Integration Services delivers new features
Integration Services in SQL Server 2008 provides three new features for better performance and ease of use for administrators and developers. In this tip, SQL Server BI expert Mark Kromer discusses...14 Oct 2008
-
Tips for tuning SQL Server 2005 to improve reporting performance
There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific techniques.09 Oct 2008
-
Using DATEADD and DATEDIFF to calculate SQL Server datetime values
SQL Server DATEADD and DATEDIFF functions allow you to easily perform calculations such as adding or subtracting a time interval from a datetime value or for comparing two date/time values. SQL Ser...07 Oct 2008
-
Can I encrypt and restore a database backup in SQL Server 2005?
Discover the best solutions for encrypting, decrypting and restoring a database in SQL Server 2005.06 Oct 2008
-
SQL Server trigger vs. stored procedure to receive data notification
Learn why using a SQL Server stored procedures vs. a trigger can be a preferred method to retrieve data notification from a database field.06 Oct 2008
-
Storing and searching for image files in SQL Server
Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.06 Oct 2008
-
Licensing a standby server for SQL Server replication
Is a license needed for a standby server if it's used for SQL Server replication? Get that answer and a comparison of SQL Server log shipping to replication.06 Oct 2008
-
Manipulate column names in a SQL Server table
Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.06 Oct 2008
-
PASS
PASS03 Oct 2008
-
SQL Server errors, failures and other problems fixed from the trenches
SQL Server expert Matthew Schroeder gets down into the trenches to help resolve your SQL Server issues. Whether it's a failed cluster installation, a long-running stored procedure that causes a 3 a...02 Oct 2008