SQLServerCentral.com Content tagged Blogs, SQL Server

Vote for Me for a PASS SQLRally Precon on SQL Server Security

Thu, 28 Oct 2010 06:00:00 UT

Unless James Bond is in the picture, security is usually not a sexy topic. However, we all lament the lack...

SQL Saturday 52 Recap

Fri, 01 Oct 2010 06:00:00 UT

I spent this past weekend traveling to and attending SQL Saturday Colorado in the outskirts of Denver. This was the...

SSIS: Conditional File Processing in a ForEach Loop

Thu, 26 Aug 2010 06:00:00 UT

I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules...

An Un-CATCHable Error?

Mon, 29 Mar 2010 06:00:00 UT

I've been using the scripting tools in SSIS for some time, but I came across something today that I can't...

Identity Values – Two things to know

Fri, 08 Jan 2010 07:00:00 UT

I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...

You pulled BUILTIN\Administrators, but are you auditing?

Thu, 10 Dec 2009 07:00:00 UT

The conversation on local administrators having rights in SQL Server has proven to be interesting and at times entertaining. My...

Please, Sir, I want some more… orphaned database users.

Fri, 04 Dec 2009 07:00:00 UT

Permissions on our development servers are considerably less stringent than elsewhere with developers afforded the freedom to restore backup’s ad-hoc....

Linear Gauge Control: A Practical Use

Wed, 02 Dec 2009 07:00:00 UT

SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...

Fundamentals of Storage Systems – Capturing IO Patterns

Fri, 27 Nov 2009 07:00:00 UT

We often take the advice given to us on forums or in articles at face value. Even though the authors...

How to Create a Reporting Services 2005/2008 Template

Tue, 24 Nov 2009 07:00:00 UT

At most large companies one business requirement is that all reports have the same look and feel. This may vary...

Why We Recommend Against xp_cmdshell

Thu, 19 Nov 2009 07:00:00 UT

Every so often I see a post in a forum or on Twitter about the use of xp_cmdshell. Usually it is someone looking for...

SQL University: Multiple Paths and Ownership Chaining

Tue, 03 Nov 2009 07:00:00 UT

Welcome back to our last class this term on security in SQL Server here at SQL University. According to the syllabus,...

SQL Server Legend – Data Files and Threads

Tue, 20 Oct 2009 06:00:00 UT

Someone was asking about using multiple data files recently to try and increase performance. I had answered that unless you...

MSDE – Database Size Limit

Tue, 13 Oct 2009 06:00:00 UT

Most of you are aware that the Microsoft SQL Server 2000 Desktop Engine (MSDE) limits database size to 2 gigabytes. ...

Red Gate's SQL Data Generator

Tue, 06 Oct 2009 06:00:00 UT

I'm reading SQL Server MVP John Magnabosco's new e-book, Protecting SQL Server Data, and he includes a database schema to...

Eliminating Empty Output Files in SSIS

Mon, 05 Oct 2009 06:00:00 UT

So you’ve got some packages that regularly extract data to one or more text files, but you know that from...

The old INNER JOIN syntax vs. the new INNER JOIN syntax

Thu, 01 Oct 2009 06:00:00 UT

I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...

Fundamentals of Storage Systems - The Basics of Spinning Disks

Mon, 28 Sep 2009 06:00:00 UT

Your servers are only as fast as the slowest part, hard drives. To feed other parts of the system we have...

Blobs and Filestreams

Thu, 24 Sep 2009 06:00:00 UT

In the next week or so I’ll be upgrading the SQL 2005 server that has the SQLSaturday database and I’m...

Windows Internal Database

Tue, 22 Sep 2009 06:00:00 UT

This past Friday I received a call from our systems team stating that they were running low on Disk Space...

SQL Server Job Trends on Graphs

Mon, 21 Sep 2009 06:00:00 UT

A colleague pointed out a site that collects a lot of job posting data and exposes graphs - so I've taken...

SQL Server 7.0 – Transaction Log Not Backing Up

Mon, 14 Sep 2009 06:00:00 UT

I have not worked with SQL Server 7.0 in a loooong time. So when I received a call from a...

Indexing HierarchyID

Thu, 03 Sep 2009 06:00:00 UT

The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...

There is no excuse

Fri, 21 Aug 2009 06:00:00 UT

I read Jack Corbett's blog entry,No Training Budget Still No Excuse, last week and thought it was excellent. In fact,...

Replication – Accommodating Application Inserts

Wed, 19 Aug 2009 06:00:00 UT

Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...

Adding Multiple Columns to a Table With a Single T-SQL Statement

Thu, 13 Aug 2009 06:00:00 UT

You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...

Scripting in SSIS

Fri, 07 Aug 2009 06:00:00 UT

Tim Mitchell presented at SQLSaturday #17 on Scripting in SSIS. I thought it was a really interesting presentation, and I’m...

Call For Speakers – SQL Lunch Live Meeting

Thu, 06 Aug 2009 06:00:00 UT

The Baton Rouge Area SQL Server User Group hosts Bi-Monthly Live Meetings that are 15-30 minutes long the consist of...