March Question: What is the biggest mistake/problem you have ever found on a SQL Server instance, and how did you fix it?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
SQL Saturday #33
A one day training event in the Charlotte, NC area. Come join MVPs from around the area at another great SQL Saturday.
Be Responsible
When getting help online, you need to be professional and a part of that is being responsible. Steve Jones reminds us today that we have to be careful about what we post.
Data Mining with Microsoft SQL Server 2008 - Sample Chapter
Another sample chapter from Wiley, this time for one of the hot topics in business intelligence: data mining.
Master Data Services - SSIS MDM Load
The article will provide an overview of Master Data Services and a sample SSIS Package.
Ten Problems with XQuery and the SQL/XML Standard
XQuery and SQL/XML standard are processors for XML. SQL/XML was designed to try to match the capabilities of XQuery as closely as possible and XQuery was designed not only to support XML, but also to support relational processing. Read on to learn why this may have a negative influence on their capabilities.
Overusing Identities
Do you put an identity column on every table? That might be a bad habit you want to kick, but not all at once. Steve Jones comments on this common data modeling practice.
Randomizing Result Sets with NEWID
Seth Delconte brings us a technique to solve a common request. Using the NEWID function to return a random record from a result set.
Reaching for the Clouds
This past week's news had a lot of news about cloud computing and Steve Jones comments on a few database related items.
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 Metro Jababeka Call CSO; (+62 821°3111°179
Jababeka, Cikarang, Plaza JCBD Blok A 26, 27 dan 28, Pasirsari, Cikarang Sel., Kabupaten...
BCA KCU GAJAH MADA Telpon/WA:.0851•8812•0691
BCA KCU GAJAH MADA Telpon/WA:.0851•8812•0691 Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman...
BCA KCP Pulogadung,Telpon/WA 0821-3111-159
Jl. Raya Bekasi No.B-C Km.19 No.30, RT.1/RW.6, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
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