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
Articles
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
CPU and Scheduler Performance Monitoring using SQL Server and Excel
This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.
2012-10-04
9,787 reads
Matrix Math in SQL
Relational Datbases have tables as data structures, not arrays. This makes it tricky and slow to do matrix operations, but it doesn't mean it is impossible to do. Joe gives the Celko Slant on how to go about doing Matrix Math in SQL.
2012-10-04
3,741 reads
What a View
I need to create views? How many? Today? This article talks about a few issues with using views too extensively in your design.
2012-10-02
7,756 reads
Protecting the SQL Server Backup folder
I want to backup my SQL Server databases to a folder, but I want to minimize who has access to the folder. In other words, I want to make sure that members of the Windows Local Administrators group don't get to the backups without intentionally trying to bypass the security. How do I do that?
2012-10-02
3,264 reads
Report Builder 3.0: Formatting the Elements in your Report
There is a lot that can be done to make basic tabular reports more readable, using Microsoft's free Report Builder. Rob Sheldon continues his exploration of the power of this tool by showing how to format various elements within reports
2012-10-01
3,173 reads
A simple T-SQL statement to create a list of lookup values
In this article, we provide a simple way to get a comma delimited list from a table of entries without having to use a CURSOR or a WHILE loop to read through the table.
2012-09-28 (first published: 2011-03-21)
34,405 reads
Data Access Tracing in SQL Server 2012
Learn how to apply the tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server database engine.
2012-09-28
2,897 reads
An Interview with Amazon Web Services
A short interview with Sundar Raghavan of Amazon Web Services about SQL Server and their support and offerings of cloud data services.
2012-09-27
1,587 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kontak resmi BCA KCU PURWOKERTO | Telp: 0817825533
phone, Wa: 0817825533, Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten...
Kantor BCA Finance pusat Hub.0851•8812•0691
Kantor BCA Finance pusat Hub.0851•8812•0691 Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd....
Alamat kontak resmi BCA KCU PEKALONGAN | Telp: 0817825533
phone, Wa: 0817825533, Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah...
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