If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this webinar, we will examine the three top public cloud providers and what they have to offe
There are times when I find myself needing to run a SQL command against each database on one of my SQL Server instances. There is a handy undocumented stored procedure that allows you to do this without needing to set up a cursor against your sysdatabases
Sometimes you may have issues connecting to SQL Server and you may get messages such as "Could not open a connection to SQL Server". In this tip we look at different things you can check to resolve this issue.
Yesterday, when I started the SQL Server service, I received the following error message: "SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related proble
Learn about how to achieve SQL Server High Performance and Cost Savings in the Cloud with DataCore Software by enabling your applications to be more responsive and improve the user experience by improving I/O concurrency and reducing I/O latency.
When using a multi-value SSRS report parameter, it can be challenging to create a wildcard character used to run the report without respect for that parameter. In this tip we look at how to solve this challenge.
In this tip we look at how to help troubleshoot SQL Server error Msg 22050, Level 16, State 1, Line 0 Failed to initialize sqlcmd library with error number -2147467259 when using sp_send_dbmail when using a query.
To gain insight into the evolving challenges for DBAs, a study was performed to survey DBAs and those responsible for the management of the corporate data management infrastructure. The more than 200 respondents came from a wide range of industries...
Moving SQL Server from an on-premises data center to a public cloud such as AWS can enable your business to be more agile and more responsive to changing market requirements and customer needs.
We can use regular expressions (sometimes called Regex) with T-SQL to tackle some common problems with data using this tool. In this tutorial, we will practice using regular expressions for filtering precise phrases involving alphabetic, numeric and speci
