(Jack Vamvas) Question:Post disaster recovery SQL Server database checkout script is required.I need to iterate through hundreds of SQL Server Instances with thousands of databases and return in a readable format the status and if there is any database corruption?
Tag: sql server
SQL DBA – Query to check Status of last running SQL Jobs
(Manoj Pandey) To check the status of current running jobs you can use the “Job Activity Monitor” feature in SSMS, but sometimes opening and refreshing the tool takes time.
Introduction to Azure Cosmos DB
(Anoop Kumar) Azure Cosmos DB is one of the latest cloud based service offerings from Microsoft. Azure Cosmos DB is a superset data service of DocumentDB. Earlier, Microsoft offered DocumentDB as Data as a Service (DaaS), which supported a limited set of features and functionalities.
SQL Server sp_execute_external_script Stored Procedure Examples
(Vitor Montalvao) The sys.sp_execute_external_script is a new system stored procedure introduced in SQL Server 2016. It intends to execute any provided script at an external location. Microsoft says that the script must be written in a supported and registered language, but actually the only support
Azure Function – take it to the limit, scale it up
(benjamin perkins) Azure Functions are really cool #AzureFunction. I wrote numerous articles about Azure Functions here, check them out. As you know there are 2 kinds of Azure Functions:
Data lake details
(James Serra) I have blogged before about data lakes (see What is a data lake? and Why use a data lake?), and wanted to provide more details on this popular technology, some of which I cover in my presentation “Big data architectures and the data lake“.
SQL SERVER – Error: Timeout (30000 milliseconds) Waiting for the SQL Server (MSSQLSERVER) Service to Connect
(Pinal Dave) I have been dealing with a client who observed that SQL services not starting up after a server reboot. When I asked them to check event logs, they found below timeout error.
Database Fundamentals #5: Database Properties
(Grant Fritchey) Don’t let the ease of creating databases lull you into a false sense of security. They actually can be very complicated. You can modify and individualize their behavior within your server so that different databases behave in radically different ways.
Data Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks
(Chris Webb) So far in this series, I have shown how changing the data privacy settings for a data source can affect the performance of queries and even prevent them from executing completely.
Azure Cosmos DB Rising in Latest DB-Engines Monthly Rankings
(Thomas LaRock) The latest DB-Engines Database Rankings are available, and it shows that Microsoft continues to gain ground on Oracle/MySQL: I’ve been following the DB-Engines ranking for a few years and would encourage you to do the same. The rankings are not an exact science. You can read for your
