2013-05-15
3,345 reads
Articles
Converting Large Object Data Types
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
2013-05-14
4,845 reads
Case Study: Designing Scaled-Out Architecture
On Thursday May 16th 12PM Central time, Robert Davis will discuss public facing websites on a global scale when looking at Data Architecture.
2013-05-14
3,400 reads
How to Synchronize Two SSAS Servers
Unfortunately SQL Server Analysis Services (SSAS) does not support differential backups and creating full backups for the servers might take too much time. In this tip we are going to show how to synchronize two SSAS servers in order to have a failover server in case something goes wrong with one of the servers.
2013-05-14
3,409 reads
2013-05-14
2,764 reads
Loginless In Seattle
Identify orphaned Database Users and differentiate them from "Loginless" Database Users.
2013-05-13
3,143 reads
2013-05-13
5,019 reads
The Ten Commandments of SQL Server Monitoring
It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.
2013-05-13
8,102 reads
Indexed Views
This article will show you the importance of Indexed Views and how they can help performance.
2013-05-10 (first published: 2010-11-16)
24,516 reads
Job overran Custom Metric
This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.
2013-05-10
2,892 reads
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 Tabanan Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jalan By Pass Ir. Soekarno, Kediri, Tabanan 82121, Jl. Gajah Mada No.88,...
BCA KCP Kampung Baru TELP/CS:083135765355
Whatsapp:083135765355 Jl. Brigjend Katamso No.680, Kp. Baru, Kec. Medan Maimun, Kota Medan, Sumatera Utara...
BCA KCP Labuan Telpon. 08388331767
WhatsApp 08388331767 Jl. Raya Labuan - Pandeglang No.01, Labuan, Kec. Labuan, Kabupaten Pandeglang, Banten...
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