Understanding the CDC State Value
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
1,952 reads
If you are using Change Data Capture (CDC) it can be very useful to look at the CDC State table...
2012-07-12
1,952 reads
Change data capture was introduced in SQL Server 2008 and has been pretty popular ever since. The basic concept behind...
2012-07-10
3,994 reads
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
262 reads
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
947 reads
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side...
2012-04-05
3,703 reads
Like all systems built on top of SQL Server SharePoint 2010 needs to have a plan for availability. There are...
2012-04-02
1,213 reads
Between SharePoint 2007 and SharePoint 2010 there were many new features that were added or enhanced. There still remains a...
2012-04-02
1,461 reads
In an SSIS package you have the option to choose from a wide range of source from Flat Files to...
2012-03-29 (first published: 2012-03-23)
3,350 reads
In T-SQL there are many functions there to help do a variety of different things. SSIS is no different. In...
2012-03-23
1,927 reads
The MultiDimensional eXpressions, or MDX, language is used to query the data in a multidimensional in an OLAP database. In the...
2012-03-12
1,409 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
This is one I haven't seen before. I'm trying to drop a database user...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers