SSAS - Defining Attribute Relationships in 2005 and 2008
Attribute relationships inside of Analysis Services are a critical piece to the design of your dimensions.The benefits of creating attribute...
2010-09-20
1,590 reads
Blog Posts
What Do You Think Just Happened To This Database Server?
This is a screenshot of Task Manager for a database instance that is part of a synchronous database mirroring partnership...
2010-09-20
1,187 reads
SQLSaturday #50 Report
I attended my first SQLSaturday yesterday in Iowa City, Iowa. I spoke on two topics: “What’s New with Reporting Services”...
2010-09-19
1,619 reads
SSIS: Assign a value to Variable using Dataflow Script task
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Are Your Backups Really Safe?
This editorial was originally published in the Simple-Talk newsletter.
Imagine for a moment if you will. As a DBA, and as...
2010-09-18
550 reads
SQL Server 2008 and 2008 R2 Diagnostic Information Queries
Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These...
2010-09-18
3,916 reads
ACID
What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the...
2010-09-17
2,199 reads
CakeWrecks
Recently I had a student point me to CakeWrecks, a blog about good cakes gone bad.The post from today has...
2010-09-17
552 reads
Do You Have Influence? Part 2
I started writing on influence last week and promised some comments on how to build influence and credibility. There are...
2010-09-17
1,358 reads
I Don't Want to Share!
I know we were taught to share in kindergarten, but there are some things that should not be shared. In...
2010-09-17
571 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Detecting Deadlocks
Comments posted to this topic are about the item Detecting Deadlocks
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers