SQL Server Tips And Tricks

Once you have installed SQL Server 2016, you need to configure the server so that the performance is excellent with also making it highl...

When I create a new stored procedure, I tend to use the following code, use it and modify it as much as you like. CREATE PROC usp_tes...

As I try to do mainly do SQL Development and not SQL DBA, it's still useful to know useful DBA commands that you may need to perform...

If you have read the previous blog posts, I have outlined what Azure databases are and how you should use them. With SQL Server 2016, yo...

With Azure, you can also have SQL Server Data Warehouses. This is a great idea if your environment is several gigabits large and you wan...

With SQL Server 2016 , it now has the ability to stretch your database to the cloud to a Microsoft Azure SQL Database. Stretching your...

If you want to know a lot of information about in-memory OLTP in SQL Server, then watch these two videos. They both explain how and when to ...