Little Devices
This Friday Steve Jones asks if you think that your job could be done with smaller devices. Is there a chance that a mobile phone, a tablet or something else could help you be more productive?
Querying Active Directory using SSIS Script Task
One of the most distinguishing characteristics of Control Flow Script Task available in SQL Server 2008 Integration Services is its flexibility. This article demonstrates some of these capabilities by describing an approach that employs the Script Task to query data residing in an Active Directory domain database.
SSIS Training Live and In-Person
MVP and author of our Stairway Series on SSIS, Andy Leonard, is holding an SSIS class this December in northern Virginia. If you are interested in top notch SSIS training, read on.
The SQL Server MCM Training Has Changed
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft...
Improving Database Design and Performance Using Compression
This article attempts to show a practical scenario on improving DB design and performance through row density and compression in Microsoft SQL Server 2008.
SQLServerCentral Webinar #5 - Powershell and Source Control
MVP Allen White talked about how Powershell can be used to script out your database and put it in Source Control, and how SQL Source Control from
The DBA Disconnect
It seems that there is a disconnect between how technical people view security and how business people see it. Steve Jones talks about the problems that we have in trying to secure the systems we manage.
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
SQL Server Agent Job Management Scripts
In a previous tip, the tip reviewed several steps for a better and improved environment for scheduled jobs. I am totally convinced with the recommendations and want to implement these for my scheduled jobs. To make this easier, I want to create a template so I can produce a suitable and reliable way of updates for my production server. In this tip I provide a step by step exercise to perform on a test server to prepare the customized and tested scripts to run on the production server.
Are You a Ten?
Are you truly an expert in SQL Server? Would you claim to be a 10 on a scale of 1 to 10? Steve Jones notes that the product is so wide and deep that it's unlikely any of us will be an expert in most of SQL Server, and that's OK.
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 CBD Pluit Tlp (+62 821°3111°179
Kawasan Hunian dan Bisnis Terpadu, CBD Pluit, Jl. Pluit Selatan Raya Blok B No....
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,...
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