Sites anglophones


SQL SERVER – Global Variable @@DEF_SORTORDER_ID – Old and May be Deprecated

Publié le 2 mai 2019 sur journey to sqlauthority
 

I always blog about things which are new and updated but today we are going to write about something which is very old and it is near deprecated. We are going to about the global variable @@DEF_SORTORDER_ID. Let us see what it is and how it was used on …

Introduction to SQL Server Security — Part 5

Publié le 2 mai 2019 sur sqlservercentral.com
 

The post Introduction to SQL Server Security — Part 5 appeared first on SQLServerCentral.

A Self-Serve System to Refresh Databases – Part 1

Publié le 2 mai 2019 sur sqlservercentral.com
 

I am not sure I could count the number of times I have restored a backup from production to a test or dev server. It has happened enough times I finally wrote a system so the developers could do it themselves. This series of articles will review this s …

Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?

Publié le 1 mai 2019 sur brentozar.com
 

2002: Me and Bailey, mom’s Great Dane When I was thinking about this site’s 17th birthday, I started wondering: back in 2002, what bug might I have been working with in SQL Server? I started reading back to the list of bugs fixed in SQL Ser …

Recorded Class Instant Learning – SQL Server Performance Tuning Practical Workshop

Publié le 1 mai 2019 sur journey to sqlauthority
 

SQL Server Performance Tuning Practical Workshop is one of my most popular training.  Every month I get tons of request to deliver this class but there is a limitation of how many classes, I can deliver in person. This class is built on my most po …

SQL Server Trigger on View Example

Publié le 1 mai 2019 sur sqlservercentral.com
 

The post SQL Server Trigger on View Example appeared first on SQLServerCentral.

SQL in the City Summits – US & Down Under

Publié le 1 mai 2019 sur sqlservercentral.com
 

The post SQL in the City Summits – US & Down Under appeared first on SQLServerCentral.

The Curious Case of… trying to find an MDF file in a RAW disk

Publié le 30 avril 2019 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 …

Oracle for Absolute Beginners: Problem-Solving as a New Developer

Publié le 30 avril 2019 sur simple-talk.com
 

Hi.  My name is David. If you’ve heard of me, there’s a good chance it’s from my Oracle for Absolute Beginners series which I write for Simple Talk. (Either that, or you got here from googling the famous NFL sportsman who has the …

Updated First Responder Kit and Consultant Toolkit for April 2019

Publié le 30 avril 2019 sur brentozar.com
 

This month, lots of improvements and bug fixes, including checking for paused resumable index operations, Evaluation Edition expiration dates, sp_BlitzCache shows the number of duplicated plans for each query, sp_BlitzIndex will skip a list of database …

What is Automation?

Publié le 30 avril 2019 sur simple-talk.com
 

Today I got a bit closer to a meaningful definition of automation as it applies to the software development process. I’ve been turning this concept over in my head for a while, which is partly related to the dreaded question of licensing. Why sho …

DBA Fundamentals – 3 Performance Tuning Tricks you Always Wanted to Know

Publié le 30 avril 2019 sur journey to sqlauthority
 

Today we will see a free online video which I did for DBA Fundamentals Virtual Chapters for PASS. The title of the video is 3 Performance Tuning Tricks you Always Wanted to Know.Here is the abstract of the same session:No one wants the slow performance …

Row Pattern Recognition in SQL

Publié le 30 avril 2019 sur sqlservercentral.com
 

The post Row Pattern Recognition in SQL appeared first on SQLServerCentral.

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

Publié le 30 avril 2019 sur sqlservercentral.com
 

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Service …

Glenn’s Tech Insights For April 29, 2019

Publié le 29 avril 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 …


Pages :