BI Has Left the Building
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.
2007-08-31
2,795 reads
Additional Articles
Close those Loopholes - Testing Stored Procedures
Alex and Alex continue their series of three articles on 'Unit Testing' database development work with some examples of unit testing stored procedures.
2007-08-31
4,297 reads
Creating SQL Server Reporting Services templates
Tired of creating templates in SQL Server Reporting Services? Learn how to maintain reusable Reporting Services templates in SQL Server 2005 using BIDS.
2007-08-30
3,809 reads
Sync Your Database to SharePoint Using SSIS
Discover how to import and export SharePoint list items using SQL Server Integration Services and the new Collaborative Application Markup Language (CAML).
2007-08-30
2,012 reads
Agile on a Fixed Budget
Scott examines strategies for dealing with constraints that business stakeholders may put on software development teams.
2007-08-29
2,486 reads
Getting Small: Building Lightweight Web Applications with Small-Footpr
Not every application needs a full-featured enterprise-scale database. In such cases, you can reduce costs and save resources by using a small-footprint database.
2007-08-29
3,786 reads
SqlCredit Part 7: Performance Impact of EncryptByCert and DecryptByCer
Part 7 of our "Developing a Complete SQL Server OLTP Database Project" discusses performance issues resulting from using EncryptByCert and DecryptByCert. Read the article and download the code to run the test yourself.
2007-08-28
1,980 reads
Using DDL Triggers in SQL Server 2005 to Capture Schema Changes
This article shows how to use DDL triggers to capture schema changes. This solutions works a little differently than most DDL triggers examples. This script captures the old object that was replaced.
2007-08-28
2,785 reads
Accessing and Updating Data in ASP.NET 2.0: Accessing Database Data
This article shows how to use the SqlDataSource and AccessDataSource controls to query data from a relational database.
2007-08-27
3,636 reads
SQL Server 2005 Express Edition - Part 4 - Surface Area Configration
This article demonstrates how you can use Surface Area Configuration utility in order to modify some of the security-related settings that have been applied during installation of SQL Server 2005 Express Edition.
2007-08-27
1,878 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers