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
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
How to Choose the Best Connectors for SSIS
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.
2007-08-30
9,151 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
Server Side Paging With SQL Server 2005
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.
2007-08-29
13,719 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
Enums in SQL Server
SQL Server MVP Simon Sabin brings us a very interesting article on a possibilltyfor using enumerated values instead of integer or other coded foreign keys. It is an interesting idea that could go a long way towards making code easier to read.
2007-08-28
13,069 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
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
Alamat Kantor BCA KCU Batam Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota...
Alamat Kantor BCA KCU Kisaran Telp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat,...
Alamat BCA KCU Pematang Siantar Tlp:08218200203
Hub Via Wa:628218200203 Alamat: Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar,...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers