As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.
2007-11-16
4,384 reads
Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.
2007-11-15
3,708 reads
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
2007-11-15
3,442 reads
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.
2007-11-14
1,887 reads
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
2007-11-14
1,601 reads
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
2007-11-13
2,997 reads
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
2007-11-13
1,635 reads
Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
2007-11-12
2,975 reads
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
2007-11-12
2,406 reads
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
2007-11-09
1,458 reads
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...
Comments posted to this topic are about the item T-SQL Fundamentals