Sites anglophones


Using the SQL Monitor Estate Pages

Publié le 8 avril 2019 sur sqlservercentral.com
 

The post Using the SQL Monitor Estate Pages appeared first on SQLServerCentral.

How are you using tools to design and model databases?

Publié le 8 avril 2019 sur sqlservercentral.com
 

The post How are you using tools to design and model databases? appeared first on SQLServerCentral.

Introduction to SQL Server Security — Part 4

Publié le 8 avril 2019 sur sqlservercentral.com
 

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

How to Compile Queries and Not Execute Them? – Interview Question of the Week #219

Publié le 7 avril 2019 sur journey to sqlauthority
 

Question: How to Compile Queries and Not Execute them?Answer: Have you ever heard this question before? Honestly, I have heard it before and I even wrote about this on this blog many years ago. Here are two of the earlier example.SQL SERVER – Wha …

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘SSIS_hotfix_install.sql’ Encountered Error 15151

Publié le 6 avril 2019 sur journey to sqlauthority
 

Recently I was helping a client where SQL Server upgrade was failing with an error. If you have seen my blogs, there have been many blogs where I explain steps to fix upgrade-related issues. In this blog, we would learn about fixing another cause of sc …

SQL SERVER – Error in Validation: Listener in Workgroup – Unable to determine if the computer exists in the domain ‘WORKGROUP’

Publié le 5 avril 2019 sur journey to sqlauthority
 

There are many deployments where I have assisted my clients in creating Always On Availability Groups. Sometimes they come to me with special requirements, based on their infrastructure, and I always learn from them. In this situation, my client was tr …

A Database Developer’s Guide to SQL Clone

Publié le 5 avril 2019 sur sqlservercentral.com
 

The post A Database Developer’s Guide to SQL Clone appeared first on SQLServerCentral.

SQL SERVER – Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step ‘msdb110_upgrade.sql’ Encountered Error 8649, State 1, Severity 17

Publié le 4 avril 2019 sur journey to sqlauthority
 

While trying to upgrade my SQL instance to the latest patch of SQL 2017, I encountered an issue. This has happened earlier with a few of my clients earlier but this time the cause was different. In this blog we would learn about cause and the fix of up …

Crosstab queries using PIVOT in SQL Server

Publié le 4 avril 2019 sur sqlservercentral.com
 

The post Crosstab queries using PIVOT in SQL Server appeared first on SQLServerCentral.

How to Monitor IDENTITY columns to prevent unplanned downtime

Publié le 4 avril 2019 sur sqlservercentral.com
 

The post How to Monitor IDENTITY columns to prevent unplanned downtime appeared first on SQLServerCentral.

Glenn’s Tech Insights For April 3, 2019

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

What You Said You’re Going to Do About SQL Server 2008

Publié le 3 avril 2019 sur brentozar.com
 

Last week, I asked you what you were going to do about SQL Server 2008’s fast-approaching end-of-support date. Countdown clock at SQLServer2008.com Here were some of my favorite responses from blog comments and Twitter. Terry’s been doing a …

SQL For Cosmos DB – Tips and Tricks

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

The series so far: Introduction to SQL for Cosmos DB SQL For Cosmos DB – Tips and Tricks This article will help you extend your basic Cosmos DB SQL querying abilities. Here, you will learn a few of the tricks that you might need to overcome the l …

Intel Cascade Lake-SP Processor Analysis for SQL Server

Publié le 3 avril 2019 sur sqlskills.com - glen berry
 

IntroductionOn April 2, 2019, Intel had their Data-Centric Innovation Day, where they announced and described a number of new products for data center use. Most relevant from a SQL Server perspective is the 2nd Generation Intel Scalable Processor famil …

Registration Open for SQL Saturday Helsinki Workshop 2019

Publié le 3 avril 2019 sur journey to sqlauthority
 

I am super excited that I will be visiting Helsinki SQLSaturday 2019. I will be delivering a day-long post-conference on my most popular workshop – Practical Real-World SQL Server Performance for Everyone. Practical Real-World SQL Server Performa …


Pages :