I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
The idea of using more unit tests to improve code quality has been around for some time. However Steve Jones notes today that some people use tests for documentation.
Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.
Phil Factor demonstrates how to tackle builds when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
In this article we look at how to run SQL Server queries with Entity Framework Core using the DbSet.FromSql method, parameterized queries, stored procedures and using the Database.ExecuteSqlCommand property.
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
With SQL Server 2019 on the way, it’s time to begin learning about all the new features. In this article, Dennes Torres demonstrates how to use the new SHORTEST_PATH function that is part of the Graph Database feature.
Database deployments, like the sheep of exasperated hill-farmers, often find strange and unexpected ways to self-destruct. Phil Factor describes the most common things that can go wrong, and how a reliable automated database build process can prevent messy accidents.
Learning how an organization, or even just a codebase, works can be a challenge for new employees.
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
By Arun Sirpal
In the previous blog post I did a quick overview building a SQL VM...
By Ed Elliott
It has been a little while but I have updated SQLCover to include a...
Buy Tramadol CLICK HERE-->> http://searchsbest.com/?q=Tramadol Top offers Tramadol online CLICK HERE--> http://searchsbest.com/?q=Tramadol pet health...
Hi All, Need some help in exception handling. In below code, I want to...
Hi, I am taking full backup of db on remote location. The issue we...
Ask SSC