Sites anglophones


New #SQLPASS Summit Pre-Con: Expert Performance Tuning for SQL Server 2016 & 2017

Publié le 15 juin 2017 sur brentozar.com
 

Going to the PASS Summit in Seattle this year? Join me & Erik Darling on Tuesday, the day before the conference, at our pre-con session, Expert Performance Tuning for SQL Server 2016 & 2017. Your job is making SQL Server go faster, but you have …

New Class: Data Science Fundamentals with R

Publié le 15 juin 2017 sur brentozar.com
 

Now that SQL Server ships with R, and you can use R code in T-SQL, your managers might be asking, “Hey, can you start doing some analysis and visualization?” Good news! We’ve got a new class for that. Come learn the fundamentals of an …

Data classification: understanding and protecting your data

Publié le 15 juin 2017 sur sqlservercentral.com
 

What is data classification? Why go to the effort of classifying your data? Jonny Roberts explains.

Setting up R in SQL 2016 – Avoiding Pitfalls

Publié le 15 juin 2017 sur sqlservercentral.com
 

Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.

SQL SERVER – How to Enable Lock Pages in Memory?

Publié le 15 juin 2017 sur journey to sqlauthority
 

Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it. Well, here is a simple tutorial for the same. Step 1: Go to Windows Start Menu …

The SQL Hall of Shame

Publié le 14 juin 2017 sur sqlblog.com
 

SQL Server is a big product, with lots of features. Many of the features—hopefully the vast majority of them—are solid and allow us to build trustworthy, secure, and reasonably usable database applications. But nearly everyone has stumbled …

Setting Variables in Calling T-SQL Code While Using sp_executesql

Publié le 14 juin 2017 sur sqlservercentral.com
 

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.

Stairway to U-SQL Level 15: U-SQL Global Scalar Functions With C#

Publié le 14 juin 2017 sur sqlservercentral.com
 

In this article, see how to created shared functions using C# assemblies in U-SQL. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix the root causes …

Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz

Publié le 14 juin 2017 sur sqlblog.com
 

I spent three days in Seattle at Microsoft Data Insight Summit, delivering a preconference day about data modeling for business users, and two workshops about DAX. All of these were sold-out, so even if you attended the conference, you might be interes …

SQL SERVER – Msg 15137, Level 16 – Error Related to sp_xp_cmdshell_proxy_account

Publié le 14 juin 2017 sur journey to sqlauthority
 

So far, I have written many blogs and I still feel that there are many errors and scenarios which are still uncovered. Whenever I see a new error and find a new solution, I always share it via this blog.  Let us see how we can fix errors related t …

New Class: Always On Availability Groups: The Senior DBA’s Field Guide

Publié le 13 juin 2017 sur brentozar.com
 

Availability Groups are all the rage right now, especially since they’re included with SQL Server 2016 Standard Edition. Our Availability Groups blog post category is one of the most popular on the site, and in my 4-day Senior DBA class …

New Data Driven Episode: Mark Tabladillo on Data Science Teams, Bots, Personhood, and Dancing

Publié le 13 juin 2017 sur sqlblog.com
 

This week on Data Driven , Frank and I are honored to interview Mark Tabladillo, Lead Data Scientist for Microsoft Services: Data Insights Domain Center of Excellence. We talked about lots of stuff including Data Science teams, bots, personhood, and da …

UNION ALL Optimization

Publié le 13 juin 2017 sur sqlservercentral.com
 

Paul White digs into row goals as he explains some interesting and inconsistent behavior with UNION ALL queries in SQL Server.

SQL Data Mask: masking configurations and reports

Publié le 13 juin 2017 sur sqlservercentral.com
 

SQL Data Mask is the latest prototype to come out of the Foundry, Redgate’s research and development division. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. This blog …

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.


Pages :