The Gadget Itch
What would build if you had time? Anything fun or interesting? What's on your mind if you're a maker?
Use Extended Events to Get More Information About failed SQL Server Login Attempts
You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help.
DAX: Topn is not a Filter
In this document I will demonstrate how using the TOPN function in a DAX query doesn’t necessarily do what you may expect.
Searching for Strings in SQL Server Databases
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.
SQL Saturday #292: Detroit
SQL Saturday is coming to Detroit MI on May 17, 2014. Join us for a free day of SQL Server training and networking. Register while space is available.
Stairway to SQL PowerShell Level 6: PowerShell Modules
In this level, we will walk through creating and using modules for PowerShell. Modules are simply a collection of functions that are most likely related to each other and packaged in a way that allow you to import them as a group.
Options to Move a Big SQL Server Database to a New Drive with Minimal Downtime
This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe.
Duplicate Detection and Management
Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data.
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 Dewi Sartika Tlpn/wa:085373737551
Jl. Dewi Sartika No.15, Sayang, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43213
BCA Finance Bekasi Layanan Mobil Telpon/WA:085188120691
BCA Finance Bekasi Layanan Mobil Telpon/WA:085188120691 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard...
BCA KCP Ketapang Telpon/WA:08137887595
BCA KCP Ketapang Telpon/WA:08137887595.Blok A/3-4, Ketapang Indah, Jl. KH Zainal Arifin, Krukut, Kec. Taman...
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