SQLSaturday #153 - Salt Lake City 2012
A free one day training event in Salt Lake City, Utah on Oct 20, 2012.
2012-10-11
2,057 reads
Articles
Improve Your Database Unit Testing Skills and Win Free Stuff
As the SQL Developer community grows to embrace the benefits of test-driven development for databases, so the importance of learning to do it properly increases. One way of learning effective TDD is by the use of code kata – short practice sessions that encourage test-first development in baby steps. I have a limited number of licences for SQL Test to give away free – just for practicing a bit of TDD and telling me about it.
2012-10-10 (first published: 2012-09-19)
5,923 reads
PowerShell script to find files that are consuming the most disk space
As you know, SQL Server databases and backup files can take up a lot of disk space. When disk is running low and you need to troubleshoot disk space issues, the first thing to do is to find large files that are consuming disk space. In this article I will show you a PowerShell script that you can use to find large files on your disks.
2012-10-10
3,714 reads
Webinar: Temporary Tables in Oracle and SQL Server
Once again Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables. Will they agree on some common ground? Or will it be an out and out argument? Either way, be prepared for a lively exchange that will not only entertain, but will teach you key concepts on Oracle and SQL Server.
2012-10-10 (first published: 2012-09-13)
7,268 reads
Getting Started with the New Column Store Index of SQL Server 2012
Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index.
2012-10-09
3,471 reads
TSQL Challenge 83 - Compare rows in the same table and group the data
The challenge is to compare the data of the rows and group the input data. The data needs to be grouped based on the Product ID, Date, TotalLines, LinesOutOfService.
2012-10-08
1,846 reads
Importing Data From Excel Using SSIS - Part 1
Recently while working on a project to import data from an Excel worksheet using SSIS, I realized that sometimes the SSIS Package failed even though when there were no changes in the structure/schema of the Excel worksheet. I investigated it and I noticed that the SSIS Package succeeded for some set of files, but for others it failed. I found that the structure/schema of the worksheet from both these sets of Excel files were the same, the data was the only difference. How come just changing the data can make an SSIS Package fail? What actually causes this failure? What can we do to fix it?
2012-10-08
3,887 reads
Temporary Tables in Oracle and SQL Server
Jonathan Lewis (Oracle Ace Director, OakTable Network) and Grant Fritchey (Microsoft SQL Server MVP) will host a live discussion on Oracle and SQL Server, this time in relation to temporary tables.
2012-10-08 (first published: 2012-09-27)
5,894 reads
Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
22,229 reads
Data Quality Services Performance Best Practices Guide
This guide details high-level performance numbers expected and a set of best practices on getting optimal performance when using Data Quality Services (DQS) in SQL Server 2012 with Cumulative Update 1.
2012-10-05
1,697 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 Semanggi Tlp (+62 821°3111°179
Wisma GKBI, Jl. Jend. Sudirman No.28 14, RT.14/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota...
BCA KCU THAMRIN,Telp/Wa 0821.3111.159
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Aneka Subur Jatake Tlpn/wa:085373737551
Tlpn/wa:085373737551 Ruko Boulevard Business Center Blok A No. 2, Kel, Gandasari, Kec. Jatiuwung, Kota...
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