Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
When Do You Deploy?
Finding downtime can be hard at times, but Steve Jones recently found a company that took it during the week. This Friday's poll asks when you can have downtime.
Why Use SSAS?
After a great presentation from Brian Knight at the NYC User Group, Robert Pearl summarizes some information about SSAS and when it makes sense to use this subsystem. And why you might want to attend that next user group meeting.
Code that Writes Code - A Good Idea or Not?
I’m a big fan of code that writes code – most of the time. For instance, whenever you use the “templates” feature in SQL Server Management Studio (SSMS) or the Maintenance Wizard, you’re using code that writes other code. There’s even ...
Corruption Recovery Tips, Database Shrinkage Advice and More
Question: My backup strategy is a daily full backup at 1 a.m. and a log backup every hour. A DBCC CHECKDB also runs every day at 4 a.m. If I get to work at 8 a.m. and discover that the nighttime consistency checks found extensive corruption, how can I recover without losing a lot of data?
Job Quality
Through a circuitous route, I encountered a meaningful, thought-provoking quote lately: "... the best way to predict the future is to...
Quick Tip Of The Day
Over and over again we are told that the DMV’s only hold data since your last reboot. So, how do...
Managing Analysis Services Deployment - Part 2
Continuing with this series, Shahfaisal Muhammed brings us another method of deploying your SSAS projects to a new server. The rest of the series will cover other methods.
The Afternoon Whistle
Today we have a guest editorial from Andy Warren. Balancing work and life is a challenge, and today Andy looks at one way that has helped him to manage his hours and learn to get away from work.
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
Blogs
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 Latumeten telpon/wa:08216277447
BCA KCP Latumeten telpon/wa:08216277447.Jl. Prof. Dr. Latumeten No.28, Angke, Kec. Tambora, Kota Jakarta Barat,...
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
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