Sites anglophones


What is normal? Finding outliers with R

Publié le 13 juin 2017 sur sqlservercentral.com
 

How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.

SQL Server Performance Tuning Practical Workshop – Aftermath

Publié le 13 juin 2017 sur journey to sqlauthority
 

In the month of January, I had offered a unique offering for training – “SQL Server Performance Tuning Practical Workshop“. I was initially planning to offer this for one month, however the response for this training was so much …

DevOps and your database

Publié le 13 juin 2017 sur sqlblog.com
 

I’m a consultant. That means I have to deal with whatever I come across at customer sites. I can recommend change, but when I’m called in to fix something, I generally don’t get to insist on it. I just have to get something fixed. Tha …

Signal Processing and Near-Real-Time Data Integration

Publié le 13 juin 2017 sur sqlblog.com
 

Years ago I worked in manufacturing automation. I wrote ladder logic (and machine code and even a little C) mostly for Allen-Bradley and GE Fanuc PLCs (Programmable Logic Controllers). I also used HMI (Human-Machine Software) solutions like RSView and …

Ola Hallengren’s Maintenance Scripts are Now on Github.

Publié le 12 juin 2017 sur brentozar.com
 

For some of you, the headline is self-explanatory, and you just want the URL, so here it is: https://github.com/olahallengren/sql-server-maintenance-solution For the rest of you, here’s what it means. What are Ola Hallengren’s maintena …

Guide to enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

Publié le 12 juin 2017 sur sqlservercentral.com
 

A new whitepaper published today gives Microsoft SQL customers technical guidance for how to approach GDPR compliance with Microsoft SQL technologies. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor …

Have production-level PostgreSQL experience?

Publié le 12 juin 2017 sur sqlservercentral.com
 

Redgate are doing some early stage research around PostgreSQL, and would really like to hear about your experiences. If you think you can help, check out their short survey.

Two Approaches to Addressing Circular References in SSDT

Publié le 12 juin 2017 sur sqlservercentral.com
 

Both options have their advantages and disadvantages. Neither is universally right for all situations. Understand the differences before picking the model that works for your situation.

SQL SERVER – Learning New Multipurpose FORMAT Function

Publié le 12 juin 2017 sur journey to sqlauthority
 

In versions prior to 2012, you need to use the CONVERT function with different styles to convert the date values into a different format. Let us learn about the FORMAT function in this blog post. Let us create this simple dataset CREATE TABLE #date_tes …

SQL Server 2016 Import and Export Wizard and Excel

Publié le 11 juin 2017 sur sqlblog.com
 

SQL Server 2016 is a 64-bit application and it comes with two versions of the Import and Export Wizard. If you launch the Import/Export Wizard from the SSMS, the 32-bit version is invoked. The 64-bit version does not natively provide support for Excel …

[Video] Office Hours 2017/06/07 (With Transcriptions)

Publié le 11 juin 2017 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and …

How to Add Column at Specific Location in Table? – Interview Question of the Week #126

Publié le 11 juin 2017 sur journey to sqlauthority
 

Question: How to Add Column at Specific Location in Table? Answer: Order of the column in the table should not matter. Need of Column in Specific Location in a Table I personally see no reason to create a column in a specific location in the table …

How to Add Column at Specific Location in Table? – Interview Question of the Week #126 -dee

Publié le 11 juin 2017 sur journey to sqlauthority
 

Question: How to Add Column at Specific Location in Table? Answer: Order of the column in the table should not matter. Need of Column in Specific Location in a Table I personally see no reason to create a column in a specific location in the table …

Data Drivers

Publié le 10 juin 2017 sur sqlblog.com
 

I’m writing up show notes and the Data Driver Newsletter for next week. Our guest on the next Data Driven Podcast is… Only Data Drivers get advance notice of guest appearances. Sign up today ! :{> Follow Data Driven iTunes YouTube Twitt …

SQL SERVER – Not Able to Kill SPID with KILL WITH STATUSONLY

Publié le 10 juin 2017 sur journey to sqlauthority
 

Question: Why I am not able to KILL SPID with command KILL (spid) WITH STATUSONLY? Answer: Recently in performance tuning consultancy, I received a very interesting question. One of the Jr. DBA, tried to KILL the long running query using the following …


Pages :