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
I see the use of the NOLOCK hint in existing code for my stored procedures and I am not exactly sure if this is helpful or not. It seems like this has been a practice that was put in place and now is throughout all of the code wherever there are SELECT s
SQL Server 2016 introduced a new feature, Temporal Tables, which allow you to keep a historical record of all of the versions of each row in a table. As rows get introduced, changed, and deleted over time, you can always see what the table looked like dur
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.
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...
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