SQLServerCentral Best Practices Clinic: Part 2
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
2011-04-13
5,080 reads
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
2011-04-13
5,080 reads
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
2011-03-11
638 reads
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-05
1,313 reads
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
2010-09-06
3,710 reads
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-27
3,072 reads
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
2010-03-05
2,783 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-03-03
1,465 reads
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
By Brian Kelley
Pass or fail, act on your certification test results.
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
I have table: t1 in schema1 with 19 billion records. I have another table...
Comments posted to this topic are about the item Minimally Viable Security
Comments posted to this topic are about the item Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers