Aliasing columns in a SELECT statement example
SQL allows you to create custom column names for the query results and we look at how to use an alias for column names.
SQL Server, T-SQL, Development, DBA and Career Resources
Human Created Content by Industry Experts for Developers, DBAs and Analytics Professionals
SELECT with WHERE and ORDER BY
We will look at a SQL SELECT statement where we using a WHERE clause to filter and ORDER BY to sort the results.
SELECT command for SQL Server Tutorial
In this tutorial we cover the SELECT command in SQL Server and how this can be used to construct queries.
SQL Server Differential Backups
Learn how to create differential backups to capture only the most recent changes since the last full backup.
SQL Server Transaction Log Backups
This section covers different ways to create transaction log backups for a SQL Server database.
Introduction to Windows PowerShell for the SQL Server DBA Part 2
In Part 1, we introduced Windows PowerShell, cmdlets, aliases and how we can take advantage of help available. To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.
How to create indexes on computed columns in SQL Server
In my recent article Using Computed Columns in SQL Server with Persisted Values I discussed how to create computed columns to improve performance in specific scenarios. In order to achieve maximum performance through computed columns one very important a
Automate SQL Server Database Mirroring Failover
In a previous tip on Database Mirroring Automating Failover for Multiple SQL Server Databases, you've seen how you can failover all of the databases in a mirroring session if one database fails over. However, what happens if you don't have a witness serve
SQL Server 2008 Upgrade Testing at the Microsoft Technology Center
It has been a year since SQL Server 2008 was launched and like many other companies, my company is also trying to upgrade all the major production database servers from SQL Server 2000 to SQL Server 2008. In order to build a more accurate Project Plan, w
SQL Server stored procedures to page large tables or queries
I need to query a large amount of data to my application window and use paging to view it. The query itself takes a long time to process and I do not want to repeat it every time I have to fetch a page. Also, the number of rows in the result set could b
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2
Windows Server 2008 has a lot of differences from its previous versions and one of them is the clustering feature. How do I go about building a clustered SQL Server 2008 running on Windows Server 2008?
Requesting and researching SQL Server enhancements with Connect
A colleague wanted to know a way to make it easy to write stored procedures that reference objects in a different database when the name of the databases might change. For example, when the code is moved into production. He couldn't find a way and neithe
SQL Server TSQL Debugger in SQL Server Management Studio
If you recall your days working with SQL Server 2000, you would remember debugging a routine (Stored Procedure, UDF and trigger) in Query Analyzer, as a debugger tool was available with it. This was moved to Visual Studio for SQL Server 2005, but it is ba
How to find out what SQL Server rights have been granted to the Public role
One of the first security issues that forced adoption of SQL 2005 SP3 came in December 2008, when news broke that a vulnerability to Microsoft SQL Server could be exploited via the sp_replwritetovarbin stored procedure. This entire situation started me t
How to eliminate SQL Server security issue caused by sp_replwritetovarbin
The February 2009 Microsoft Security Bulletin included an updated Executive Summary (MS09-004) referring to a highlighted vulnerability with Microsoft SQL Server allowing an authenticated user to escalate privileges to those of SYSTEM, thereby taking cont
Using schema binding to improve SQL Server UDF performance
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UD
SQL Server CLR function to concatenate values in a column
In this article we look at how to write a concatenate function using the SQL Server common runtime language or CLR.
Introduction to SQL Server 2008 Report Builder 2.0
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples? What is new with Report Builder 2.0? How does the new interface look? What is the learning curve with this tool?
SQL Server Encryption Key Management between Dev, Test and Prod
The company I work for has decided to use the encryption technology available in SQL Server 2005. We have almost everything ironed out except for which keys to use in the development, testing, and production environments. Should we use one key for all thr
Move a SQL Server Database Without Losing Settings
I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1
In a previous tip on SQL Server 2008 Installation Process, we have seen how different SQL Server 2008 installation is from its previous versions. Now, we have another challenge to face: installing SQL Server 2008 on a Windows Server 2008 Cluster.
SQL Server Full Backups
In this section we cover how to create full database backups using either the SSMS GUI or using T-SQL code.
Types of SQL Server Backups
In this tutorial we look at the different types of backups that can be created for SQL Server.
SQL Server Bulk-Logged Recovery Model
The bulk logged recovery model let you minimize the use of the transaction log and allows for several types of database backups.