Are Your Indexes Being Used Effectively?
This article shows how to use the dm_db_index_usage_stats DMV to identify if an Index is being used on not
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
Replication methods: Snapshot, merge or transactional
SQL Server replication methods include snapshot, merge and transactional replication. Learn how to choose a method, set up SQL replication and avoid the 'gotchas.'
Exporting MDX queries to SQL Relational Databases using SSIS 2005
Most of the time we move data from an RDBMS to a cube, but there are places where you might want to provide a feedback loop to the RDBMS. Andrew Muyobo shows how SSIS can help you do this.
Generate SQL Agent Job Schedule Report
I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?
SQL Server 2008 Full-Text Search: Internals and Enhancements
This white paper covers in detail the new integrated full-text search architecture, new features, main changes from full-text search in SQL Server 2000 and SQL Server 2005, and limitations and best practices for deploying applications that use SQL Server 2008 full-text search.
E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
Investigating the new Spatial Types in SQL Server 2008 - Part 2
This is the second article in the series on the new spatial data types in SQL Server 2008
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 Cikarang Central City Tlp (+62 821°3111°179
Ruko Cikarang Central City, Jl. Raya Cibarusah KM 10. 88 Blok B No. 1,...
BCA KCU JOMBANG No tlpon:083138717148
Whatsapp:083138717148.Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
BCA KCP Palu Selatan Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Jenderal Basuki Rahmat No.94, Tatura Sel., Kec. Palu Sel., Kota Palu, Sulawesi...
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