3 Solutions For Auditing Long SQL Server Extracts or Loads
In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.
2017-07-04
3,755 reads
Articles
A General Way to Maintain History Tables
You will see here a way to handle history tables. This way only takes into account Date-based data cleanup but is easily generalizable.
2017-07-03 (first published: 2015-09-28)
12,929 reads
Export data from SQL Server to Excel
What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.
2017-06-30
5,930 reads
Scoring Outliers in Non-Normal Data with R
Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?
2017-06-29
5,590 reads
Azure Automation Methods
Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.
2017-06-29
3,697 reads
Replace Bad Characters in Table
Learn how to clean bad characters from lots of data in this article.
2017-06-28
3,488 reads
Generating HTML from SQL Server Queries
You can produce HTML from SQL because SQL Server has built-in support for outputting XML, and HTML is best understood as a slightly odd dialect of XML that imparts meaning to predefined tags. There are plenty of edge cases where an HTML structure is the most obvious way of communicating tables, lists and directories. Where data is hierarchical, it can make even more sense. William Brewer gives a simple introduction to a few HTML-output techniques.
2017-06-28
5,489 reads
Filegroup Restoring and Database Consistency
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
2017-06-27
3,642 reads
How to Read the Transaction Log File
Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function.
2017-06-27
4,882 reads
Workplace Encounters: Using Volume Mount Points in SQL FCIs
How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points
2017-06-26
1,024 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 Duta Gardenia,Telp/Wa 0821.3111.159
Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda, Kota...
BCA KCP Rawasari Tlpn/wa:085373737551
Jl. Rawasari Sel. No.24 A, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Bandara S/H Term D,Telp/Wa 0821.3111.159
Terminal 2, Gate 3, Pajang, Kedatangan, Tangerang City, Banten 15126
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