Tony Davis

Testing times

Databases are unique in IT that they are singularly resistant to 'best practice' advice. Any such advice can never be anything other than a starting position for tests in your own environment.

2012-01-23

45 reads

Blogs

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

Read the latest Blogs

Forums

How to apply rank when fetching data from table using sql query?

By manavairajan

Hi Everyone, I need your help to get the required results. I want to...

Compare two databases

By Jai-SQL DBA

Hi ,   What are the parameters to compare two databases if migrated from...

DB goes into not sync / suspect after a manual failover

By Syed_SQLDBA

After the patching, one of the database goes into Not synchronizing / suspect state....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers