Sites anglophones


The PASS Summit Has Been Very Very Good to Me

Publié le 23 septembre 2016 sur sqlblog.com
 

In my blog post last March ( http://www.sqlpass.org/Community/PASSBlog/tabid/1476/entryid/789/Portfolio-Update-PASS-Programs.aspx ) I mentioned that my first PASS Summit was in 2003 in Seattle. I’ve been to every PASS Summit since then, and I can hones …

Querying Multiple MySQL Tables

Publié le 23 septembre 2016 sur sqlservercentral.com
 

It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in …

Audit and Compliance Survey

Publié le 23 septembre 2016 sur sqlservercentral.com
 

Redgate are trying to understand the broad problem of auditing and compliance from a database perspective. Though it’s a wide-ranging topic, they’re particularly interested in better understanding pain points in the area. Additional to the survey, they …

Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator

Publié le 23 septembre 2016 sur sqlservercentral.com
 

The PIVOT operator was added to the Transact-SQL language in SQL Server 2005. It allows you to turn your row data on its side, so it can be presented as column data. This is useful when you want take unique column values and have them displayed as colu …

SQL SERVER – How to Join a Table Valued Function with a Database Table

Publié le 23 septembre 2016 sur journey to sqlauthority
 

Just another day I received following question and I find it very interesting. I decided to try it out on SQL Server 2016’s new WideWorldImporters database. The question was – “How to Join a Table Valued Function with a Database Table …

When heap data pages become linked…

Publié le 22 septembre 2016 sur sqlskills.com - paul randall
 

The pages at each level of an index are linked together in a doubly-linked list (using the m_nextPage and m_prevPage fields in their page headers) to allow ascending-order and descending-order scans, based on the index key(s). Data pages in a heap are …

SQL 2016 CU2 is now Available

Publié le 22 septembre 2016 sur sqlblog.com
 

  Microsoft just announced that Cumulative Update 2 for SQL Server 2016 is now available for download here . There are a number of fixes including one I have been looking forward to regarding the Query Store. See here for more details on that one. …

Partitioned Views: A How-To Guide

Publié le 22 septembre 2016 sur brentozar.com
 

This is not about table partitioning If you want to learn about that, there’s a whole great list of links here, and the Best Blogger Alive has a tremendous post on why table partitioning won’t make your queries any faster over here. With th …

T-SQL Enhancements in SQL Server 2016

Publié le 22 septembre 2016 sur sqlmag.com
 

The relational database engine and T-SQL are the core of SQL Server 2016. T-SQL is used for both SQL Server management as well as stored procedures, triggers, functions and application development. As you might expect with a new release, Microsoft has …

AT TIME ZONE – a new favourite feature in SQL Server 2016

Publié le 22 septembre 2016 sur sqlservercentral.com
 

Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates.

Code completion, formatting and refactoring for SQL Server

Publié le 22 septembre 2016 sur sqlservercentral.com
 

A common misconception is that Redgate’s SQL Prompt is ‘just’ a code completion tool. While this is indeed at the heart of SQL Prompt, there are a host of features that will help you and your team work more quickly and efficiently, fr …

Monitor up-time and connectivity with Powershell

Publié le 22 septembre 2016 sur sqlservercentral.com
 

Use Powershell to troubleshoot SQL connectivity issues. A way to monitor up-time and connectivity of a SQL server database with some simple Powershell commands.

SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance

Publié le 22 septembre 2016 sur journey to sqlauthority
 

As many of you know, I am an indecent SQL Server Consultant, who purely focus on SQL Server Performance. Every single day, I keep two slots each hour long available for users who need my help urgently. I never ever pre-book them because, I believe it i …

A New Version of SSDT is Available

Publié le 21 septembre 2016 sur sqlblog.com
 

Microsoft released an update to SQL Server Data Tools (SSDT) 2016 on 20 Sep 2016 – the tool used to design databases, SSIS, SSRS, and SSAS solutions. I can hear you thinking, “How do I get the update, Andy?” You can get version 14.0.6 …

I Was Wrong (About the SSIS Catalog)

Publié le 21 septembre 2016 sur sqlblog.com
 

I apologize for misleading people who read my writings and have heard me speak on the topic of the SSIS Catalog. Here’s what I recently realized: The execution_id is different from the operation_id in the SSISDB database. In the past, I complaine …


Pages :