Sites anglophones


SQL Server Subquery in Select Statement with Where Clause

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post SQL Server Subquery in Select Statement with Where Clause appeared first on SQLServerCentral.

Monitoring your servers and databases with SCOM and SQL Monitor

Publié le 22 mai 2019 sur sqlservercentral.com
 

The post Monitoring your servers and databases with SCOM and SQL Monitor appeared first on SQLServerCentral.

9 Tips for Faster SQL Server Applications

Publié le 21 mai 2019 sur brentozar.com
 

Wanna make your SQL Server applications go faster? Here are 9 simple tips that will give you a better chance for success. They’re not carved in stone, but they’re a good place to start. Query Design Tips 1. Code for readability first. The e …

SQL SERVER – Difference Between Login Vs User – Security Concepts

Publié le 21 mai 2019 sur journey to sqlauthority
 

In the last 13 years of blogging, I have been asked this question again and again and so many times that I think if you wake me up in the middle of the night I can easily reply about the difference between Login Vs User – Security Concepts.Before …

Introduction to the Cosmos DB Emulator

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Introduction to the Cosmos DB Emulator appeared first on SQLServerCentral.

DBA Walkthrough – Adding space on IBM AIX Power Machines

Publié le 21 mai 2019 sur sqlservercentral.com
 

Editor’s Note: While this doesn’t mention SQL Server, as we can now run the platform on Linux, we thought this might be an interesting look at the process of adding disk space on a Unix platform. SQL Server does not run on Unix, but Linux is similar to …

Bringing certainty to the uncertainty of Brexit

Publié le 21 mai 2019 sur sqlservercentral.com
 

The post Bringing certainty to the uncertainty of Brexit appeared first on SQLServerCentral.

Does the Rowmodctr Update for Non-Updating Updates?

Publié le 20 mai 2019 sur brentozar.com
 

Get Notebook – FAQ Okay, look, it’s a mouthful of a blog post title, and there are only gonna be maybe six of us in the world who get excited enough to check this kind of thing, but if you’re in that intimate group, then the title …

SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

Publié le 20 mai 2019 sur journey to sqlauthority
 

I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop. The error was related to script upgrade mode and the fix was extremely …

Testing Databases: What’s Required?

Publié le 20 mai 2019 sur sqlservercentral.com
 

The post Testing Databases: What’s Required? appeared first on SQLServerCentral.

Creating Aliases for Docker Commands in Linux

Publié le 20 mai 2019 sur sqlservercentral.com
 

Introduction There are situations when we need to execute the same command line instruction over and over again,  it becomes worse if the command in question has arguments, furthermore if we are forced to modify the output to make it readable. Mos …

When Was SQL Server Last Restarted? – Interview Question of the Week #225

Publié le 19 mai 2019 sur journey to sqlauthority
 

Question: When Was SQL Server Last Restarted?Answer: This is the first question I always ask during my Comprehensive Database Performance Health Check. The system restart date is very important to know but even more so, I always want to know when was S …

Docker – Running SQL Server Image Without Running Pull Command

Publié le 18 mai 2019 sur journey to sqlauthority
 

I have been using Docker for a while to run the latest CTP of SQL Server 2019 and it has been so far amazing ride to use the product. Every time when new CTP is released, I learn something new with Docker. This time I learn that I can just run SQL Serv …

SQL Server Diagnostic Information Queries for May 2019

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

This month, I have just made some minor improvements to most of the query sets, mainly in the comments and documentation. I have also been working on the Azure SQL Database version of the queries lately.I have a T-SQL script that you can use to check w …

Streamlining a Power BI Solution

Publié le 17 mai 2019 sur simple-talk.com
 

Self-service business intelligence is everywhere these days. It helps organizations or departments get started with business intelligence quickly. All they need is a data dump in an Excel file, and a tool that would create magic out of it. And there yo …


Pages :