Password Handling
A system administrator can set a good example with the passwords they give to users or a bad example. Which one do you set?
The Trouble with Transactional Replication and large articles.
This article will show you one way to quickly restore SQL Server replication with huge tables.
Implementing Foreach Looping Logic in SSIS
With SSIS, it is possible to implement looping logic into SSIS's control flow in order to define a repeating workflow in a package for each member of a collection of objects. Rob Sheldon explains how to use this valuable feature of SSIS.
Do Interviews Work?
Interviews are the way we primarily make hiring decisions but as Steve Jones notes, we don't really end up doing a very good job of picking good employees in many cases.
Generating n-Tuples with SQL
An n-Tuple is a combination of values from rows of a table in pairs (2-Tuple) or triplets (3-Tuple), etc.
Get a Descriptive Name for SQL Server Analysis Services Profiler Event Class and Event Subclass
A customer provides an SQL Server Analysis Services trace file to analyze. You save this file into a trace table and execute T-SQL code to analyze the results. Rather than getting descriptive values for the EventClass and EventSubclass data, you get numerical values. How do you resolve these numerical values to meaningful descriptive names? Check out this tip to learn more.
Stop Asking and Start Making Decisions Today
You’re desperately trying to get things done but it’s just not happening for you. I’m going to let you in on a little secret, you’re doing it wrong!
The Real World: Implementing AWE
Describes the gains experienced in my environment by implementing AWE.
What is Big Data?
The definition of Big Data is rather murky, despite all the press and attention given to it. Steve Jones talks about what Big Data means for relational databases.
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
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
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
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers