Sites anglophones


How to Create Primary Key Without ANY Index? – Interview Question of the Week #142

Publié le 8 octobre 2017 sur journey to sqlauthority
 

Question: How to Create Primary Key Without ANY Index? Answer: Before you jump and say you know this answer, I request you to read the question one more time. In SQL Server, when we create Primary Key Constraint, it automatically creates Clustered Inde …

Spring 2018 classes in Chicago and Bellevue open for registration

Publié le 7 octobre 2017 sur sqlskills.com - paul randall
 

I’ve just released our first set of 2018 classes for registration! We’ll be adding new classes in Chicago over the coming weeks, including classes on security, data mining and AI, and BI, and Kimberly’s long-awaited class on data …

SQL Server 2012 Service Pack 4

Publié le 7 octobre 2017 sur sqlblog.com
 

The Service Pack 4 of SQL Server 2012 has been released!This service pack contains:More than 20 improvements around performance and scalabilityAll fixes released up to and including the Cumulative Update 10 for SQL Server 2012 SP3The most imp …

SQL Authority News – SQL Server 2012 Service Pack 4 Released

Publié le 7 octobre 2017 sur journey to sqlauthority
 

It has been a while since I stopped writing about Service Packs announcements, I believe those who needs to always keep track of this and do not need to know via a separate blog post. With that said, I personally do not believe in any such kind of …

Getting Help with a Slow Server

Publié le 6 octobre 2017 sur brentozar.com
 

StackExchange users often ask, “Why is my server slow?” Here’s a few tips to get better, faster answers. What is SQL Server waiting on? As a performance tuner, I start my analysis with the wait stats. If I’m going to help answer …

SQL Server Integration Services SSIS 2016 Tutorial

Publié le 6 octobre 2017 sur sqlservercentral.com
 

SQL Server Integration Services (SSIS) is the integration and ETL (extract – transform – load) tool in the Microsoft Data Platform stack. SSIS is typically used in data warehousing scenarios, but can also be used in common data integration …

The SQL Prompt Functionality Finder

Publié le 6 octobre 2017 sur sqlservercentral.com
 

SQL Prompt does a lot more than just intellisense – in this article, Phil Factor provides a handy table showing all of the tool’s functions and where to access them.

YCSB Benchmark and Latest Evaluation With NuoDB

Publié le 6 octobre 2017 sur journey to sqlauthority
 

The database world is very big and it is very difficult to compare multiple databases with each other. The reality is that every database organization talks about the unique features of their database in such fashion that each database is the best amon …

SQL Server Diagnostic Information Queries for October 2017

Publié le 5 octobre 2017 sur sqlskills.com - glen berry
 

This month, I have added a set of diagnostic queries for Azure SQL Database. These are very much a work in progress, and they will be changing (and hopefully improving) quite a bit over the next few months There are more minor updates to the all of the …

PasteThePlan October 2017 Update

Publié le 5 octobre 2017 sur brentozar.com
 

We’re back at it again. We took a bit of time out of our busy schedule to put in a few enhancements into PasteThePlan.com. Here’s some of the highlights: Updated to the latest version of HTML Query Plan. In order to create a graphical query …

Making Good Use of SQL Server Auditing

Publié le 5 octobre 2017 sur sqlservercentral.com
 

SQL Server Auditing is a powerful out-of-the box toolset that captures auditing information and writes to a file or the Event Log. This article examines the little things that might snag you up.

SQL SERVER – Connecting Specific Database on Starting SSMS

Publié le 5 octobre 2017 sur journey to sqlauthority
 

In today’s blog post we are going to learn how to connect specific database directly when we start SQL Server Management Studio. Honestly, this is a very simple process, but I have seen quite a few DBA still unaware of this feature. I have seen D …

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

Publié le 4 octobre 2017 sur simple-talk.com
 

The series so far: SQL Server R Services: The Basics SQL Server R Services: Digging into the R Language SQL Server R Services: Working with ggplot2 Statistical Graphics SQL Server R Services: Working with Data Frames SQL Server R Services: Generating S …

Bad Idea Jeans: Finding Undocumented Trace Flags

Publié le 4 octobre 2017 sur brentozar.com
 

I need to start this blog post with a disclaimer: you should not be doing this. Hell, *I* should not be doing this. But when SQL Server 2017 came out Monday, I noticed a few unusual SNAPSHOT_MATERIALIZATION entries in sys.messages and a few related und …

New Pluralsight course: Analyzing Query Performance for Developers

Publié le 4 octobre 2017 sur sqlskills.com - paul randall
 

Erin’s latest Pluralsight course has been published – SQL Server: Analyzing Query Performance for Developers. It’s four hours long, and from the course description: Developers are sometimes charged with fixing performan …


Pages :