SQLServerCentral: Content tagged SQL Server, Blogs

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

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

By 2010/10/28 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,556 reads

SQL Saturday 52 Recap

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

By Tim Mitchell 2010/10/01 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,792 reads

SSIS: Conditional File Processing in a ForEach Loop

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

By Tim Mitchell 2010/08/26 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 7,574 reads

An Un-CATCHable Error?

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

By Tim Mitchell 2010/03/29 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 2,198 reads

Identity Values – Two things to know

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

By Steve Jones 2010/01/08 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,803 reads

You pulled BUILTIN\Administrators, but are you auditing?

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

By Brian Kelley 2009/12/10 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 2,096 reads

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

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

By jameshoward3 2009/12/04 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,660 reads

Linear Gauge Control: A Practical Use

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

By Patrick LeBlanc 2009/12/02 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,734 reads

Fundamentals of Storage Systems – Capturing IO Patterns

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

By Wesley Brown 2009/11/27 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 2,193 reads

How to Create a Reporting Services 2005/2008 Template

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

By Patrick LeBlanc 2009/11/24 | Source: SQLServerCentral.com | Category: blogs

Rating:

Rate this |

Briefcase | 4,206 reads

Why We Recommend Against xp_cmdshell

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... Read more...

By 2009/11/19 | Source: SQLServerCentral.com | Category: blogs

Rating:

Rate this |

Briefcase | 5,898 reads

SQL University: Multiple Paths and Ownership Chaining

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

By 2009/11/03 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,529 reads

SQL Server Legend – Data Files and Threads

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

By Steve Jones 2009/10/20 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,824 reads

MSDE – Database Size Limit

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

By Patrick LeBlanc 2009/10/13 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,280 reads

Red Gate's SQL Data Generator

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

By 2009/10/06 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,430 reads

Eliminating Empty Output Files in SSIS

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

By Tim Mitchell 2009/10/05 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,359 reads

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

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

By Brian Kelley 2009/10/01 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 5,560 reads

Fundamentals of Storage Systems - The Basics of Spinning Disks

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

By Wesley Brown 2009/09/28 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,750 reads

Blobs and Filestreams

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

By Andy Warren 2009/09/24 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 1,097 reads

Windows Internal Database

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

By Patrick LeBlanc 2009/09/22 | Source: SQLServerCentral.com | Category: blogs

Rating: (not yet rated) Rate this |

Briefcase | 3,142 reads

Content with tags SQL Server, Blogs