Sites anglophones


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 …

Monitoring SQL Server with Power BI

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

Query Store is becoming more and more important for server monitoring, specially in SQL Server 2017, which allows us to get historical information about wait stats. We can import query store information into power bi and create a very useful dashboard …

Understanding Azure Data Factory – A Cloud Based Integration Service

Publié le 4 octobre 2017 sur sqlservercentral.com
 

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.

Database provisioning from backups using SQL Clone

Publié le 4 octobre 2017 sur sqlservercentral.com
 

This article offers a brief, step-by-step guide to provisioning databases from a backup using SQL Clone.

Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell

Publié le 4 octobre 2017 sur sqlservercentral.com
 

Learn how PowerShell can be used to manage files and folders in your Data Lake.

SQL SERVER – How to Delete a Single Table From SQL Server Backup File (.bak)

Publié le 4 octobre 2017 sur journey to sqlauthority
 

Question: How to Delete a Single Table From SQL Server Backup File (.bak)? Answer: It is not possible by directly editing the backup file .bak. I had actually heard this question during a recent interview, however, the only reason I have not inclu …

For the Better Developer: When indexes are not enough

Publié le 3 octobre 2017 sur sqlblog.com
 

Another month, another session for the PASS Application Development VG. This time I will be both the host and the guest :), talking about something is very close to my interests and, I think, also a key point for any developer to have success in future …

SQLskills SQL101: Running out of ints and bigints

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

As Kimberly blogged about earlier this year, SQLskills has an ongoing initiative to blog about basic topics, which we’re calling SQL101. We’re all blogging about things that we often see done incorrectly, technologi …


Pages :