Before you can document your SQL Server environment with SQL Power Doc you'll to meet the following requirements: Permissions - SQL Power Doc makes connections to standalone SQL Server instances using ...

Of course, it’s frustrating to discover a corrupted database on your SQL Server for apparent reasons. You can’t access the information, and your work stops. However, you can fix this problem in many ...

Sometimes, you may be unable to perform a sync on the server. Maybe you’re trying to sync a resource that doesn’t exist, or maybe you’ve got too much data and ...

Partitioning tables and indexes in SQL Server is a way to organize table or index data into smaller units based on the values of certain columns. We can use SQL Server Management Studio or ...

All functions require the sysadmin role. The OLE DB ADSI provider limitation: Multi-valued attributes cannot be retrieved ex. "description" or "memberof". Will cause "Could not convert the data value ...

The SQL Server transaction log and the respective log sequence numbers (LSNs) play an important role in recovering deleted table data. A transaction log records all the transactions, data ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

If you are asking “GUI-what?”, not to worry, you aren’t alone. A GUID is a Globally Unique Identifier that helps manage the relational data in the Common Data Service for Apps and SQL Server.