Sites anglophones


Getting Excited about my Practical Performance Monitoring Pre-Con

Publié le 2 juillet 2017 sur sqlblog.com
 

  I was working on the demo’s for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I got a little giddy .  The session is geared towards helping a DBA get started in mon …

How Default Value and Nullable Column Works? – Interview Question of the Week #129

Publié le 2 juillet 2017 sur journey to sqlauthority
 

Question: How Default Value and Nullable Column works together for a single table? Answer: This question is indeed a very interesting. It is quite possible that different user will interpret it differently. Recently, when I was helping an organization …

SQL SERVER – MSDB Database Uncontrolled Growth Due to Queue_messages. How to Clear All Messages From a Queue?

Publié le 1 juillet 2017 sur journey to sqlauthority
 

Received an email “Need your urgent help On Demand, our MSDB Database has grown too big and we need help to check our MSDB.” I have been an independent consultant for a while and one of the services I provide is “On Demand (50 mi …

Why Is Tracking Restores So Hard?

Publié le 30 juin 2017 sur brentozar.com
 

Phantom of the Nopera Let’s say you have a server. Let’s go one step further and say SQL Server is running on it. Crazy, I know. But hey, we specialize in crazy, here. If you want to track CREATE, ALTER, or DROP DATABASE commands, that …

Statistics in SQL: The Mann–Whitney U test

Publié le 30 juin 2017 sur simple-talk.com
 

The series so far: Statistics in SQL: Pearson’s Correlation Statistics in SQL: Kendall’s Tau Rank Correlation Statistics in SQL: Simple Linear Regressions Statistics in SQL: The Kruskal–Wallis Test Statistics in SQL: The Mann–Wh …

SQL Server 2017: New ‘Queries with high variation’ Graph

Publié le 30 juin 2017 sur simple-talk.com
 

A few weeks ago I published an interesting article about how to use query store to identify parameterization problems. At that point I hadn’t played with the new SQL Server 2017. While later, when I did, I got surprised by the new ‘Queries …

The Louis Davidson custom style for SQL Prompt

Publié le 30 juin 2017 sur sqlservercentral.com
 

In this article, Louis Davidson sticks his neck out, and offers what he believes is a sensible code formatting style, based on twenty-plus years of writing SQL. The result is the Louis Davidson custom SQL Prompt style that you can download using the li …

Export data from SQL Server to Excel

Publié le 30 juin 2017 sur sqlservercentral.com
 

What native SQL Server options are available to export to Excel? Jeremy Kadlec explains.

SQL SERVER – Alternative of Log Shipping in Simple Recovery Model

Publié le 30 juin 2017 sur journey to sqlauthority
 

The blog topic might seem controversial and doesn’t go well with definition of log shipping features. Read it again. The blog has an alternative way to set up something “similar” to log-shipping. If the database is in simple recovery …

SQL101: AMD EYPC 7000 Series Processors

Publié le 29 juin 2017 sur sqlskills.com - glen berry
 

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologies used the wrong way, or …

Introducing sp_AllNightLog: Log Shipping at Scale, Open Source

Publié le 29 juin 2017 sur brentozar.com
 

In our Faux PaaS project, we need a backup plan – or rather, a restore plan. On each SQL Server instance, clients can create as many databases as they want, anytime they want, with no human intervention. We need those databases cov …

Azure Automation Methods

Publié le 29 juin 2017 sur sqlservercentral.com
 

Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.

Provisioning just got BIGGER

Publié le 29 juin 2017 sur sqlservercentral.com
 

The recent launch of Redgate SQL Clone v2 has removed the previous 2TB size limit, as the tool now supports cloning databases up to a whopping 64TB. In this post, Karis Brummit explains how the increase has been possible.

Scoring Outliers in Non-Normal Data with R

Publié le 29 juin 2017 sur sqlservercentral.com
 

Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?

SQL Server – How to Get Column Names From a Specific Table?

Publié le 29 juin 2017 sur journey to sqlauthority
 

Question: How to get column names from a specific table in SQL Server? Answer: This is a very popular question and there are multiple ways to get column names of a specific table in SQL Server. Let us see various methods. You can choose the method whic …


Pages :