'For SQL Server versions 2012 and later.
Select the database to use.
Input a value for @MyString that you want to search for.
Select options for datatype and wildcard use.
Execute.
If results are returned, the content of the column SQLCommand sould be copied and pasted into a new query window and executed for the final results.'...
http://www.sqlservercentral.com/scripts/String+Match/166729/?utm_source=SSC&utm_medium=pubemail
'The Meltdown and Spectre attacks are newly announced ways of hacking CPUs. They affect both Windows and Linux. If you’re running under virtualization or cloud IaaS, any other running guest can try to leverage the attacks to compromise your unrelated guest.
Meltdown (yes, it has a logo)
These are a really big deal.
Cloud providers are forcing reboots as they patch things. Normally, that’d be the big punch line of this post – expect random reboots this week – but that only mentions a casual note here.
This morning, Microsoft published a KB article with SQL Server guidance. All versions of SQL Server are affected (other than SQL Server 2008 on Itanium, but who uses that?) Microsoft’s KB goes back to 2008, but there’s no reason to believe that 2005/2000 aren’t affected as well – they’re just no longer supported.'...
https://www.brentozar.com/archive/2018/01/sql-server-patches-meltdown-spectre-attacks/
'As you might (hopefully) know, there was a serious CPU exploit exposed this week (called Meltdown), which will cause all Intel CPUs from the past 20 years to misbehave and return you critical, private data from other applications or even other VMs in a virtualized environment.
The terrible thing about Meltdown is that the exploit is possible because of the underlying CPU architecture, and can’t be fixed within the CPU itself. It is more or less “By Design”. Therefore the CPU exploit must be fixed in the software layer itself, which could also slow down the throughput for specific workloads. Fortunately Microsoft, Linux, Apple and VMware have already provided necessary patches to their Operating Systems to make sure that the Meltdown exploit can’t be used.
In this blog posting I want to give you an overview about how the Meltdown exploit works internally. There is already a really great whitepaper available, which describes the inner workings of Meltdown on a deep technical level. I want to show you in this blog posting in my own simple words how Meltdown works, and how private data can be retrieved with it.'...
'An important step in optimizing a system is to take a holistic approach and look at View that are called very often. These procedures can often be the backbone of a system. Sometimes optimizing these procedures can have a dramatic effect on relieving the physical bottlenecks of the system and improving end-user experience.
The following DMV query shows the execution count of each View, sorted by the most executed View first.'...
http://www.sqlservercentral.com/scripts/Performance/166762/?utm_source=SSC&utm_medium=pubemail
'This script extract the Number of Scans done on all index objects, their name, the corresponding Schema name, the table its built on, and also the average fragmentation. It can be edited accordingly to get other details.
Please run this on test database first before running on production.
Can be run using SSMS.'...
http://www.sqlservercentral.com/scripts/Indices/166972/?utm_source=SSC&utm_medium=pubemail
'We are excited to announce the December release of SQL Operations Studio is now available.
Download SQL Operations Studio and review the Release Notes to get started.
SQL Operations Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. To learn more, visit our GitHub.
'...
'We are excited to announce the release of SQL Server Management Studio (SSMS) 17.4!
Download SSMS 17.4 and review the Release Notes to get started.
SSMS 17.4 provides support for almost all feature areas on SQL Server 2008 through the latest SQL Server 2017, which is now generally available.
In addition to enhancements and bug fixes, SSMS 17.4 comes with an exciting new feature: SQL Vulnerability Assessment!
What is Vulnerability Assessment?
SQL Vulnerability Assessment (VA) is your one-stop-shop to discover, track and remediate potential database vulnerabilities. It can be used as an excellent preventative security measure, providing visibility into your security state and offering actionable steps to investigate, manage and resolve security issues and enhance your database fortifications. It is designed to be usable even for non-security-experts – getting started and seeing an initial actionable report takes only a few seconds.
'...