SQL Server patch pros and cons
A patch to your SQL Server system can cause problems, but an unpatched SQL Server is unprotected. Learn the pros and cons of SQL Server patches.
2007-09-04
3,000 reads
Additional Articles
Accessing and Updating Data in ASP.NET 2.0: Filtering Database Data wi
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.
2007-09-03
3,568 reads
The Importance of Fraud Analytics
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.
2007-09-03
1,523 reads
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
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
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Jamblang Tlpn/wa:085373737551
Jl. Jamblang Raya No.51, RT.2/RW.1, Duri Sel., Kec. Tambora, Kota Jakarta Barat, Daerah Khusus...
BCA KCU GREEN GARDEN Telpon/WA:08218168291
BCA KCU GREEN GARDEN Telpon/WA:08218168291.Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...
BCA KCP Pasar Tanah Abang. Tlpn:085373737845
Jl. KH Fachrudin 36 Blok D/23, Daerah Khusus Ibukota Jakarta 10250
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers