Managing Large Data Sets in SQL Server 2005 and 2008
Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.
2010-01-04
10,556 reads
Articles
2010-01-04 (first published: 2009-12-30)
1,699 reads
Why would a SQL Server Professional need an iPhone for work?
In which Phil Factor attempts to justify his iPhones and iPod Touches as a business expense.
2010-01-04
304 reads
Analysis Services Performance Optimization Tips
Over the last few weeks I have focused most of my blog energy into writing a couple articles. So I...
2010-01-04
1,635 reads
Be Prepared
Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
2010-01-04
2,109 reads
Be Prepared
Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
2010-01-04
2,707 reads
Be Prepared
Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most of you probably unconsciously follow that in your daily lives. Why is it that so many of us don't follow through on this same advice with our databases? Grant Fritchey gives a few examples of how you should "be prepared" for a database emergency.
2010-01-04
2,236 reads
Top 10 steps to optimize data access in SQL Server. Part II (Re-factor TSQLs and apply best practices)
In this article, we are going to focus on writing or refactoring the data access codes using the best practices. But, before we start playing the game, we need to prepare the ground first. So let’s do the groundwork at this very next step:
2010-01-04
7,082 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2010-01-04
2,795 reads
Using SSIS to zip files and email the zipped files
I have often needed a means to send zipped files via email. This article shows one method to do just this.
2010-01-01 (first published: 2008-09-22)
38,613 reads
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 KCP Atrium Tlpn/wa:085373737551
Ruko Atrium Blok E. 12-13, RW.2, Senen, Kec. Senen, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Kreo Ciledug,Telp/Wa 0821.3111.159
Jl. HOS Cokroaminoto Jl. Ciledug Raya, RT.001/RW.006, Kreo Selatan, Kec. Larangan, Kota Tangerang, Banten...
BCA KCP Abdul Muis Tlpn/wa:085373737551
Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, Petojo Sel.,...
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