Sites anglophones


Logical Query Processing Part 7: GROUP BY and HAVING

Publié le 13 octobre 2016 sur sqlmag.com
 

This article continues the series about logical query processing, which describes the logical, or conceptual, interpretation of queries. read more

SQL Server 2016 New Date Objects

Publié le 13 octobre 2016 sur sqlservercentral.com
 

SQL Server 2016 introduced three new objects to deal with the greater demand of data; John Miner takes a look at this new functionality.

Bones of SQL – Practical Calendar Queries

Publié le 13 octobre 2016 sur sqlservercentral.com
 

After the first article created a Calendar table, learn how to use this in a practical sense with some common queries. 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 …

SQL SERVER – Error – Attempted to Perform an Unauthorized Operation

Publié le 13 octobre 2016 sur journey to sqlauthority
 

As you might know I try hard to help the community via various channels. Comment on my blog is one of that channels. Here is a blog post which talks about error about Unauthorized Operation. Recently, one of my community members shared a SQL …

The Problem with Windows Server 2016 Licensing

Publié le 12 octobre 2016 sur brentozar.com
 

Windows Server 2016 Licensing Guide (PDF) Windows Server 2016 is now licensed by the core, but that’s not really the big problem. The bigger problem is buried in the licensing guide (PDF): “A minimum of 16 core licenses is required for …

Why I Love kCura RelativityOne Even Though I Don’t Use It

Publié le 12 octobre 2016 sur brentozar.com
 

At RelativityFest this week, kCura showed more details about how their upcoming software-as-a-service hosted in Microsoft Azure works. I really like where they’re going with it. Presenting at Relativity Fest 2016 I’ve blogged about Relativi …

Stairway to U-SQL Level 10: Table-Valued Functions and UDTs

Publié le 12 octobre 2016 sur sqlservercentral.com
 

Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.

Migrating data to Azure SQL Data Warehouse in practice

Publié le 12 octobre 2016 sur sqlservercentral.com
 

Rangarajan Srirangam from the Azure Customer Advisory Team shares some tips and techniques to help achieve an efficient data migration to Azure SQL Data Warehouse.

SQL SERVER – Msg 3047, Level 16, State 1: The BackupDirectory Registry Key is Not Configured Correctly

Publié le 12 octobre 2016 sur journey to sqlauthority
 

While writing my earlier blog, I broke a few settings and started getting new errors. Earlier, when I used to run below command, it used to work fine. However, just a day ago, it has given me error related to the BackupDirectory Registry Key. BACKUP DA …

PASS SQL Saturday #567 Slovenia Schedule

Publié le 11 octobre 2016 sur sqlblog.com
 

The schedule for the last SQL Saturday this year in Europe is alive. Hurry up with registrations, two months before the even we are already 70% full! Also don’t forget our great pre-conference seminars: DevOps and SQL Server – Expert Advice for T …

Set Statistics… Profile?

Publié le 11 octobre 2016 sur brentozar.com
 

Forgotten, But Not Gone Two of the best built-in tools to figure out if your query tuning efforts are headed in the right direction are SET STATISTICS TIME ON and SET STATISTICS IO ON. If you’re really fancy, you can use SET STATISTICS TIME, IO O …

Passwords – a secret you have no right to share

Publié le 11 octobre 2016 sur sqlblog.com
 

I feel like this topic just keeps going around and around. Every time I’m in a room where someone needs to log into a computer that’s not theirs, there seems to be a thing of “Oh, I know their password…”, which makes me c …

Error Logging Gone Wild

Publié le 11 octobre 2016 sur sqlservercentral.com
 

Many of have applications that log errors to a table. Ever thought about what happens when an application starts to throw a lot of errors? This article looks at the problem and some of the responses you might consider having ready in case it happens to …

Going Interactive with C#

Publié le 11 octobre 2016 sur sqlservercentral.com
 

For some time now, C# programmers have gazed enviously at the interactive capabilities of F#, Python and PowerShell. For rapid prototyping work and interactive debugging, dynamic languages are hard to beat. C# Interactive slipped into view quietly, wit …

SQL SERVER – Performance Benefit of Using SPARSE Columns?

Publié le 11 octobre 2016 sur journey to sqlauthority
 

I have written a number of blogs around working with SPARSE Columns in the past and a primer to what SPARSE Columns can be got from the list mentioned: SQL SERVER – 2008 – Introduction to SPARSE Columns SQL SERVER – 2008 – Intro …


Pages :