| |
 = Members-Only  = Registered Guests
[Oracle] [SQL Server] [XML] [Home]
These articles are always free for members, but are currently available to registered guests as well. This list of articles
changes daily.
Discuss | See Current Member Articles
Register for FREE Access to These Articles.
When you register, you can choose to be a registered guest and have access to these articles,
or you can become a dues-paying member, with a great-many benefits, and get full access to everything on SSWUG and
many other benefits.
| Compression Strategies - (Sunil Agarwal) In the previous blogs, I had described the data compression in SQL Server 2008 and its implications on CPU and IO. One of the question that keeps coming up is ‘Should I compress m... [more]
|
| Determining SET Options for Current Session - With each session that is made to SQL Server the user can configure the options that are SET for that session and therefore affect the outcome of how queries are executed and the underlying behav... [more]
|
| SQL Server Checkpoint I/O Behavior - (Linchi Shea) Andrew Kelly in a recent post here advised visiting/revisiting the SQL Server I/O basics, and I completely agree. A firm grasp of the basics can make it easy to understand some syst... [more]
|
| How secure is your SQL Server network design? - (Kevin Beaver) No matter how you've hardened your SQL Server systems, a weak network design can still undermine the best of database security controls. It's easy to assume that all's well inside ... [more]
|
| Data Collector in SQL Server 2008 - This is a wonderful new feature in SQL Server 2008. Data Collector in SQL Server 2008 is a component that is installed in a SQL instance and which can either be configured to run on your defined ... [more]
|
| Query Execution Statistics - (Greg Larsen) In my last article I talked about tracking performance of TSQL statements (http://www.sql-server-performance.com/articles/per/tsql_statement_performance_p1.aspx). In that article ... [more]
|
| Using Included Columns in SQL Server 2005 - (Kathi Kellenberger) One of the new features found in SQL Server 2005 is the ability to add additional columns, called Included Columns, to a non-clustered index. This article will explain the ad... [more]
|
| Completing the Introduction to Transact-SQL - (Barzan "Tony" Antal) In the first half of this series we learned the basics of Transact-SQL. In case you missed it, I strongly suggest you check it out before moving on with this segment. The pr... [more]
|
| BitMask Fields - This blog post is in response to one of the questions that we got from our reader. Here is the question:
“I’d like to hear your opinions on bitmask fields. I have found a lot of flames on usin... [more]
|
| The Web Assistant Wizard - (Buck Woody) In an earlier tutorial I explained a bit about database maintenance, and in another tutorial I showed you how to use a SQL Server Wizard to automate maintenance steps into a full mai... [more]
|
| SQLCMD utility in SQL Server 2005 - In one of our previous blog post, we had covered some of the command line utilities in SQL Server 2005. One of such utilities is SQLCMD. This is a replacement for the osql and isql command line u... [more]
|
| Rebuild indexes online with SQL Server 2005 - (Tim Chapman) Indexes are specialized data structures that operate on tables (and sometimes views) in the database engine used to aid in the searching for and sorting of data. Indexes are vital t... [more]
|
| Owner/schema qualifying object names - (Tibor Karaszi) It isn't easy to remember all the details regarding object/schema qualifying object names. There are many variables involved, such as:
--Version of SQL Server
--Qualifying th... [more]
|
| Data Encryption in SQL Server 2005 – Part I - (Muthusamy Anantha Kumar) Encryption is the key for data security. Sensitive data such as Social Security numbers, credit card numbers, passwords, etc. should be protected from hacking.
|
| Changing the owner of a database - (Louis Davidson) Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to c... [more]
|
| SQL Queries for Mere Mortals: Thinking in Sets - (John L. Viescas and Michael J. Hernandez) By now, you know how to create a set of information by asking for specific columns or expressions on columns (SELECT), how to sort the rows (ORDER BY), ... [more]
|
| SQL Server Security Model - (Gregory A. Larsen) Windows Authentication, SQL Server Authentication, Windows Groups, Database Roles, Schema, and Application Roles are all aspects used to manage SQL Server Security. So how do ... [more]
|
| SQL Server Indexes: The Basics - (Kathi Kellenberger) Indexes directly affect the performance of database applications. This article uses analogies to describe how indexes work. The estimated execution plan feature of the Query ... [more]
|
| Change Management - (Buck Woody) All technical professionals are concerned with performance, usability, maintenance and so on, but among technical professionals DBAs area some of the most paranoid, or at least they ... [more]
|
| Bring Array Mapping Capabilities to SQL - (Michael Sorens) SQL has been evolving—slowly—for over three decades, (see Wikipedia for a historical summary). While SQL in the hands of an expert is quite powerful, it's sometimes cumbersome co... [more]
|
| SQL Server Backup Types and Scopes - (Mike Chapple) One of the major advantages that enterprise-class databases offer over their desktop counterparts is a robust backup and recovery feature set. Microsoft SQL Server provides databas... [more]
|
| Successful Backup Messages No More... - (Andrew Kelly) How many times have you asked for a way to turn off the behavior in SQL Server that logs successful backup messages to the SQL Server Logs and to the Windows Application Event Logs... [more]
|
| SQL: Merge two 'history tracking' tables - (Alberto Ferrari) If you have two columns in a table that "remember" their old values in two different historical tables, as it is the case in AdventureWorks with EmployeePayHistory and EmployeeD... [more]
|
| Execute SQL statements in Integration Services - (Tim Chapman) Executing SQL statements is one of the easiest and most common tasks that occur in SQL Server 2005 Integration Services (SSIS). This tutorial walks you through the process of adding... [more]
|
| Did You Know? What's a $ Worth? - (Kalen Delaney) No, I'm not talking about US dollars, which are not worth much at all these days. I'm talking about the $ used in a particular construct in SQL Server 2005 to get information abou... [more]
|
| SQL Server Backup Types - (Eric Johnson) Welcome to this new series -- in this column, I hope to impart some quick, short tips that will help you make quick work of managing and administering your SQL Server databases. Fi... [more]
|
| NULLs Part II: NULL usage of NULL - (James Luetkehoelter) In my previous post on NULLs I discussed (rather replied to Hugo Kornelis) some more academic concepts and definitions when it comes to NULL. It is very sad for me to admit ... [more]
|
| Preparing for the M70-444 Exam - (Gregory A. Larsen) Are you considering becoming a Microsoft Certified DBA? Where do you start? How do you prepare for getting certified? There are lots of different methods to prepare for the ex... [more]
|
| How to rewind a SQL Server - (Brian Donahue) I work for a company that sells software. And SOME people, because of their untrusing nature, need to be convinced that the software that we want to sell them actually works. This... [more]
|
| Pivots with Dynamic Columns in SQL Server 2005 - (Andras) Pivots in SQL Server 2005 can rotate a table, i.e. they can turn rows into columns. PIVOTs are frequently used in reports, and they are reasonably simple to work with. However, I've seen... [more]
|
| SQL Refactor and the Table Splitting Headache - (András Belokosztolszki) When a database table becomes unmanageably large, it is time to break it up using horizontal or vertical partitioning. After horizontal partitioning, you will have severa... [more]
|
| String Functions: The .Properties Function - (William Pearson) In this, the first half of a two-part article, we will expose another useful function within the MDX toolset, the .Properties function. The general purpose of the .Properties fu... [more]
|
| Checklists - (Allen White) One of the first things a pilot is taught is to use checklists. Everything from preflight to tie down after your return is covered in aviation checklists. Did you check the thicknes... [more]
|
| Setting Up Delegation for Linked Servers - (Gregory A. Larsen) If you are like most, you probably have looked into using Windows Authentication as a method to authenticate users to SQL Server 2005. Windows Authentication is the preferred ... [more]
|
| TEXT in ROW option in SQL Server - MS SQL Server allows us to store large variable length data in text, ntext or image columns. One can store up to 2GB worth of non-Unicode character or binary data in text columns. Sometimes quer... [more]
|
|
|
|
|
|
