9 New Features with SQL Server 2017
Microsoft has added a ton of new features in SQL Server 2017, including expanded operating system support, Graph database capability, Python support, and more. Join Greg Larsen as he explores nine of these new features.
How Redgate use SQL Clone internally to provision databases
A common thread behind the software Redgate develop is a problem or issue they’ve come across in the software development process. They then adopt the software themselves, which gives us a real understanding of the features that need to be develo …
Azure DWH part 19: Backup and Restore SSAS
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
SQL SERVER – Error Due to Database Context – Error 208 – Invalid Object Name
Today, we are going to talk about one of the most popular errors which user see every day. There are many users who often get stuck at this error and have no clue how to move forward with this error in SSMS. It is quite possible you may say this is a v …
What are Forwarded Records in SQL Server? – Interview Question of the Week #145
Question: What are Forwarded Records in SQL Server? Answer: It is interesting to see this question keeps on coming up in the interview questions. Even though this is very old concept, I hardly see new DBAs know about this subject. Let us see the a …
SQL SERVER – How to Create A Global Temporary Table?
Two days ago, I wrote an article SQL SERVER – How to Create Table Variable and Temporary Table? It was a very basic article for beginners. However, to my surprise, I have got tremendous response to that blog post and also got quite a lot of …
Functions in the USQL – the hidden gem in the Summer 2017 Update
Hi SQL Folks, I just written a blog post about the functions and hidden gems in the USQL Summer Refresh 2017 Take a look there. and tell me what you think!!!
French makes everything sound so sexy.
Even error messages:SELECT * FROM sys.messages WHERE language_id = 1036; Produces: Talk dirty reads to me These sound better than anything I would ever write in a romantic letter: “SQL Server a détecté une corruption de m …
Extended Events Profiler (XE Profiler) in SSMS
Starting in SSMS version 15.3, we have an interesting new feature: Extended Events Profiler (XE Profiler). This new feature is in a very early stage, but it seems to be a first step to replace SQL Profiler, which is already deprecated. Two differe …
Overview of Azure Data Lake
Azure Data Lake stores petabytes of data and analyzes trillions of objects in one place with no constraints. Data Lake Store can store any type of data including massive data like high-resolution video, medical data, and data from a wide variety of ind …
SQL SERVER – When to Turn On Optimize for Ad Hoc Workloads?
Today, I have very interesting scenario to share with all of you. This is a true story which I encountered in my recent Comprehensive Database Performance Health Check. It is about a very popular SQL Server setting Optimize for Ad Hoc Workloa …
SQL Server Workarounds
360 Questions We’ve been asking you folks a lot about what you’d add to SQL Server, and we’ve gotten some great answers. There are even some that have been answered in the last couple versions of SQL Server. For instance, 2016 brought …
Simple SQL: Handling Location Datatypes
Where am I? One of the big problems in data processing is in defining locations precisely. We need, for example to know where people live and where organizations operate. You might want to send them mail or packages; it could be that you need some idea …
Discover database DevOps and more at PASS Summit
PASS Summit lands in Seattle from October 31 to November 3 this year, bringing with it the latest thinking and developments in the SQL Server world. This blog post from Annabel Bradford gives the details of what Redgate willl be presenting on, when thi …
SQL Server Performance Benchmarking with Patterns
A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns.