When configuring a subscription to a publication in SQL Server, on initialization it is common to encounter the error:

The process could not read file X:\Program Files\Microsoft SQL Server\<instance>\MSSQL\repldata\<snapshot>\<snapshot_file> due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20016)
Get help: http://help/MSSQL_REPL20016
The system cannot find the path specified.
(Source:… Read more

The Holidays are upon us.  It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL Server.

This month, Jason Brimhall will be presenting a new topic:

REPORTING SERVICES FOR MERE DBAS

As a DBA in the… Read more

Here is the list of suckers, uh, I mean, candidates, that actually want to subject themselves to the board. Look these people over, weigh them, and vote well. Things are running a little different this year. The elections are being held between the 6th and the 20th of December. Read more

Introduction

Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list a number of records and fetching them all at once and listing is not a feasible option because of the following reasons -

1. High utilization of the network…

Read more

Behind the scenes in SSIS, the data flow engine uses a buffer-oriented architecture to efficiently load and manipulate datasets in memory.  The benefit of this in-memory processing is that you do not need to physically copy and stage data at each step of the data integration.  Rather, the data flow… Read more

My main phone line at the house has been on the fritz for about 3-4 weeks. Yes, we still have a main line and it’s a legacy holdover from having that number for a decade and it links do our DSL account. We may get rid of it at some… Read more

While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.

I want your techie book recommendations. Write me a tweet @MidnightDBA, or in the comments below, that compels me to read your book of choice. (Yes, you can recommend… Read more

This is a continuation of my DBA in Space journal.

Episode eight is another Friday task-related question. On the previous Fridays, I wasn’t involved in any of the scenes. But on this Friday I… Read more

There is nothing like having two children to remind you how strange, funny, and complicated language can be. Try answering the question “why is — a bad word?” in a way that makes sense to a four year old. Yesterday she asked me if hate was a bad word, and… Read more

The Professional Association for SQL Server and the North Texas SQL Server User Group have been working hard behind the scenes to bring SQLRally 2012 in Dallas Texas to the SQL Community.  We are excited to announce that event registration opens November 30, 2011.

Make sure to get registered soon… Read more

Just saw the official announcement MS TechEd will be in Orlando June 11-14, 2012, at the Orange County Convention Center. Here in Orlando that means we need to get busy with oPASS and ONETUG to see if we can engage some of the speakers that will be in town for… Read more

I read a post about documenting your day by Steve Jones, here is where culture insists i write a few words about the person i refer to. But you don’t expect that for Steve. Do you?

In this short post, I’ll present my view on why you should document your… Read more

As I did for powershell a day Series Blog April 2011, consolidated the all months blog into one pdf file here. I have done this month as well, I Blog about Troubleshooting sql server issues -Errors , which we get during our day to day activity.

you can download… Read more

Day 30 More Fatal Errors and BUGs

1. For sql server 2000 and earlier you may get 5242 and 5243 corruption in the record  structure(for sql server 2005 onwards you may get 824).
   

Msg 5242, Level 22, State 1, Line 1

An inconsistency was detected during an internal operation in database… Read more

Want 2 days of Microsoft SQL Server training where you can hand-pick what you're learning about for the low price of $299?

That's what you get with SQLRally, which next year will be held in Dallas, Texas. Registration just opened for this event and the early bird $299 pricing… Read more

 
I have lost an hour today trying to find a bug in my SSIS package, and it was so small - just two letters - "GO"

I had an Execute SQL Task with an input parameter and I had an SQLStatement with some lengthy logc and a "GO" at… Read more

We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s home computer.  We will have to install another appliance to the DR site which will happen today or tomorrow.  So far from the management console, it looks promising. 

Since yesterday… Read more

With the announcement of the official slate for the BoD election for this year, the job of the NomCom is over. As soon as the oppurtunity to work in the NomCom came I grabbed it with both hands. I knew that it would be a high pressure job and it… Read more

Test Post

Related posts:

1. Cry, Baby, Cry! Failing the MCM Test

Read more

SQL Server Magazine Reveals New Name for the Brand

Did you hear the news?  SQL Server Magazine has a new name - it's now called SQL Server Pro!  Read on to find out the details.

In the world of print, there are a shrinking number of specified SQL Server professional… Read more