Sites anglophones


The 2019 State of Database DevOps

Publié le 14 janvier 2019 sur sqlservercentral.com
 

All the latest insights on DevOps adoption rates among SQL Server Professionals, with a foreword from Donovan Brown Principal DevOps Manager at Microsoft. Read the report to understand the challenges – and the opportunities – of adopting da …

SQL SERVER – FIX: Msg 8180 – Statement(s) Could not be Prepared. Deferred Prepare Could not be Completed

Publié le 14 janvier 2019 sur journey to sqlauthority
 

While running a linked server query, I encountered an error and learned something new. In this blog we would learn about how to fix error – Msg 8180 – Statement(s) could not be prepared. Here is the complete error message which I received. …

How to Move Log File or MDF File in SQL Server? – Interview Question of the Week #208

Publié le 13 janvier 2019 sur journey to sqlauthority
 

Question: How to Move Log File or MDF File in SQL Server? Answer: This is one of the most frequent tasks, I always end up doing in my Comprehensive Database Performance Health Check. During health check, I often end up on the situation where one o …

SQLBits 2019: Attention Pre-Con Attendees – One Free Consulting Hour

Publié le 12 janvier 2019 sur journey to sqlauthority
 

SQLBits 2019 is one of my most favorite events. Earlier I blogged about SQLBits 2019: Pre-Con – 21 Essential Scripts: Performance Tuning for EVERYONE. I had promised that everyone who attends my pre-con at SQLBits will get an interesting bon …

More CPU Competition Coming for Intel

Publié le 12 janvier 2019 sur sqlskills.com - glen berry
 

On January 9, 2019, AMD CEO and President Dr. Lisa Su presented a CES 2019 Keynote where she demonstrated (at 1:25:00 in the video) a 7nm, eight core/sixteen thread, 3rd Generation AMD Ryzen desktop processor running the Cinebench R15 Multithreaded (MT …

SQL Server Diagnostic Information Queries for January 2019

Publié le 11 janvier 2019 sur sqlskills.com - glen berry
 

This month, I have just made some more minor improvements to most of the query sets, mainly in the comments and documentation. I have a T-SQL script that you can use to check whether your instance of SQL Server has been patched to mitigate against the …

Workload Tuning Training

Publié le 11 janvier 2019 sur SQLSkills.com - Erin Stellato
 

I recently booked my flight to the U.K. for SQLBits, and I realized I probably should write a post about my full day training session on workload tuning! It’s on Wednesday, February 27, 2019, and you can read the abstract here: Stop Tuning Your Q …

Manage Data Across Multiple Sources with Azure Data Studio

Publié le 11 janvier 2019 sur sqlservercentral.com
 

Azure Data Studio, now the official name of SQL Operations Studio, was released in September. The biggest news regarding the release is the extensions that are now available, as Julie Lerman describes.

Two Things I Would Change in SSISDB Setup

Publié le 11 janvier 2019 sur sqlservercentral.com
 

I suggest these two changes to the SSISDB setup to prevent issues down the road.

SQL SERVER – FIX: Msg 9514 – XML Data Type is Not Supported in Distributed Queries

Publié le 11 janvier 2019 sur journey to sqlauthority
 

Sometimes, I get some quick questions via my blog comments and I do spend the time to search on them and reply or write a blog. In this blog we would learn how to fix: Msg 9514 – XML data type is not supported in distributed queries. Here is the …

Availability Group Readable Secondaries – Just Say No

Publié le 10 janvier 2019 sur sqlskills - jonathan kehayas
 

Since SQL Server 2012, Microsoft has put a lot of efforts into marketing AlwaysOn Availability Groups as a feature and solution for both high availability/disaster recovery for SQL Server, and scalability for read-only workloads.  Over the last si …

Empty Thoughts: Working with NULL

Publié le 10 janvier 2019 sur simple-talk.com
 

One of the hardest concepts in learning SQL is the meaning of a NULL. Traditionally, programming languages had no concept of missing or UNKNOWN data. The closest example that most programmers ran into was the ‘not applicable’ flags in sprea …

How Should We Show Statistics Histograms in sp_BlitzIndex?

Publié le 10 janvier 2019 sur brentozar.com
 

If you’re a graduate of my free How to Think Like the SQL Server Engine course – and you’d better be, dear reader – then you’re vaguely familiar with DBCC SHOW_STATISTICS. It’s a command that shows you the conte …

Introducing Azure SQL Database Hyperscale

Publié le 10 janvier 2019 sur sqlservercentral.com
 

With Azure SQL Database Hyperscale, databases can quickly auto-scale up to 100TB, eliminating the need to pre-provision storage resources, and significantly expand the potential for app growth without being limited by storage size.

The Basics of iTVFs

Publié le 10 janvier 2019 sur sqlservercentral.com
 

Learn the basics of inline table valued functions in this short article.


Pages :