Tally Table Uses - Part II
In part II of this series, Sioban Krzywicki shows us another way Tally Tables have helped solve problems - Text Parsing.
Implementing SSIS Package Configurations
Marcin Policht demonstrates how to leverage SQL Server Integration Services (SSIS) package variables in order to modify SSIS properties without directly editing package content.
Houston, we have a problem
Phil Factor takes a sideways look at Houston, a new tool for building SQL Azure applications, and is somewhat underwhelmed by what he finds.
Parallelism and Performance: Are You Getting Full Return on Your CPU Investment?
A webinar from the PASS Performance VC on Aug 3, 2010
Snoops
A survey shows the majority of IT administrators have snooped for data on their networks. Steve Jones reminds us to be professionals, each and every day.
Tally Table Uses - Part I
In the first part of a series on Tally Tables, Sioban Krzywicki shows how a Tally Table has helped out with fiscal year calculations.
Making your database changes backward compatible: Changing a relationship
Let's face it: requirements change. There is usually a lot of churn during the design and initial development stages, but changes can happen to mature applications, too. The key is to introduce those changes with the least amount of effort and risk.
Fall 2010 Speaking Opportunities
There is no shortage of events that you can attend this fall and many of them are looking for speakers. If you've solved a problem at work, maybe you want to present a solution at one of these great events.
TSQL LAB 2 - Writing Conditional WHERE Clauses
Jacob Sebastian takes a look at some different ways to write your WHERE clauses. A good basic article for those starting to work with T-SQL.
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 Mandala Telpon/WA:08137887595
BCA KCP Mandala Telpon/WA:08137887595.Jl. Hayam Wuruk No.111, Maphar, Kec. Taman Sari, Kota Jakarta Barat,...
BCA KCP Klender,Telpon/Wa 0821-8200-239
Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota Jakarta...
Bca Multifinance. Tlp:08218168235
3666+FRX, Mijen, Ketapang, Kec. Kendal, Kabupaten Kendal, Jawa Tengah 51319
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