Moving to the Heartland
With companies like Microsoft and Google building data centers in small towns, Steve Jones has some comments about how this might affect IT jobs.
Introduction to DML Triggers
This article by Jack Corbett explains what triggers are, the different types, and how to avoid common mistakes.
Showing OLAP Data in SSRS - SQL School Video
Reporting Services makes it easy to get data from a variety of sources, including Analysis Services cubes. In this SQL School video, Brian Knight shows how to use an SSAS cube as the dataa source for your reporting needs.
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Can you shrink your SQL Server database to death?
To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.
Climb Another Mountain - Database Weekly (Oct 13, 2008)
The next version of SQL Server has a codename. Or does it? Steve Jones talks about some announcements in the SQL Server world this past week.
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
A methodology is described to bring out the best in database monitoring through System Center Operations Manager 2007 customization.
Granting View Definition Permission to a User or Role
Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
Too Good at Data Analysis
Can you be too good at analyzing data? An interesting story from the financial markets.
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 Saharjo Telpon/WA:085188120691
BCA KCP Saharjo Telpon/WA:085188120691 Jl. Dr. Saharjo No.149 G-H, Manggarai Sel., Kec. Tebet, Kota...
BCA KCU MENARA BIDAKARA Telpon/WA:085188120691
BCA KCU MENARA BIDAKARA Telpon/WA:085188120691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
BCA KCP Tebet Telpon/WA:085188120691
BCA KCP Tebet Telpon/WA:085188120691 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N...
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