Sites anglophones


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 …

Early Bird Rate for the 2017 IT/Dev Connections Conference Ends Soon

Publié le 9 juin 2017 sur sqlmag.com
 

The rate is rising soon for IT/Dev Connections. Don’t delay if you plan to attend. read more

Hyper-V: Getting Your Host And Guest Connected

Publié le 9 juin 2017 sur brentozar.com
 

Because I always forget stuff like this I have a confession to make, dear readers: I am a horrible VM admin. I’m also not great at networking. When I go to set up a VM to do something like install SQL vNext, I want to be able to talk to it. Why b …

Filtering Errors in PowerBI

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

I just faced this problem when trying to analyze some information from google analytics in PowerBI. In my specific situation, I was trying to extract a number from some URL querystrings and filter the rows without the number. When I set the data type o …

VMware monitoring in SQL Monitor

Publié le 9 juin 2017 sur sqlservercentral.com
 

The Redgate SQL Monitor team has been looking into how you can more effectively monitor SQL Server running on a virtual machine, and are pleased to announce that they’ve begun this by introducing support for VMware in SQL Monitor version 7.0.11. Find o …

SQL SERVER – Installation Error – Status Code: 183 Description: Cannot Create a File When that File Already Exists

Publié le 9 juin 2017 sur journey to sqlauthority
 

One of my client was unable to install SQL Server 2014 on a Windows 2012 Cluster. They were using mount points with below the structure. Let us learn about installation error. M:Data_MP M:Log_MP M:System_MP M:Temp_MP M:Backup_MP Over here, M was 10GB l …

4 DBA Resume Anti-Patterns

Publié le 8 juin 2017 sur brentozar.com
 

Every now and then, clients ask me to interview candidates for their open DBA positions. I get to see a lot of resumes, and there are a few warning signs that pop up regularly. 1. The Keyword Encyclopedia. I get it: you’ve opened SSMS before, and …

Logging wait stats over time

Publié le 8 juin 2017 sur sqlblog.com
 

We all know how valuable wait statistics can be when doing performance analysis. One thing I feel is missing in SQL Server is a trail of various measures, for instance wait stats. I really wish Microsoft could include something in this area, which can …


Pages :