Sites anglophones


Free Fundamentals of Index Tuning Week: Part 5, Recap

Publié le 28 février 2020 sur brentozar.com
 

Whew. You’ve learned a lot. (Well, I’ve tried to teach you a lot, anyway.) Here’s what we covered this week: Indexing for the WHERE Clause, then we covered Indexing for ORDER BY (and layering in filters as well) Indexing for JOINs SQL …

SQL SERVER – Displaying Smiley in SSMS – Emoji

Publié le 28 février 2020 sur journey to sqlauthority
 

Recently I had an interesting conversation with my client about Emoji in SQL Server. The question from my client was about is there any way he can name his database which contains smiley. Absolutely it is possible to create your database with any emoji …

Introduction to Azure SQL Database Auto-Failover Groups

Publié le 28 février 2020 sur sqlservercentral.com
 

The post Introduction to Azure SQL Database Auto-Failover Groups appeared first on SQLServerCentral.

Mean Median Mode using SQL and DAX

Publié le 28 février 2020 sur sqlservercentral.com
 

Introduction In this article, I’m going to introduce the basics of the Statistical Functions – Mean, Median and Mode and how can these be calculated using SQL and DAX. The mean, median and mode are the three most widely used kinds of « averages » in stat …

Enterprise Insights from the 2020 State of Database DevOps report

Publié le 28 février 2020 sur sqlservercentral.com
 

The post Enterprise Insights from the 2020 State of Database DevOps report appeared first on SQLServerCentral.

SQL SERVER – TempDB and Trace Flag 1117 and 1118 – Not Required

Publié le 27 février 2020 sur journey to sqlauthority
 

Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. Recently I was hired by a large banking firm to help them with the Comprehensive Database Performance Health Check.Trace Flag 1117 and 1118 – Not RequiredThe ba …

Exploring the DATE Functions in SQL

Publié le 27 février 2020 sur sqlservercentral.com
 

Introduction Dealing with Dates in SQL has been quite fascinating for me. Often, I’ve come across newbies who find it quite challenging to understand the way dates work in SQL Server. Especially, when it comes to using different date functions related …

The Curious Case of… whether corruption can propagate to secondary databases

Publié le 26 février 2020 sur sqlskills.com - paul randall
 

(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working …

SQL SERVER – Error 15580 – Cannot Drop Master Key Because Dialog “GUID” is Encrypted by It

Publié le 26 février 2020 sur journey to sqlauthority
 

Sometimes I get amazed by the speed at which the search engine crawls and gets the right results. A few days ago, I wrote a blog about a UI error in Always On availability group. Someone found that blog, followed it, got another error and contacted me …

SQL SERVER – Drivers for DevOps – Efficient Monitoring

Publié le 25 février 2020 sur journey to sqlauthority
 

At SQL Authority, my main job is to work with SQL Server Performance Tuning, and every day I learn that more organizations are implementing DevOps for their database platform. DevOps is a collaborative approach to software development and delivery that …

Introduction to Indexed Views in SQL Server

Publié le 25 février 2020 sur sqlservercentral.com
 

Introduction Usually, when a view is created in the SQL Server database, it is just a virtual table (not stored on disk) that might fetch results from one or more underlying physical tables (stored on disk). Views are mainly created to maintain securit …

Free Fundamentals of Index Tuning Week: Part 1, Indexing for the WHERE Clause

Publié le 24 février 2020 sur brentozar.com
 

I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. I was go …

SQL SERVER – Unable to Allocate Enough Memory to Start ‘SQL OS Boot’. Reduce Non-essential Memory Load or Increase System Memory

Publié le 24 février 2020 sur journey to sqlauthority
 

One of my clients, contacted me to fix one of the errors which they received while starting SQL Service. In this blog, I would share my learning about error “Unable to allocate enough memory to start ‘SQL OS Boot’. Reduce non-essentia …

Deployment Suite for Oracle: What’s New?

Publié le 24 février 2020 sur sqlservercentral.com
 

The post Deployment Suite for Oracle: What’s New? appeared first on SQLServerCentral.

Saving Game Data with Unity

Publié le 24 février 2020 sur sqlservercentral.com
 

The post Saving Game Data with Unity appeared first on SQLServerCentral.


Pages :