New data profiling tools in SQL Server 2008
New data-profiling tools native to SQL Server 2008 Integration Services such as the Data Profiling task and the Data Profiler Viewer help manage a business intelligence strategy.
Who Do We Choose to Follow?
Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in general and who do you admire, who have you modeled yourself after or who you wanted to follow in sports, in a hobby, in life, etc.
Guest Editorial: Do DBAs Need a Code of Ethics?
Despite the fact DBAs are essentially protectors of an organization’s knowledge, and privy to much confidential information, there is no clearly defined set of rules and standards to help govern and guide their ethical behavior. Brad McGehee thinks it's time for some action on this issue.
Mining Model Viewers - SQL School Video
In this video MVP Brian Knight explains how you can use the model viewers to see how the data mining task will process your data.
All the Aggregates you crave with Grouping Sets in SQL Server 2008
As reporting requirements increase, it seems that aggregate functionalities have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples Canada’s best vendor, BaldGorilla, where I’m currently consulting, has been able...
Creating packages in code - OLE-DB Source to Raw File Destination
This code sample programmatically creates a package with an OLE-DB Source and a Raw File Destination, and the resulting package exports data from SQL Server to a raw file. The finished package just has the one Data Flow Task shown below.
Where is the Surface Area Configuration tool in SQL Server 2008
I just installed a new instance of SQL Server 2008 and I can't find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Database Engine features in SQL Server 2008?
Guest editorial: Reasons to be Cheerful
The furore surrounding the recent release of MySQL 5.1 makes Tony Davis wonder if more than a few web 2.0 developers might be peering over the SQL Server Express fence and wondering if the grass doesn't look slightly greener over here.
SQL Function : Find ‘X’ Business Days in the Future
Many of us deal in date calculations and separating business days from calendar days is always a challenge. New author J Gravelle brings us a new article that talks about this subject as a way of ensuring SLAs are met.
Gaining the benefits of DMVs for SQL Server
Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
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...
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