Articles

External Article

Maintaining SQL Server default trace historical events for analysis and reporting

I often see questions online where someone wants to find out who started a trace, when tempdb last had an autogrow event, or when the last full backup for master occurred. Since these and other events are captured by the default trace, but the default trace only keeps five 20MB rollover files by default. This means that the event you are after may no longer be there, depending on how long ago it was and how busy your server happens to be. Unfortunately, people often need to find this information well after the fact.

2012-05-30

2,914 reads

Technical Article

Database Continuous Integration 101

We talk a lot about continuous integration here on the Atlassian Dev Tools blog, and many readers are bonafide CI gurus. Now that you are integrating your application code, test code, config files and deploy scripts, are you ready to take it to the next level? An increasing number of engineering shops are starting to bring the continuous integration discipline into their database development.

2012-05-29

2,744 reads

External Article

Simple step by step process to import MS Access data into SQL Server using SSIS

Sometimes we need to import information from MS Access. We could use the Microsoft SQL Server Migration Assistant, but sometimes we need to add custom transformations and it is necessary to use more sophisticated tools. In this tip, we are going to walk through step by step how to migrate a MS Access table to SQL Server using SQL Server Integration Services (SSIS).

2012-05-28

4,481 reads

External Article

Backups, What Are They Good For?

We've heard the confessional story from Pixar that Toy Story 2 was almost lost due to a bad backup, but sometimes there is no 'almost'. Grant Fritchey casts a sympathetic eye over some catastrophic data losses, and gives advice on how to avoid what he has termed an RGE (résumé generating event).

2012-05-25

3,824 reads

External Article

SQL Server 2012 Integration Services - Package and Project Parameters

In SQL Server 2012, Microsoft introduced SQL Server Data Tools to accommodate the dynamic nature of SSIS constructs in the form of package and project parameters. This approach lets you combine multi-package projects into a single unit, eliminating the possibility of breaking dependencies between parent and child packages during subsequent deployments.

2012-05-24

2,499 reads

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