Sites anglophones


Key findings from the State of SQL Server Monitoring

Publié le 16 juillet 2019 sur sqlservercentral.com
 

The post Key findings from the State of SQL Server Monitoring appeared first on SQLServerCentral.

SQL and T-SQL for Beginners in 229 minutes

Publié le 16 juillet 2019 sur sqlservercentral.com
 

Learning SQL is not difficult. However, you need to spend a few hours or a few days to learn the basics. On this site you can find a lot of interesting articles, but you need to know the basics of SQL or T-SQL. If you’re new to this site and some artic …

SQL Server and Excel Hierarchyid Example for Organization Charts

Publié le 16 juillet 2019 sur sqlservercentral.com
 

charts The post SQL Server and Excel Hierarchyid Example for Organization Charts appeared first on SQLServerCentral.

Glenn’s Tech Insights For July 15, 2019

Publié le 15 juillet 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 …

Modeling Time

Publié le 15 juillet 2019 sur simple-talk.com
 

Time is an interesting thing. It moves in only one direction; it’s units of measurement are irregular and constantly in motion. When we go to model it in SQL, it’s usually easier to do lookup tables (calendars) rather than trying to compute …

Welcome to the DBA Training Plan.

Publié le 15 juillet 2019 sur brentozar.com
 

Foreword: 8 years ago, I launched an email series with a 6-Month DBA Training Plan. I sent one email per week, bringing people up to speed on the most important topics that nobody taught ’em along the way. It’s hard to believe it’s be …

SQL SERVER – Microsoft Official Support End Dates for Different Versions

Publié le 15 juillet 2019 sur journey to sqlauthority
 

Earlier this week, Microsoft SQL Server 2008 and 2008 R2 support ended. Lots of people were caught unaware of the same. Last two weeks has been extremely busy for me as lots of organizations have been procrastination of the SQL Server upgrade and sudde …

Politics makes for bad databases – plus calculate British holidays

Publié le 15 juillet 2019 sur sqlservercentral.com
 

I have recently been reflecting on how politics frequently adversely affects databases, and is the cause of change. It might seem obvious to expand this concept to reflect on how politics seems to adversely affect many other things, but this is a place …

How to Find Definition of Computed Column in SQL Server using T-SQL? – Interview Question of the Week #233

Publié le 14 juillet 2019 sur journey to sqlauthority
 

Question: How to Find Definition of Computed Column in SQL Server using T-SQL?Answer: A very fair question, I received the other day SQL Server Performance Tuning Practical Workshop. I really love simple questions which require a small amount of resear …

Puzzle – DELETE Qualified Rows From Multiple Tables – Win USD 1000 Worth Class

Publié le 13 juillet 2019 sur journey to sqlauthority
 

It has been a while since we have had a puzzle on this blog post, so today we are going to see a very simple but brain teaser puzzle. This puzzle is about Deleting Qualified Rows From Multiple Tables. This question was actually asked to me by my client …

Presenting at PASS Summit 2019

Publié le 12 juillet 2019 sur sqlskills.com - glen berry
 

I am honored to have been selected to present two sessions at the PASS Summit 2019 in Seattle, WA. This year, I have a half-day session and a regular, general session.My half-day session is Dr. DMV’s Troubleshooting Toolkit, and here is the abstr …

SQL SERVER – Using Memory-optimized Tables and Native Stored Procedures – Video Course

Publié le 12 juillet 2019 sur journey to sqlauthority
 

I am happy to announce that I have just published my recent SQL Server Performance Tuning video course on Pluralsight on the topic – Using Memory optimized Tables and Native Stored Procedures.The In-Memory OLTP feature adds a new memory-optimized …

Loading data into SQL Data Warehouse

Publié le 12 juillet 2019 sur sqlservercentral.com
 

The post Loading data into SQL Data Warehouse appeared first on SQLServerCentral.

Training Class Update: Fancier Audio/Video Setup

Publié le 11 juillet 2019 sur brentozar.com
 

I’m constantly looking for ways to raise my game, so I made some investments this month to take my video class audio & video to the next level. I’m now doing green screen effects on the recordings. I picked up an Elgato retractable gree …

Impact of DBCC DROPCLEANBUFFERS on Memory – SQL in Sixty Seconds #085

Publié le 11 juillet 2019 sur journey to sqlauthority
 

Some concepts are so good in SQL Server, they keep on coming back to me one way or another way. After reading my recent blog posts about DBCC DROPCLEANBUFFERS lots of people wanted to see the demonstration of the same. In this SQL in Sixty Seconds vide …


Pages :