Sites anglophones


How to implement a SQL formatting standard using SQL Prompt v8

Publié le 16 juin 2017 sur sqlservercentral.com
 

With ten programmers working on the same project, how do you agree on a standard style for formatting SQL code, and then implement it consistently? One way is through draconian rules, meeting after meeting, and the occasional sacrifice of a programmer …

The Invisible DBA

Publié le 16 juin 2017 sur sqlservercentral.com
 

Do you want super powers? Learn how to be an invisible DBA!

SQL SERVER – Startup Issue – Unable to Use Domain Account as Service Account When Read Only Domain Controller (RODC) is Involved

Publié le 16 juin 2017 sur journey to sqlauthority
 

Recently, one of my client was trying to troubleshoot the below error which they were getting while trying to start the SQL Server service under the domain account. The interesting thing which they told me was that they are using Read Only Domain Contr …

Utility to temporarily drop FOREIGN KEY constraints on a set of tables

Publié le 16 juin 2017 sur sqlblog.com
 

I was working on a database a few weeks back (maybe longer, I am kind of busy with several projects right now), and I wanted to truncate a set of tables. There was one central table, and 8 tables related by a FOREIGN KEY constraint. The central table h …

Announcing Data Science Daily

Publié le 15 juin 2017 sur sqlblog.com
 

At Data Driven we’re experimenting with new show formats – especially what we call “mini-shows.” Earlier this week we started a new feature called Data Science Daily . Frank has done an outstanding job on these first three insta …

SQL Server Diagnostic Information Queries for June 2017

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

This month, there are some minor updates to the all of the versions of the queries. I usually make additional minor updates to the queries during the month, so if you are in doubt, downloading the latest version is always a good idea. Rather than havin …

Introduction to Azure Cosmos DB: Microsoft’s Globally Distributed, Multi-Model Database Service

Publié le 15 juin 2017 sur sqlblog.com
 

It’s time for something NoSQL at the PASS Application Development Virtual Group. Next week Denny Lee will present on Cosmos DB, the latest evolution of DocumentDB: Introduction to Azure Cosmos DB: Microsoft’s Globally Distributed, Multi-Mod …

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 …

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 …

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.


Pages :