Sites anglophones

#PASSSummit Expert Performance Tuning Pre-Con: Stretch Goals

Publié le 25 septembre 2017 sur

Sure, they look trustworthy Eric and I are doing a PASS Summit pre-con class called Expert Performance Tuning for SQL Server 2016 & 2017. To encourage signups, we’re giving every attendee a free Enterprise/Everything Bundle, plus some other s …

[Video] Office Hours 2017/09/20 (With Transcriptions)

Publié le 25 septembre 2017 sur

This week, Brent, Tara, Richie, and Erik discuss a most excepted solution for SA and securing an instance, how many VLFs should a database have, merge replication issues, query tuning tips, database restores, and Larry Ellison’s self-driving data …

Announcing More Online SQL Server Classes

Publié le 25 septembre 2017 sur

Our recent class lineup did pretty well, so now we’ve got a new round: Always On Availability Groups: The Senior DBA’s Field Guide with Edwin Sarmiento – December 20-22, $2,995 – Learn clustering, design, topologies, readab …

When sp_HelpText is not so helpful!

Publié le 25 septembre 2017 sur

A note of caution on the use of sp_helptext to script out objects.

SQL SERVER – Simple Explanation of AT TIME ZONE Feature

Publié le 25 septembre 2017 sur journey to sqlauthority

Recently I received a simple question about AT TIME ZONE feature. This is the new feature which is introduced in SQL Server 2016 and later version of the SQL Server. As this is a relatively new feature the adoption of this feature is also a bit sl …

The Guide to Learning PowerShell

Publié le 24 septembre 2017 sur

Learn how to start using PowerShell with this ebook. It covers almost any question you may have regarding PowerShell and its applications. This guide to learning PowerShell presents a wide range of topics which will leave you with an abundance of knowl …

How to Kill User Sessions (SPID) in SQL Server? – Interview Question of the Week #140

Publié le 24 septembre 2017 sur journey to sqlauthority

Question: How to Kill User Sessions (SPID) in SQL Server? Answer: Before I answer this question, I need to ask one more question – “Why do you want to kill all of the user sessions in your SQL Server?” Honestly, I do not see any …

SQL Saturday Parma is back! #sqlsat675

Publié le 24 septembre 2017 sur

Another SQL Saturday has been scheduled in Parma (Italy), it’s the SQL Saturday #675 and this year it will be more international than the previous editions because there will be six sessions completely in English (= 1 « virtual » track in English). …

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

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

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

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

Publié le 21 septembre 2017 sur

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

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

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 …

Pages :