Sites anglophones


SQL SERVER – The Operating System Returned the Error 21(The Device is Not Ready.) While Attempting ‘GetDiskFreeSpace’ on ‘A:’

Publié le 23 septembre 2017 sur journey to sqlauthority
 

I always try to keep myself up-to-date with new released of SQL Server. This blog is part of my learning, while using SQL Server 2017, which I always share with my blog readers. This is the error related to Error 21 about a device not ready. Note: I am …

Key Lookups and ColumnStore Indexes

Publié le 22 septembre 2017 sur brentozar.com
 

Beavis v. Butthead I was a bit surprised that this was a possibility with ColumnStore indexes, since “keys” aren’t really their strong point, but since we’re now able to have both clustered ColumnStore indexes alongside row stor …

SQL SERVER – New DMV in SQL Server 2017 – sys.dm_os_enumerate_fixed_drives. A Replacement of xp_fixeddrives

Publié le 22 septembre 2017 sur journey to sqlauthority
 

Looking at the way SQL has evolved, there are changes coming up in SQL Server 2017 which would help it run on Windows and Linux platforms. Let us learn about dm_os_enumerate_fixed_drives. There are some new learnings which I have as I played with …

Answering Questions For Fun And No Profit

Publié le 21 septembre 2017 sur brentozar.com
 

I love answering questions about SQL My forum of choice is dba.stackexchange.com because I find the voting and point system with badges for being a decent internet person addictive. If you like more traditional forums, SQLServerCentral.com has a lot of …

Breaking News: Using TDE on 2016? Doing Backups? Time to Patch.

Publié le 21 septembre 2017 sur brentozar.com
 

Normally, when you use Transparent Data Encryption (TDE) to secure your database at rest, you can’t get backup compression. Encrypted data basically looks like random data, and random data doesn’t compress well. SQL Server 2016 introduced t …

Purging Old Database Mail Items

Publié le 21 septembre 2017 sur sqlservercentral.com
 

Are you purging the old database mail items stored in msdb? In this tip, Greg Larsen shows you how to purge database mail. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by- …

Use SQL Server? Redgate would like to hear from you

Publié le 21 septembre 2017 sur sqlservercentral.com
 

Redgate are running a survey to better understand trends in adoption of different technologies and platforms. Completing this survey will take just a few minutes, and as a thank you for your time, they will be giving away a $100 Amazon gift card to one …

SQL Server 2016 SSIS Basics – Install SQL Server Data Tools

Publié le 21 septembre 2017 sur sqlservercentral.com
 

Step-by-step instructions for downloading and installing SQL Server Data Tools (SSDT) for SQL Server 2016.

SQL SERVER – FIX: Msg 5123, Level 16 – CREATE FILE Encountered Operating System Error 5

Publié le 21 septembre 2017 sur journey to sqlauthority
 

This blog is about another common error reported by many DBA to me. He faced error related to create file in OS. Here is the text of the message. CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the …

Geek City: Changing How To Change Your Database Properties — ALTER DATABASE

Publié le 20 septembre 2017 sur sqlblog.com
 

(This article was originally published at https://www.dbbest.com/blog/ Long ago (in SQL Server years) many metadata changes were implemented with special one-off stored procedures. For example, we had sp_addindex and sp_dropindex , as well as sp_addtyp …

What Would You Put in SQL Server 2018?

Publié le 20 septembre 2017 sur brentozar.com
 

If you were leading Microsoft’s development programs, what would you add or change in SQL Server 2018? Forget licensing or pricing changes – that’s dictated by the marketing teams, and those decisions are made really close to the rele …

More SQL Server Features that Time Forgot

Publié le 20 septembre 2017 sur simple-talk.com
 

The series so far: The SQL Server Features that Time Forgot: Data Quality Services, Master Data Services, Policy-Based Management, Management Data Warehouse and Service Broker. More SQL Server Features that Time Forgot: Auto-shrink, Buffer-pool extensi …

Stairway to U-SQL Level 17: Executing U-SQL Jobs with PowerShell

Publié le 20 septembre 2017 sur sqlservercentral.com
 

Automate your Data Lake with PowerShell! Learn how PowerShell can be used to execute U-SQL scripts, as well as a few other little tricks.

Doing a book signing at the DataCore booth at Microsoft Ignite!

Publié le 20 septembre 2017 sur sqlblog.com
 

If you are in the intersection of these two groups: Doesn’t currently have a copy of my current database design book, or wants to give one to a friend who architects poor databases Will be attending the Microsoft Ignite Conference Then I have a great d …

SQL SERVER – 7 Important Things to Remember While Taking Effective Backup

Publié le 20 septembre 2017 sur journey to sqlauthority
 

In this blog post we will discuss 7 points to remember while taking effective backup for SQL Server. Always take backup during off business hours, as backup operations generate IO activities. Take backup on a different drive from your data and log file …


Pages :