Sites anglophones


Heaps in SQL Server: Part 1 The Basics

Publié le 21 mai 2020 sur simple-talk.com
 

The series so far: Heaps in SQL Server: Part 1 The Basics This article is the beginning of a series of articles about Heaps in Microsoft SQL Server. Heaps are rejected by many database developers using Microsoft SQL Server. The concerns about Heaps are …

[Video] How to Think Like the SQL Server Engine: All-Demo Edition

Publié le 21 mai 2020 sur brentozar.com
 

You’ve heard of my free How to Think Like the Engine class, and maybe you even started watching it, but…it has slides, and you hate slides. Wanna see me do the whole thing in Management Studio, starting with an empty query window and …

Hands-On with Columnstore Indexes: Part 1 Architecture

Publié le 21 mai 2020 sur simple-talk.com
 

Indexes are the key to efficient performance in any relational database. Few index enhancements have been introduced that can improve query speed and efficiency as dramatically as columnstore indexes. Improvements to this feature have been introduced i …

SQL Server 2019 in Containers

Publié le 21 mai 2020 sur sqlservercentral.com
 

The post SQL Server 2019 in Containers appeared first on SQLServerCentral.

The IDENTITY Column Property

Publié le 21 mai 2020 sur sqlservercentral.com
 

Introduction There are a number of ways to generate key values in SQL Server tables, including the IDENTITY column property, the NEWID() function and more recently, SEQUENCES. The IDENTITY column property is the earliest of these methods. It was introd …

Install SQL Server from Configuration File with Installation Center

Publié le 21 mai 2020 sur sqlservercentral.com
 

The post Install SQL Server from Configuration File with Installation Center appeared first on SQLServerCentral.

Parallelism Can Make Queries Perform Worse.

Publié le 20 mai 2020 sur brentozar.com
 

While I was building lab queries for my all-new Fundamentals of Parameter Sniffing course – first live one is next week, still time to get in – I ran across a query with delightfully terrible behavior. I’m always torn when I build the …

Key Insights from the 2020 State of SQL Server Monitoring Report

Publié le 20 mai 2020 sur simple-talk.com
 

This marks the third year that Redgate have launched a survey to better understand how organisations monitor their databases. This year, 971 database professionals from around the world responded. Here are some of the key insights from the survey: Esta …

Try one of our new MySQL candidate screening tests at Kandio!

Publié le 19 mai 2020 sur sqlskills.com - paul randall
 

Continuing our new partnership with Kandio, we now have MySQL assessments for you to try! We’ve been involved in a lot of recruiting processes for our clients and realized we could save everyone time and money by pre-screening candidates. To that …

Can I Offload DBCC CHECKDB To Another Server?

Publié le 19 mai 2020 sur brentozar.com
 

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption che …

Run SQL Server Agent Job from SSIS

Publié le 19 mai 2020 sur sqlservercentral.com
 

The post Run SQL Server Agent Job from SSIS appeared first on SQLServerCentral.

The Products-Often-Purchased-Together Problem Solved in R

Publié le 19 mai 2020 sur sqlservercentral.com
 

Introduction One of the questions a retailing business at some point will certainly ask is: which of my products are often purchased together? We, being the SQL people, probably can wrench the answer by brute force alone, counting all permutations of p …

I’m On the 6 Figure Developer Podcast

Publié le 18 mai 2020 sur brentozar.com
 

The 6 Figure Developer podcast with John Callaway, Clayton Hunt, and Jon Ash covers not just technical topics, but career topics so you can learn to leverage that technical knowledge and build a better career for yourself. I’m on Episode 144 talk …

How I Use Streamlabs OBS for Streaming and Training Classes

Publié le 18 mai 2020 sur brentozar.com
 

I’ve written a lot about the hardware & gear I use for streaming, and now let’s talk about the software side. There are a few thousand words in here. Don’t think that you have to tackle all of this just to get started streaming, d …

Six reasons to version control your database

Publié le 18 mai 2020 sur sqlservercentral.com
 

The post Six reasons to version control your database appeared first on SQLServerCentral.


Pages :