Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.
This Friday's poll asks when types of distractions you might like to have at work that would let you recharge. Answer and let everyone else know what would help you enjoy your job more.
Continuing with his series on changes in SQL Server 2008, Arshad Ali takes a look at table enhancements and new data types.
Understanding the transaction log seems to be a very difficult concept fro mos DBAs to grasp. Jason Brimhall brings us a new article that helps to troubleshoot the cause of log growths.
Does it make sense to publish multiple articles on the same subject? Steve Jones talks about the reasoning behind how SQLServerCentral chooses content.
Why neglecting slowly changing dimensions, failing to capture metadata and overlooking scope creep can be the undoing of a dimensional data warehousing initiative.
Do you write code that writes code? Steve Jones thinks this is one of those milestones that marks the maturity of a DBA.
Is your application scalable under increased activity? Timothy Claason brings us a methodology for testing how your application will deal with database load.
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
If you think through the web sites you visit on a daily basis the chances are that you will need to login to verify who you are. In most cases your username would be stored in a relational database along with all the other registered users on that web site. Hopefully your password will be encrypted and not stored in plain text.
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Comments posted to this topic are about the item How Do the Experts Become...
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Comments posted to this topic are about the item Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers