Additional Articles

All authors

External Article

Controlling Execution Plans with Hints

The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time. Grant Fritchey, in a chapter from his highly acclaimed book, explains further.

2009-11-25

3,275 reads

External Article

Using the SQL Server Analysis Services (SSAS) Deployment Wizard

I have to deploy my SQL Server Analysis Services project to a test server then to a production server after testing is completed. For both of these deployments I need to provide an installation program. I am not allowed to access either of these servers. For my own testing I can deploy my project using Business Intelligence Development Studio (BIDS) and this works great. How can I create an installer that my IT team can use to perform the deployment?

2009-11-25

2,137 reads

Technical Article

Installing SQL Server 2008

The installation process for SQL Server 2008 has many different options. These options allow you more control over your SQL Server Instance configuration. Having this additional control allows you to set up your SQL Server 2008 instances out of the box with the appropriate configuration, like directory structure, accounts, etc. In this article I'll walk you through the SQL Server installation process.

2009-11-24

3,680 reads

Technical Article

Building Windows Azure Cloud Service Applications with Azure Storage and the Azure SDK

Windows Azure and Azure Storage offers a new scalable and robust architecture that borrows much from the common feel of ASP.NET applications but brings plenty of new features as well. This paradigm shift from what has become traditional client-server architecture will offer new options to developers and headaches alike. While "the cloud" is not intended to be the answer for all applications and situations, it can only be a potential answer (another "tool" in the proverbial "tool belt") if you have at minimum a general understanding.

2009-11-23

1,893 reads

External Article

Managing Transaction Logs in SQL Server

The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.

2009-11-23

4,186 reads

External Article

SQL Server Security Audit Report

If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.

2009-11-20

3,602 reads

All authors

Blogs

The end of an era – why I chose not to renew my MVP

By

Two years ago, two things happened within a few days of each other. I...

PowerShell Strikes Back: A New Script

By

This is it. The final chapter of PowerShell Strikes Back. Over the past four...

Claude Desktop

By

Claude is more than a chat window. The desktop experience includes structured workspaces, generated...

Read the latest Blogs

Forums

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Unraveling the Mysteries of the...

QUOTENAME Behavior

By Steve Jones - SSC Editor

Comments posted to this topic are about the item QUOTENAME Behavior

Running script without having permission to Function

By Reh23

Good Morning. I have a T-SQL Script which has been developed to execute a...

Visit the forum

Question of the Day

QUOTENAME Behavior

I use QUOTENAME() like this in code? 

DECLARE @s VARCHAR(20) = 'Steve Jones'
SELECT QUOTENAME(@s, '>')
What is returned?

See possible answers