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
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.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCU WISMA ASIA Tlpn/wa:085373737551
Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, Kota Bambu Sel., Kec. Palmerah, Kota...
BCA KCU THAMRIN. Tlp :085373737845
BCA KCU THAMRIN. Tlp :085373737845.Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec....
BCA KCU GREEN GARDEN Tlpn/wa:085373737551
Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3, Kedoya Utara, Kec. Kb....
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