Adding a timestamp to files in SSIS - SQL School Video
Integration Services is the ETL platform for SQL Server. In this installment of SQL School, Brian Knight shows how to add a timestamp (current date) to the name of a file.
The Broken Window
A new data mining thrilled from Jeffrey Deaver has Steve Jones concerned about the centralization of data mining.
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
Databases for Change
Meaningful change often requires information collection, processing, retrieval and distribution. As database professionals, that's our bag. So what can we do to help things along?
A Lack of SQL
Steve Jones talks about a company looking to write all their stored procedures using the CLR in SQL Server. Is this a good idea?
Is it 1995?
A bug in the SQL Server 2008 upgrade process has Steve Jones questioning the coding practices at Microsoft.
Moving Indexes
Working with filegroups and managing the location of your various objects can be a cumbersome task in SQL Server. New author Thom Bolin brings us a technique and some code that worked well for one of his clients.
How To Collect Performance Data With TYPEPERF.EXE
One of the things I typically need to do is to collect performance data on the server which includes CPU, memory and disk utilization as well as SQL Server-specific data. What command line tools are available to do this?
Murphy’s Laws of Data Warehousing: What Goes Bump in the Night?
Murphy’s Law tells us that whatever can go wrong will go wrong. This axiom applies to all aspects of life, including data warehousing. The following corollaries to Murphy’s Law relate this inevitability of something going “bump” in the night to data warehousing.
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 Cilegon Telpon. 08388331767
WhatsApp 08388331767 Jl. Raya Merak No.42, Ramanuju, Kec. Purwakarta, Kota Cilegon, DKI Jakarta 42411
BCA KCP Duta Mas Fatmawati Tlp (+62 821°3111°179
Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No. 6, 7,...
BCA KCP Klungkung Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Puputan No.88 B, Semarapura Kelod, Kec. Klungkung, Kabupaten Klungkung, Bali 80716
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