Encrypting Data With the Encrypt Function
One of the major problems in the database field is when people store sensitive data unencrypted into SQL Server. This article shows you one of the most basic ways to encrypt data to the casual viewer.
Help! My Database is Marked Suspect.
If your database is marked suspect, this will show you a step-by-step guide in how to fix the problem.
Implementing Encrypting File System (EFS) with SQL Server
EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.
Periscope for SQL Server Discount
With a new version supporting SQL Server 2005, Periscopde for SQL Server is offering a 25% discount for SQLServerCentral.com members. This product helps with performance monitoring.
SQL Server 2000 SP 3: What's New in Security
Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.
Updating AS/400 Linked Server Tables from SQL Server
One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.
A Fun Poll
Since I've spent most of the week at the PASS Summit, and have been busy meeting with people there instead of working on this site, I opted for a more fun, less thought-requiring poll.
Changing Service Credentials
One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.
Strategies for Testing Data Warehouse Applications
This article presents a strategy for testing ETL applications that perform data movement and populate data warehouses. It is useful information for the testing community as well as designers and managers charged with planning a data warehousing implementation.
Experiences from a Real World Project
SQL Server 2005 Integration Services changed the ETL paradigm for SQL Server developers and DBAs. SSIS expert Jamie Thomson has been working with this platform for a few years and brings us some real world knowledge based on a large project he completed in 2006. (Reprinted from the SQL Server Standard).
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCU WISMA ASIA Telpon/WA:087768193341
BCA KCU WISMA ASIA Telpon/WA:087768193341.Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu...
BCA KCP Taman Sari Telpon/WA:087768193341
BCA KCP Taman Sari Telpon/WA:087768193341.Jl. Taman Sari Raya 47-47A, Taman Sari, Kec. Taman Sari,...
Alamat BCA KCU TARAKAN Telp/WA:0817629933
Jl. Yos Sudarso Pantai No.08, Karang Rejo, Kec. Tarakan Bar., Kota Tarakan, Kalimantan Utara...
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