Reverse Engineering Alias Data Types in SQL Server 2000 - Part II
Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.
Continuing with his series on Alias Data Types, Yakov Shlafman shows us how to work wtih ADTs when constriaints are involved.
Learn how to retrieve just a subset of database data based on hard-coded values and values from the querystring, other Web controls on the page, session variables, and so on.
Organizations with mature business intelligence environments can integrate fraud analytics within their current environment to take advantage of processes and architecture that are already in place.
Highwire Development is offering a free version of their RAAS product to SQLServerCentral.com members.
Smart CFOs and CIOs should consider making mobile BI available to employees as a way to improve productivity, extend BI adoption and improve operational efficiencies.
Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures.
What types of connectors make the most sense for SSIS packages? New author Mike Frost brings us a look at the various options along with some recommendations for different types of data as well as the 64-bit platform.
Tired of creating templates in SQL Server Reporting Services? Learn how to maintain reusable Reporting Services templates in SQL Server 2005 using BIDS.
Discover how to import and export SharePoint list items using SQL Server Integration Services and the new Collaborative Application Markup Language (CAML).
One of the more common requests of an application working with SQL Server is to deal with pages, or sections, or data rather than an entire result set. Often an application retreives the entire result set and then only shows the user a few records, repeating the process with the next page. Regular columnist Jacob Sebastian brings us a more efficient method of implementing paging in SQL Server 2005.
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers