Sites anglophones

SQL Server 2016 Polybase Services stuck in Change Pending state

Publié le 5 juillet 2016 sur

I’ve been using the Polybase services in SQL Server 2016 all throughout the pre-release period without any issue. When I tried using them in the GA (Generally Availability) release, I could never get the two Polybase services to start. They were …

PASS Updates to Speaker Contracts

Publié le 5 juillet 2016 sur

Adam Jorgensen, PASS President, has posted an update about the PASS speaker contract: Contributions to the Speaker Contract . Included in the post are links to the updated versions of the Summit Speaker Contract and the Summit Pre-Conference Contract . …

SQL Server Diagnostic Information Queries for July 2016

Publié le 5 juillet 2016 sur - glen berry

This month, I have several new improvements in the SQL Server 2014 and 2016 sets, along with additional comments and documentation in the SQL Server 2012, 2014 and 2016 sets.  I have gotten quite a bit of interest about making a special version of …

Why the Key to a Data-Driven Culture is Community with Shawn Rogers

Publié le 5 juillet 2016 sur

Mico Yuk BI Brainz Analytics on Fire Podcast Listen to the latest podcast from Mico Yuk of BI Brainz, in which she talks with godfather of BI and Chief Research Officer of Dell Shawn Rogers. read more

TDE and Backup Compression: Together At Last

Publié le 5 juillet 2016 sur

TDE is one of those things! You either need it, and quickly learn how many things it plays the devil with, or you don’t need it, and there but for the grace of God go you. Off you go, with your compressed backups, your instant file initialization …

July SSMS 2016 changes transaction semantics

Publié le 5 juillet 2016 sur

This can be a very nasty one if you’re not observant. The July update of SSMS now has the option to change XACT_ABORT setting for a query window using Tools Options Query Execution SQL Server Advanced SET XACT_ABORT Now, exposing one more SET option ca …

Power BI to Azure SQL and Google Analytics

Publié le 5 juillet 2016 sur

In this demo, we will give an introduction from 0 about Power BI and how to connect to Azure SQL Databases and Google Analytics How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains ste …

SQL SERVER 2016 – InMemory OLTP LOB Datatype Enhancement

Publié le 5 juillet 2016 sur journey to sqlauthority

My exploration with SQL Server 2016 features are just continuing and I am delighted every other day to figure out something new been added to the capabilities which in the opinion were of limited capacity in the prior versions of SQL Server. I will spa …

Breaking News: 2016 Query Store cleanup doesn’t work on Standard or Express Editions

Publié le 4 juillet 2016 sur

If you’re using SQL Server 2016’s awesome new feature, Query Store, there’s a new bug with automatic cleanup. Books Online explains: Automatic data cleanup fails on editions other than Enterprise and Developer. Consequently, space use …

Screenshot Interview Question: “What would you do if you saw this?”

Publié le 4 juillet 2016 sur

In this week’s episode of our screenshot interview series, you’re applying for a database professional position who will be on call. You’re not necessarily the DBA, but you’re a member of the team on rotation. While you …

Difference between SQL Server Unique Indexes and Unique Constraints

Publié le 4 juillet 2016 sur

Uniqueness of values in specific columns can be enforced in a SQL Server table by creating a unique constraint or a unique index on those columns. In this article, Sergey Gigoyan looks at what the differences between the two are, and how SQL Server han …

Stairway to SQL Server Virtualization Level 1: What is Virtualization?

Publié le 4 juillet 2016 sur

The first level in the Stairway to Virtualization introduces the concept of virtualized servers as well as the terminology and benefits of implementing the technology.

SQL Server Agent – Unable to start the service – The request failed or the service did not respond in a timely fashion

Publié le 4 juillet 2016 sur journey to sqlauthority

Rarely, it also happens when someone becomes accidental DBA and may get stumped with simple things. This blog is result of troubleshooting which I have done for a company where I found one such DBA. I don’t say you cannot become a DBA in this man …

How to Attach MDF Data File Without LDF Log File – Interview Question of the Week #078

Publié le 3 juillet 2016 sur journey to sqlauthority

Just the other day I was busy during a performance tuning exercise I explained to the team of DBA that how much log file is critical and important for their performance. Once I was explaining the importance and role of the LDF file in the performance, …

[Video] Office Hours 2016/06/29 (With Transcriptions)

Publié le 2 juillet 2016 sur

This week, Erik, Richie, Doug, and Angie discuss a script for getting more information on a specific index, using partition tables, shrinking data and log files, stress testing SQL servers, as well as some entertaining things to ask Siri! Her …

Pages :