Database tips for DBAs and programmers

On September 24th Microsoft released …

Microsoft announced the release or CTP 2.1 for SQL …

If you are not managing the transaction log space used by a database, the transaction …

On Monday, Sep 24, 2018, at the Ignite 2018 conference, Microsoft announced the first …

Have ever tried to debug a chunk of TSQL code (like a stored procedure) and found …

There are times when you might need to look at your SQL Server data in hexadecimal …

When you are setting up a new SQL Server machine you need to determine how big you …

There may be a time when you want to turn off transparent data encryption on one of …

How many times have you had a programmer come to you and say they want you (the DBA) to …

We all know that you should try to size tempdb appropriately, so it doesn’t need …

When a database grows to the MAXSIZE the database will not grow anymore and if someone …

We all know indexes are important for improving your query performance, but to store …

Do all of your tables contain clustered indexes? Some say every table should have a …

Why are you dropping and recreating your indexes, when you could just disable and then …

By looking at a query execution plan, you can determine which steps are used to resolve …

Database User and Programming Tips