Twitter Your Issues
Twitter is one of those interesting Web 2.0 ideas that is hard to analyze. Is it valuable? Steve Jones might have an idea for how it could be used by DBAs.
Using the File System Task - SQL School Video
In this video, MVP Brian Knight shows how you can use SSIS to work with files on your drive: renaming them, moving them, and more.
Building a SQL Server Data Dictionary with the Extended Properties and Third Party Tools
When the database is small, developers often use built-in SQL Server tools and scripts to create the data model. However when the data model grows into an enterprise level data model with all of the associated complexities, the management and maintenance grow as well. So what options are available to manage and build the data model?
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
How Productive Are You?
We all deal with inefficiencies at work, but how efficient are we ourselves? Steve Jones takes a poll this Friday.
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
Fix the Little Things
There are any number of small, annoying or tedious things in SQL Server and Steve Jones makes a case for getting them fixed.
Invoking Stored Procedures through a One Line Native .NET Method Call
Calling stored procedures from your application should be easy. Mark Frishman of ActiveDB talks about what he's done to help you build applications quicker.
Restore Transaction Logs for Point in Time Recovery
This article shows how a database can be restored to achieve point in time recovery
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 Pasar Atum No.Telp:087757645171
Whatsapp:087757645171 Ps. Atum Mall, Jl. St. Kota No.7A Lantai 2 Stand No. BA-1 s/d...
BCA KCU SUBANG No tlpon:083138717148
Whatsapp:083138717148.Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
BCA KCP Cilandak KKO I Telp:cs.(0821)8171955
Whatsapp:08218171955 Jl. Raya Cilandak KKO No.9, Ragunan, Ps. Minggu, Kota Jakarta Selatan, Daerah Khusus...
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