Sites anglophones


Free Video: 300-Level Guide to Career Internals: Planning Your Career

Publié le 17 juin 2021 sur brentozar.com
 

Erika applies a mask to me at the Blue Lagoon Hi. I’m writing this from a cottage in Iceland, in the midst of a 9-month digital nomad stint. I’m teaching classes and doing client work for 1-2 weeks, then Erika and I take off and hit the roa …

Managing SQL Snippet Collections using JSON and PowerShell

Publié le 16 juin 2021 sur sqlservercentral.com
 

The post Managing SQL Snippet Collections using JSON and PowerShell appeared first on SQLServerCentral.

SQL Server and hyperconvergence

Publié le 15 juin 2021 sur simple-talk.com
 

A growing number of organizations have deployed hyperconverged infrastructure (HCI) systems in an effort to simplify IT operations, better utilize resources, and lower costs. They might house the systems in their own data centers, colocation facilities …

What does SET NOCOUNT ON do?

Publié le 15 juin 2021 sur brentozar.com
 

When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. I …

Embed Power BI in Jupyter Notebooks

Publié le 14 juin 2021 sur simple-talk.com
 

Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle of this exciting feature, what comes to my mind is: “Why do we need this?” I’m far from being a Jupyter noteboo …

How Can Redgate Tools Help with a Cloud Migration?

Publié le 14 juin 2021 sur sqlservercentral.com
 

The post How Can Redgate Tools Help with a Cloud Migration? appeared first on SQLServerCentral.

How to Find Unused Databases in SQL Server

Publié le 14 juin 2021 sur sqlservercentral.com
 

The post How to Find Unused Databases in SQL Server appeared first on SQLServerCentral.

Introduction to generic Power BI themes

Publié le 11 juin 2021 sur simple-talk.com
 

Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower users. It has come to dominate the analytics arena with its ease of use, wide range of connectivity options, and the variety of available visuals …

Download the Current Stack Overflow Database for Free (2021-06)

Publié le 11 juin 2021 sur brentozar.com
 

Stack Overflow, the place where most of your production code comes from, publicly exports their data every couple/few months. @TarynPivots (their DBA) tweets about it, and then I pull some levers and import the XML data dump into SQL Server format …

The four best features to look out for in SQL Monitor

Publié le 11 juin 2021 sur sqlservercentral.com
 

The post The four best features to look out for in SQL Monitor appeared first on SQLServerCentral.

Simple Talk Storage 101 by Robert Sheldon

Publié le 11 juin 2021 sur sqlservercentral.com
 

The post Simple Talk Storage 101 by Robert Sheldon appeared first on SQLServerCentral.

“I’m getting index seeks. Why are my row estimates still wrong?”

Publié le 10 juin 2021 sur brentozar.com
 

If you’ve got good indexes to support your query, and statistics to help SQL Server guess how many rows will come back, how can SQL Server still come up with terribly incorrect row estimates? To demonstrate, I’ll use the 2018-06 version of …

SQL Server Resource Governor Game

Publié le 9 juin 2021 sur sqlservercentral.com
 

The post SQL Server Resource Governor Game appeared first on SQLServerCentral.

SQL Server transaction log architecture

Publié le 8 juin 2021 sur simple-talk.com
 

The transaction log is a file that each SQL Server database has. It can be thought of as a journal of update activity that has occurred to a database. The transaction log is used to maintain the integrity of the database. The information stored about a …

How to Patch SQL Server

Publié le 8 juin 2021 sur brentozar.com
 

Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that you’re going to be doing a lot, so let’s get good at it! Here’s the strategy I like to use. Pick what patch you’re going to ap …


Pages :