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 many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti
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