| |
 = 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.
| Using PowerShell and SQL Server Together - (Allen White) I've mentioned before my company manages trade shows, and we've got a series of web sites managed by an application which uses a different SQL Server database for each site, with a ... [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]
|
| Run The Same SQL Command Against All Databases - (Tim Ford) There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you ... [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]
|
| Storing Images and BLOB files in SQL Server - (Don Schlichting) This article explores the data types and methods used for storing BLOBs (Binary Large Objects), such as images and sounds, inside SQL Server. Legacy data types used in SQL Serve... [more]
|
| All About SQL Functions - (James Payne) In the last tutorial we left off with the SUM(column) function. In this article we will cover the remaining Aggregate Functions and the Scalar Functions. We might even make some fat... [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]
|
| 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]
|
| Tricks to increase SQL Server query performance - (Denny Cherry) Thanks to the natural language roots of the SQL language, writing queries has become extremely easy for just about anyone to pick up. But its simplicity also makes it easy to write... [more]
|
| SQL Server 2008 New DATETIME DataTypes - (Dinesh Asanka) SQL Server 2008 has arrived - not fully, but as a CTP version. Whenever you hear about new software, the first and most obvious question is “What are the new features?”. There ar... [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]
|
| UNIQUE Column with multiple NULL values - (Muthusamy Anantha Kumar) As you know, when you create a UNIQUE constraint on a nullable column, SQL Server allows only one NULL value, thereby maintaining the UNIQUEness. However, there are situ... [more]
|
| MERGE command in SQL Server 2008 - MERGE command (also known as UPSERT in Oracle circles) is nothing new to Oracle. It has existed since quite some time. We have also blogged about it on our site - including the enhancements to th... [more]
|
| Distributed databases in SQL Server 2005 - (John Charles Olamendy) An increasing number of applications require access to multiple databases located at different sites, perhaps widely separated geographically.
|
| Change Data Capture Feature in SQL Server 2008 - We have been blogging for quite some time now on the new feature sets of the upcoming release of SQL Server - SQL Server 2008. You can search for SQL Server 2008 on this blog and get to those pos... [more]
|
| The DBA's Toolbox (Part 1) - (Buck Woody) This guide, and indeed the entire InformIT.com site, is designed to help you succeed as a Database Technology Professional. I've got hundreds of articles here on concepts, processes ... [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]
|
| Viewing Partition Slice Information - (Chris Webb) The other week I discovered that it was possible to view the partition slice information discussed here using the DISCOVER_PARTITION_DIMENSION_STAT schema rowset. I've always thought... [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]
|
| Snapshot Reports I: Report Manager Perspective - (William Pearson) In the previous articles of this subseries, Black Belt Administration: Caching Options: Report Session Caching, and Report Execution Caching parts I and II, we discussed the fac... [more]
|
| Creating Custom Reports for SSMS - (Greg Larsen) With the release of SQL Server 2005 SP2, Microsoft added a new feature to SQL Server called “Custom Reports”. ). These RDL files are rendered as tabbed documents within SSMS. Report... [more]
|
| Logon Triggers - (Cristian Lefter) When I asked a friend from the SQL Server development team "what's the story behind Logon Triggers?" the answer was brief "Common Criteria compliance for SQL Server and nothing ... [more]
|
| Partitioning a SQL Server Database Table - (Mike Chapple) Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables onto separate filegroup... [more]
|
| Statistical Indexes - (Buck Woody) SQL Server 2000 and 2005 both use a "cost-based" optimizer to quickly locate data in its databases. I've mentioned the Query Processor in another tutorial, and in this tutorial I'll ... [more]
|
| Service Broker Advanced Basics Workbench - (Adam Machanic) In the first part of this workbench series, we covered the foundations: Setting up message types, contracts, queues, and services, and sending and waiting for messages. This secon... [more]
|
| Converting Access Queries to SQL Server - (Danny Lesandrini) In last month's article, I introduced a Microsoft Access Add-In I created some years ago, which I affectionately call the DataFast Utility. It includes a number of analysis too... [more]
|
| The GO command in SQL Server - The GO command in SQL Server is not a T-SQL command. It is a command that is recognized by the SQL Server utilities like osql or sqlcmd or the editors - Query Analyzer or SSMS. This just signal... [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]
|
| Documenting a Microsoft SQL Server database - This article describes how to document your Microsoft SQL Server database. The principles are similar for all versions of SQL Server, although SQL Server 2005 and above contain a number of neat e... [more]
|
| Geek City: Detecting Overflowing Columns - (Kalen Delaney) SQL Server 2005 allows rows to include variable length columns which do not actually fit in the maximum row size of 8060 bytes. I previously posted about row-overflow columns, and... [more]
|
| Little gems in SQL Server 2005 - (Tim Golden) I know it’s clear I don’t have all that much time for the “innovations” in SQL Server 2005, but there are two syntax additions which I’ve been yearning for for years. (Since I moved ... [more]
|
| sys.dm_exec_sql_text - (Louis Davidson) This dynamic management object returns the SQL that was saved when a query was executed. This is a very exciting and useful thing to have, as there are dynamic management views t... [more]
|
| Enhance Your Web Apps with T-SQL Tricks - (Andrew Bonslater) With all of the new functionality that's been released with T-SQL for SQL Server 2005, you now have more options that make performing complex tasks very simple with very few li... [more]
|
| Simplify SQL Server replication - (Michelle Gutzait) Have your replication design practices gotten out of hand? You can simplify SQL Server replication management and monitoring by reducing the number of publications and subscrib... [more]
|
| SQL Server 2008 and end user ad hoc reporting - (Andrew Fryer) In my opinion the weak link in reporting services is that there is no tool for information workers to design their own reports and so IT professioanls have to spend a lot of time d... [more]
|
| Migrating Access Apps to SQL Server - (Danny Lesandrini) Back in 2000 (remember Y2K?), Marc Israel started a series of Access articles on the theme: Migrate to SQL Server. Marc suggested several titles for the series but some of them... [more]
|
| What’s new in SQL 2008 Part 2 - (Don Schlichting) This article will highlight some of the new features and benefits found in SQL Server 2008. Some of the new features include Development changes, new Business Intelligence featu... [more]
|
| Information Schema and SQL Server 2005 - (Uday Denduluri) Information Schema is the part of the SQL-92 standard which exposes the metadata of the database. In SQL server a set of views are created in each of the database which exposes t... [more]
|
| How to get the name of the day of date - (Simon Sabin) Do you have a date and you want the day of the week but not the number but the name i.e. Monday, Tuesday etc. Well there are two functions that you can use with dates that can be us... [more]
|
| SQL Server 2005 Express: Beyond the basics - (Serdar Yegulalp) In my previous article about SQL Server 2005 Express Edition, I talked a bit about what the Express Edition was designed to address and how it eclipsed the SQL Server Desktop En... [more]
|
| What is your SQL Server backup strategy? - (Steven Warren) Most database administrators (DBAs) know what it’s like to be called away from home or dinner or even awakened in the middle of the night to answer a page or a cell-phone call con... [more]
|
| Reporting Services Crib Sheet - (Robyn Page and Phil Factor) SQL Server Reporting Services (SSRS) aims to provide a more intuitive way of viewing data. It allows business users to create, adapt and share reports based on an abs... [more]
|
|
|
|
|
|
