SQL Server 2008 Compression
Testing and analysis of new backup compression and table/index compression features of SQL Server 2008.
What Do We Want?
Today Steve Jones talks about the challenges of deciding what to include in that next software release. Something that likely isn't as easy as we might think it should be.
Basic Defensive Database Programming Techniques
We can all recognize good-quality database code: It doesn't break with every change in the server's configuration, or on upgrade. It isn't affected by concurrent usage, or high workload. In an extract from his forthcoming book, Alex explains just how to go about producing resilient TSQL code that works, and carries on working.
SQL Saturday #42 - Columbus Call for Speakers
If you want to speak at this June 26 event, submit a session now.
April Webinar: MVP Series
Free webinar training brought to you by Pragmatic Works, WROX, SQL Server Central, and SQL Server Magazine. The April Series will run from April 20 - April 29, 2010. Register now to reserve a place.
Speed Racer
Speed is critical. That's the theme for today's editorial, using the NYSE as an example.
Using Full Text Search in SQL Server 2008
SQL Server 2008 Full-Text Search feature can be used by application developers to execute full-text search queries against character based data residing in a SQL Server table
No One is Safe
A funny example of SQL Injection has Steve Jones reminding us that every application needs to protect itself.
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications.
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 Jayakarta HUB/WA 08216977701
Jl. Pangeran Jayakarta Dalam No.26 Blok A/2-3, Mangga Dua Sel., Kecamatan Sawah Besar, Kota...
BCA KCU PLUIT No tlpon:083138717148
Whatsapp:083138717148. Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit, Penjaringan, North Jakarta City, Jakarta...
BCA KCP Suniaraja No.Telp:087757645171
Whatsapp:087757645171 Jl. Suniaraja Timur No.49, Braga, Kec. Sumur Bandung, Kota Bandung, Jawa Barat 40181
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