Don’t Change Anything
Being responsible for data integrity as well as the cleaning of data can be a problem for an organization. Steve Jones reminds us today that we should be careful about changing the data we work with.
New and Improved Functionality in SSIS 2008
While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.
Understanding Dynamic Management Views and Functions in SQL Server 2008
Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.
Answering to the Business
As data professionals, or IT workers, we often have a lot of insight into how much our services cost and the options that are available. But many times the rest of the company does not. Steve Jones thinks we could be more transparent, and possibly help them to be more efficient.
Down Tools Week
Sometimes it's important for a developer or DBA to be given the opportunity to 'shake up their brain'. What falls out is almost always worth having.
Working with Queues in SQL Server
This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.
Celko's SQL Stumper: Eggs in one Basket
Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.
SQL Server Indexed Views
Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.
TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses
This challenge is related a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
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 Soreang,Telp/Wa 0821.3111.159
No. 1-A, Jl. Raya Soreang, Pamekaran, Kec. Soreang, Kabupaten Bandung, Jawa Barat 40912
BCA KCP Majalaya,Telp/Wa 0821.3111.159
Jl. Raya Laswi No.212 A, Majalaya, Kec. Majalaya, Kabupaten Bandung, Jawa Barat 40382
BCA KCP Pasar Minggu Center Tlpn/wa:085373737551
Tlpn/wa:085373737551 Jl. Lenteng Agung Raya No.26 E-F, 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