'When RAID controllers are idle, they automatically check the storage to make sure it's still okay. Why not SQL Server too?
Some of the pieces are there - for example, SQL Server already has the ability to watch for idle CPU times and run Agent jobs when it’s bored. For starters, that’d probably be good enough to save a lot of small businesses from heartache. For the databases over, say, 100GB, it’d be really awesome to have resumable physical_only corruption checking - tracking which pages have been checked (just like how the differential bitmap tracks page changes), with page activity reset when the page is changed (again, just like the differential bitmap.) This wouldn’t count the same as a real CHECKDB, which needs to do things like compare index contents - but it'd be a big improvement over what we have now in environments where folks just aren't aware that the onus for data integrity is on them, not SQL Server.'...
https://feedback.azure.com/forums/908035-sql-server/suggestions/34895971-run-dbcc-checkdb-with-physical-only-automatically
'Problem
In a previous tip, SQL Server on Linux – Part1, we saw how to build a Red Hat Enterprise Linux 7.4 on Elastic Compute Cloud (EC2), and we converted perm files into ppk format to connect a terminal session using PuTTy to connect to the Red Hat server. In Part 2 of this series, we will walk thru how to install SQL Server 2017 on Linux and connect to SQL Server 2017 on Linux using SQLCMD and SSMS.
Solution
SQL Server on Linux supports many features and there are some features which are not supported under the unsupported feature or service section and known issues.
You can download SQL Server for Linux from here.'...
https://www.sswug.org/sswugresearch/community/install-sql-server-2017-on-red-hat-linux-on-aws-part-2/
'Today we are releasing Visual Studio 2017 version 15.8. In this version we have focused on productivity, performance and bug fixes. There are many new features you‘ll find useful, but in this post, I’ll underscore the highlights you may be most interested in. For the complete list of all the updates in today’s release, check out the Visual Studio 2017 version 15.8 release notes and list of bugs submitted by you that are fixed. If you prefer to first try these updates without installing the release, check out the Visual Studio images in Azure.
A couple of notable additions to try:
-
Multi-caret editing improvements
-
Faster git branch switching
-
Faster unit test execution
-
TypeScript 3.0 support
Read on for more details.'...
https://blogs.msdn.microsoft.com/visualstudio/2018/08/14/visual-studio-2017-version-15-8/?MC=Vstudio&MC=ASPNET&MC=.NET&MC=Windows&MC=CloudDev
'There are two really great features just added to Power BI that I wanted to blog about: Composite models and Dual storage mode. This is part of the July release for Power BI Desktop and it is in preview (see Power BI Desktop July 2018 Feature Summary). I’ll also talk about a future release called Aggregations.'...
https://www.jamesserra.com/archive/2018/07/power-bi-new-feature-composite-models/
'On May 3, Microsoft announced Power BI Premium, a capacity-based licensing model that increases flexibility for how users access, share and distribute content. The new offering also introduces the ability to manage Power BI reports on-premises with the included Power BI Report Server.
Today, we’re excited to make available a preview of Power BI Report Server.
Along with today’s preview release, let’s take a closer look at Power BI Report Server.
Publish Power BI reports on-premises
As more and more customers have come to use Power BI Desktop as a powerful tool for self-service BI and creating interactive reports, some customers have expressed a need for an on-premises solution for sharing these reports with business users. We heard that feedback and earlier this year released a “Technical Preview of Power BI reports in SQL Server Reporting Services,” describing the combination of Power BI Desktop’s interactive report capability with SQL Server Reporting Services’ on-premises server platform. On May 3, we announced that we’re bringing this combination to market as Power BI Report Server.
We continue to develop both SQL Server Reporting Services and Power BI Report Server to meet our customers’ range of needs. SQL Server 2017 will continue to include Reporting Services for on-premises enterprise reporting. For customers who want all that, plus self-service BI, we offer Power BI Report Server.
'...
https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/
'One of the things that confuse SQL users all the time is how DISTINCT and ORDER BY are related in a SQL query.
The Basics
Running some queries against the Sakila database, most people quickly understand:
|
1
|
SELECT DISTINCT length FROM film
|
This returns results in an arbitrary order, because the database can (and might apply hashing rather than ordering to remove duplicates).
Most people also understand:
|
1
|
SELECT length FROM film ORDER BY length
|
This will give us duplicates, but in order.
And, of course, we can combine the two:
|
1
|
SELECT DISTINCT length FROM film ORDER BY length
|
'...
https://blog.jooq.org/2018/07/13/how-sql-distinct-and-order-by-are-related/
'During Comprehensive Database Performance Health Check, one of the DBas asked what is the most optimal value for Max Worker Threads. The question was indeed asked when my customer looked at the value of Max Worker Threads in the Processor sections of the Server Property, they were really worried. The default value of the Worker Threads is always set to zero.
Looking at the zero value, DBAs were really really worried as they believe it is not good to have zero value for their worker thread. They all believed that they should set this value to as many as processors they have in their system. During the conversation, they were very much in panic and blaming each other for the value zero in the max worker threads settings.'...
https://blog.sqlauthority.com/2018/06/15/sql-server-optimal-value-max-worker-threads/
'There may be a time when you want to turn off transparent data encryption on one of your TDE enabled databases. One of these times might be if you want to send a copy of your database to someone else without having it encrypted. Another reason might be you no longer need to have TDE turned on because you have either removed the confidential data you wanted encrypted, or you have encrypted your confidential data using something like Always Encrypted.
It is very simple to remove Transparent Data Encryption. You can run the following code...'...
https://www.databasejournal.com/tips/how-to-remove-transparent-data-encryption-from-a-database.html
'I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the "results cache" and be "practically free". It's not the first time I've heard someone refer to a "results cache" in SQL Server. This is one of those myths that is almost true, which makes it that much more believable. If you don't know better, you might think SQL Server has a "results cache" because the second execution of a query is often faster.
SQL Server does not have a "results cache" and the second execution is not "practically free."
SQL Server does have a "buffer cache" and the second execution is "faster, but not free."'...
https://sqlperformance.com/2018/07/performance-myths/query-result-cache
'Question: How to DELETE Multiple Table Together Via SQL Server Management Studio (SSMS)?
Answer: I just received this question the other day during Comprehensive Database Performance Health Check. My initial answer was that you can easily script it out like following:
|
1
2
3
4
|
DROP TABLE [dbo].[InMemory_Columnstore_People]
GO
DROP TABLE [dbo].[InMemory_People]
GO
|
However, the DBA asked me the question once again saying, he is quite familiar with the T-SQL script but he would love to know if there is a shortcut to do that via SSMS. Essentially he would love to drop multiple tables via keyboard in SQL Server Management Studio.
Fortunately, it is totally possible to do so. Here are the steps...'...
https://blog.sqlauthority.com/2018/06/14/sql-server-how-to-delete-multiple-table-together-via-sql-server-management-studio-ssms/
