Additional Articles

How to find, compare and use the exact same session settings as another user in SQL Server

by Additional Articles

MSSQLTips.com

Session settings

When diagnosing issues in SQL Server I've found that sometimes I need to be able to mimic a user's session state when attempting to repeat an error they may be receiving. The smallest differences can completely change the outcome, so I need to ensure all the session settings (QUOTED_IDENTIFIER, ANSI_NULLS, and so forth) are identical between the production session and my test session. Is there an easy way to determine these settings with a single query?

2009-08-31

2,627 reads

Enterprise Policy Management Framework with SQL Server 2008

by Additional Articles

Microsoft MSDN

SQL Server 2008

The Enterprise Policy Management (EPM) Framework leverages and extends the new Microsoft SQL Server 2008 Policy-Based Management feature across an entire SQL Server enterprise, including down-level instances of SQL Server such as SQL Server 2000 and SQL Server 2005.

2009-08-28

2,290 reads

SQL Server Analysis Services ( SSAS ) - Introduction

by Additional Articles

SQL Server Performance

Analysis Services (SSAS)

Microsoft SQL Server 2005 Analysis Services (SSAS) delivers both online analytical processing (OLAP) and data mining functionality for business intelligence applications. This article thoroughly explores the architecture of SSAS and how it can be implemented.

2009-08-28

3,915 reads

7 Ways To Crash a Database

by Additional Articles

Database Journal

Disaster Recovery (DR)

Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.

2009-08-27

9,660 reads

Getting started with SQL Server database diagrams

by Additional Articles

MSSQLTips.com

database diagram

In this tip I show you how you can use the built-in SQL Server database diagram tool. I go through some of them messages you may get when getting started and then look at various tasks that you would perform using this free tool.

2009-08-27

5,001 reads

Kimball University: Five Alternatives for Better Employee Dimension Modeling

by Additional Articles

SQLServerCentral.com

Data Warehousing

The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-08-26

3,651 reads

SQL Server Security Audit (Part 1) - Server Level Audit

by Additional Articles

SQL Server Performance

Security

The first of this three part series on SQL Server Security Auditing focuses on the SQL Server itself and addressing any of its security vulnerabilities.

2009-08-26

3,129 reads

The Ghost in the Machine

by Additional Articles

TDAN

Now that hierarchical data structures are popular again because of XML, their full hierarchical processing is still being limited to flat two dimensional linear path processing by relational processing. This will change when database professionals realize that ANSI SQL relational processing can now support full multipath nonlinear hierarchical processing.

2009-08-25

3,326 reads

Validate SQL Server Backups Exist with Policy Based Management

by Additional Articles

MSSQLTips.com

Backup and restore

I recently submitted a tip regarding the existence of your backup files using the undocumented system stored procedure xp_fileexist. But how would you go about executing that script against all your SQL Server 2005 and SQL Server 2008 instances? I took that script and decided to go one step further using Policy Based Management to create a custom policy that you can then run against all your SQL Server 2005 and SQL Server 2008 instances.

2009-08-25

2,712 reads

Attaching a database in Microsoft SQL Server 2008

by Additional Articles

Database Journal

SQL Server 2008

Various methods of using the "For Attach" clause exist to overcome the limitations that face us when using sp_attach_db and sp_attach_single_file_db. The first installment illustrates the use of the "Create Database" statement for the "For Attach" and "for ATTACH_REBUILD_LOG" arguments, for a single .MDF file and single .LDF file.

2009-08-24

2,945 reads

All authors

Additional Articles

How to find, compare and use the exact same session settings as another user in SQL Server

Enterprise Policy Management Framework with SQL Server 2008

SQL Server Analysis Services ( SSAS ) - Introduction

7 Ways To Crash a Database

Getting started with SQL Server database diagrams

Kimball University: Five Alternatives for Better Employee Dimension Modeling

SQL Server Security Audit (Part 1) - Server Level Audit

The Ghost in the Machine

Validate SQL Server Backups Exist with Policy Based Management

Attaching a database in Microsoft SQL Server 2008

Blogs

Five Ways Redshift Serverless Quietly Eats Your Budget

A Career of Memories

Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead

Forums

Midjourney, Healthcare?

Changes, Happiness, and a Few Tears

BCP on Linux

Question of the Day

BCP on Linux