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
Articles
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,404 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
SQL Database Management Survey
Win one of two $50 Amazon vouchers by entering our database management survey. We’re finding out more about how SQL database professionals are doing backup and recovery, using cloud services and more. Answer the short survey for a chance to win.
2012-09-27 (first published: 2012-09-24)
2,706 reads
Ten Things I Wish I'd Known When I Started Using tSQLt and SQL Test
The tSQLt framework is a great way of writing unit tests in the same language as the one being tested, but there are some 'Gotchas' that can catch you out. Dave Green lists a few tips he wished he'd read beforehand.
2012-09-27
2,973 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 Kalimalang. Tlp:085373737845
Jl. Inspeksi Kav. PTB Blok A 2 No. 2 C-D, RT.1/RW.4, Pd. Klp., Wil,...
BCA KCP Morowali Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Trans Sulawesi, Keurea, Kec. Bahodopi, Kabupaten Morowali, Sulawesi Tengah 94974
BCA KCP Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
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