Sites anglophones


Using Custom Deployment Scripts with SQL Compare or SQL Change Automation

Publié le 18 novembre 2019 sur sqlservercentral.com
 

The post Using Custom Deployment Scripts with SQL Compare or SQL Change Automation appeared first on SQLServerCentral.

Collections

Publié le 18 novembre 2019 sur sqlservercentral.com
 

Problem The usage of a collection of integers in some scenarios is considered to be optimal because of the overhead involved by the creation of another user table used just to store numbers, which is the most common solution. What are collections of in …

Merging tables in Power BI dataflows with PRO subscription

Publié le 18 novembre 2019 sur sqlservercentral.com
 

The post Merging tables in Power BI dataflows with PRO subscription appeared first on SQLServerCentral.

Glenn’s Tech Insights For November 17, 2019

Publié le 17 novembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Tech Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally releva …

Glenn’s Technical Insights For November 17, 2019

Publié le 17 novembre 2019 sur sqlskills.com - glen berry
 

(Glenn’s Technical Insights… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can get more visibility. It covers interesting new hardware and software developments that are generally r …

How to Determine Read Intensive and Write Intensive Tables in SQL Server? – Interview Question of the Week #251

Publié le 17 novembre 2019 sur journey to sqlauthority
 

Question: How to Determine Read Intensive and Write Intensive Tables in SQL Server?Answer: I was really asked this question in the recent consulting engagement. What I love most about my job as a Comprehensive Database Performance Health Check is …

So, uh, you can, like, draw me in SSMS.

Publié le 16 novembre 2019 sur brentozar.com
 

Adrian Sullivan and Michael J. Swart have way too much time on their hands, because Adrian just posted this T-SQL gist, which draws … me: It uses the spatial results feature in SSMS. My mind is blown. I’m totally going to use that in a dem …

SQL SERVER – Create Index Without Locking Table

Publié le 16 novembre 2019 sur journey to sqlauthority
 

Indexes are the last option we consider when we do a Comprehensive Database Performance Health Check. 3 out of 4 clients, I work on the health check, we end up not creating new indexes. Most of the time we spend time looking at the indexes when removed …

AMD Ryzen 9 3950X Processor Released

Publié le 15 novembre 2019 sur sqlskills.com - glen berry
 

IntroductionOn November 14, 2019, the review embargo for the AMD Ryzen 9 3950X mainstream desktop processor expired. As a result, there were a flood of written and video reviews of AMD’s new flagship processor for the mainstream market segment. T …

I’m coming to SQL Saturday Stockholm! Registration is open now.

Publié le 15 novembre 2019 sur brentozar.com
 

Hello again, Sweden! I’m coming to SQL Saturday Stockholm in May 2020. I’ll be teaching my Performance Tuning in 21 Demos workshop: You’re a developer or DBA who wants to tune indexes and queries to make your application go faster. Yo …

MariaDB Learning Path – Five Online Pluralsight Courses

Publié le 15 novembre 2019 sur journey to sqlauthority
 

I am very delighted to announce that I have just published five video courses on the Pluralsight about Learning MariaDB. I am indeed very delighted to share my suggestion about MariaDB Learning Path.MariaDB Learning PathCourse 1: Querying Data from Mar …

New release: SQL Prompt 10

Publié le 15 novembre 2019 sur sqlservercentral.com
 

The post New release: SQL Prompt 10 appeared first on SQLServerCentral.

How to Configure CI/CD in AzureDevOps

Publié le 15 novembre 2019 sur sqlservercentral.com
 

The post How to Configure CI/CD in AzureDevOps appeared first on SQLServerCentral.

SQL ConstantCare® Now Gives Index Advice, Too.

Publié le 14 novembre 2019 sur brentozar.com
 

When I was a DBA, I got so sick and tired of monitoring tools and scripts yelling at me to make a million different changes – most of which didn’t really have any measurable impact on performance or reliability. Sure, I want things to go fa …

SQL SERVER – Find the Growth Size for All files in All Databases – Part 2

Publié le 14 novembre 2019 sur journey to sqlauthority
 

A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. The original script had some error related to counting the size as pointed out by the SQL Server expert John Fowler, however, I never got around to correct …


Pages :