Sites anglophones


T-SQL Tuesday #86 My all-time favorite personal SQL Server Enhancement Request: Automatically maintained columns

Publié le 10 janvier 2017 sur sqlblog.com
 

I have heard the name T-SQL Tuesday for (like,) ever; but I have always been so into my own bundle of insanity that never took the time to figure out what it is. This changes today because I read a blog on Adam Machanic’s ( @adammachanic ) blog that ou …

Rethinking System Architecture

Publié le 10 janvier 2017 sur sqlblog.com
 

Server system memory capacities have grown to ridiculously large levels far beyond what is necessary now that solid-state storage is practical. Why is this a problem? Because the requirement that memory capacity trumps other criteria has driven system …

#TSQL2sday: System-Maintained LastUpdatedDate, LastUpdatedBy Columns

Publié le 10 janvier 2017 sur brentozar.com
 

For this month’s T-SQL Tuesday, we’re talking about interesting Connect requests to fix or change SQL Server behavior. T-SQL Tuesday In our Senior DBA Class, one of the exercises involves figuring out changes to a table after an Always On A …

The SQL Genie (T-SQL Tuesday #086)

Publié le 10 janvier 2017 sur sqlblog.com
 

At some point a long time ago, when I was first getting serious about SQL Server, I became aware of an open secret . You see, there was this special Microsoft alias called “sqlwish.” Those in the know could send an e-mail and pass along sug …

SQL Server 2016 Enterprise Edition Performance Advantages

Publié le 10 janvier 2017 sur sqlservercentral.com
 

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

Simpsons’ Paradox

Publié le 10 janvier 2017 sur sqlservercentral.com
 

This article is a case study and an attempt to explain an interesting phenomenon with data anomalies that is commonly called Simpsons’ Paradox. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Da …

This month’s T-SQL Tuesday post

Publié le 10 janvier 2017 sur sqlblog.com
 

…is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead property, and in particular, about how Microsoft responded so well to the Connect Ite …

SQL SERVER – TDE Effects on TempDB’s Slow Performance

Publié le 10 janvier 2017 sur journey to sqlauthority
 

I am a big supporter of the fact that testing and playing with new features should not be done on production environments. It can prove to be harmful, even after you tried to clean up the system. Sometimes we are not sure what the impact of our acts ca …

Data Tales #11: The Case of the Ballooning Table

Publié le 9 janvier 2017 sur sqlblog.com
 

Hi folks, I’ve written another “Data Tales” case for SQL Server Magazine. It’s posted now and you’ll find it here: http://sqlmag.com/sql-server/data-tales-11-case-ballooning-tables Enjoy !

Creating your first Dashboard with Apache Zeppelin and SQL Server/Azure SQL

Publié le 9 janvier 2017 sur sqlblog.com
 

Now that Apache Zeppelin has been downloaded and configured, it’s time to create a dashboard. It will be very easy: all you have to do is figure out which data you want to show, write the corresponding T-SQL query and then add some charts and inf …

If a Tree Falls in the Forest, and No One is Around To Hear It…

Publié le 9 janvier 2017 sur sqlblog.com
 

You no doubt have heard this old philosophical question that completes with, « Does it Make a Sound? » As nerds, we all know that the answer is that it certainly does make a sound. However, take the question to a more technical place, how much sound does …

DATA TALES #11: The Case of the Ballooning Tables

Publié le 9 janvier 2017 sur sqlmag.com
 

Over recent months I have written a series of articles on how the overall size of a financial services database was tamed by the application of table compression, XML compression, and PDF size reduction. I have applied this approach at many sites but r …

SQL Server Diagnostic Information Queries for January 2017

Publié le 9 janvier 2017 sur sqlskills.com - glen berry
 

This month, I have updated the legacy queries for SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. There are also minor updates for the SQL Server 2012 and newer queries. Rather than having a separate blog post for each version, I have just put …

[Video] Office Hours 2017/1/4 (With Transcriptions)

Publié le 9 janvier 2017 sur brentozar.com
 

On this first Office Hours call of 2017, Brent, Erik, Tara, and Richie discuss multi-server jobs, how to find motivated Junior DBAs, working with SAP databases, partitioning, AlwaysOn Availability Groups, tracking SQL users, SQL monitoring tools, data …

Using SQLite with PowerShell and SQL Server

Publié le 9 janvier 2017 sur sqlservercentral.com
 

When you combine PowerShell and SQLite, you can perform powerful magic. Phil Factor is in awe of SQLite and gives a brief demonstration of how easy it is to use. Just to encourage anyone who is unfamiliar with the database, he includes a giant-sized SQ …


Pages :