How to Unclog SQL Server
In this article, learn how one DBA solved a query timeout issue with an application by examining the effects that different temporary objects have on query performance.
The Problem with Users
Users cause lots of security issues, and we ought to try to work within that framework, with the understanding the we can't prevent all problems.
Worst Practices - Objects Not Owned by DBO
Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!
Worst Practices - Part 1 of a Very Long Series!
Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!
3 ways Managed Services Providers can offer more value
Redgate's Will Sharman explores ways that database MSPs can save time, minimize effort and work more efficiently, while at the same time providing more value to their customers.
Polling and Survey Data Transparency
Polls and surveys are increasing in use. If you are a DBA, developer, or data scientist, then it is good to understand how to structure your systems for transparency and proper use.
Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory
Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.
Fill In Missing Dates for SQL Server Query Output
In this tip we look at how to fill gaps in dates and times for SQL Server query output when no data exists for specific dates or times.
SQL Change Automation Scripting: Getting Data into a Target Database
Your strategy for loading a freshly built database with data will depend on how much you need. If just a few rows, then single-row INSERT statements will be fine, but for more than that you'll need to build insert the rows using native-format BCP. Fortunately, SQL Change Automation (SCA) can be used with either strategy, as Phil Factor demonstrates.
Scaling SSRS Support for SQL Azure with Containers
In this article, see one of the ways in which a container can be created and used for in SSRS as the source for reports.
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 KCU PURI INDAH Telpon/WA.0853•5504•2311
BCA KCU PURI INDAH Telpon/WA.0853•5504•2311 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya...
BCA KCP Pulau Brayan NO TELPON 087781685658
WHATSAPP 087781685658 Jl. KL. Yos Sudarso No.223 J, Pulo Brayan Kota, Kec. Medan Bar.,...
BCA KCP Pingit Telpon. 083135766741
WhatsApp 083135766741 Km. 4 No. 204, Jl. Magelang, Rogoyudan, Sinduadi, Kec. Mlati, Kabupaten Sleman,...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers