Replication can be confusing to many new SQL Server DBAs and some of the optmizations are not well described in Books Online. SQL Server replication expert and trainer Andy Warren brings us a technique for initializing replication without a snapshot.
Learn how to build Custom Reports, without installing Reporting Services, using a new feature found in Microsoft Service Pack 2 (SP2) for SQL Server 2005.
Steve Jones asks about the disclosure of source code in legal proceedings.
Steve Jones asks about the disclosure of source code in legal proceedings.
Steve Jones asks about the disclosure of source code in legal proceedings.
If you have considered deploying a Data Governance program at your organization, the chances are that you have asked the following question: "Where does Data Governance fit into the Organization?"
Corporate management often asks for feedback and buy-in with their ideas and programs. Why don't they get it?
Finding missing data in a sequence of numbers or dates is a common request of DBAs. Regular author Jacob Sebastian brings us a new article that shows just how you can do this.
The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. If all columns selected pass their tests then rows are passed down the successful match output. Rows that fail to pass all tests are directed down the alternate output.
Explore how the rich reporting functionality in Crystal Reports XI and SQL Server Reporting Services 2005 works with common reporting requirements.
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers