Are you preparing for SQL Server 2008 R2?
With the launch of SQL Server 2008 R2 almost upon us, DBAs need to start planning in some time to see what it has to offer. Brad McGehee reviews some of the available resources.
The Log Shipping Standard
Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.
SQL Server Geography Data Type
We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?
Essential Software
For this Friday's poll, Steve Jones asks if there is a set of essential software that every DBA needs to have installed on their machine.
Retrieving Data from an Audit Table
This article examines the various methods for retrieving data from an Audit table.
SQL Server Intellisense VS. Red Gate SQL Prompt
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
Office Cleaning
A guest editorial from Andy Warren today looks at choices in time management, as well as work accomplished.
SQL Server 2008 Spatial Index Performance
The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
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 Finance Pekalongan Telpon/WA:08137887595
BCA Finance Pekalongan Telpon/WA:08137887595.Bentengan, Bener, Kec. Wiradesa, Kabupaten Pekalongan, Jawa Tengah 51152
BCA KCP Mangga Besar,Telp/Wa 0821.3111.159
Jl. Raya Mangga Besar No.15, RT.6/RW.5, Mangga Besar, Kec. Taman Sari, Kota Jakarta Barat,...
BCA KCP Foresta Tlpn/wa:085373737551
Kavling Commercial Foresta Lot I-1, Lengkong Kulon, Pagedangan, Kab. Tangerang, Banten, Lengkong Kulon, Kec....
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