SQLBrander @ SQL Server
794 views | +0 today
Follow

How to adjust file sizes and growth by a template – sqlbrander-nl

From www.sqlbrander.com

Today I like to write about a problem that excists in a lot of environments. The file sizes and file growth of the databases are default configured with 1MB growth and 10% growth. I see a lot of environments and most of them do not have adjusted values for these settings. The default setting for […]
No comment yet.

commands

From dbatools.io

dbatools is a free PowerShell module with over 100 SQL Server best practice, administration and migration commands included. Currently, other components of SQL Server such as SSRS and SSAS are not …
Gé @ SQLBrander.com:

The very best in useful SQL Server DBA tools!

No comment yet.

Introduction of Visual Studio Code for DBAs

From www.sqlshack.com

Introduction Visual Studio Code (Code), have you heard of this product yet? This is an open-source, cross-platform and extremely light weight code editor from Microsoft. You may see some folks explain this editor as the little brother to Visual Studio Community Edition (VS Community), but it is more compared to editors like Atom, Sublime Text …
No comment yet.

Announcing Exclude Disk Support for Hyper-V VMs with ASR

From azure.microsoft.com

A key ask that Azure Site Recovery (ASR) customers often have is the ability to exclude disks from replication, either to optimize the replication bandwidth consumed or to optimize the target-side resources utilized by such disks.
No comment yet.

Azure SQL Database is increasing read and write performance

From azure.microsoft.com

Azure SQL Database is increasing the read and writer performance
No comment yet.

Clustered Columnstore Index in Azure SQL Database

From azure.microsoft.com

Columnstore index is the preferred technology to run analytics queries in Azure SQL Databases. We recently announced general availability  if In-Memory technologies for all Premium databases.…
No comment yet.

Flashback 2016 – Highlights from Azure SQL Data Warehouse

From azure.microsoft.com

Earlier this year we announced the general availability of Azure SQL Data Warehouse, offering a SQL-based fully managed, petabyte-scale cloud solution. SQL Data Warehouse is highly elastic, enabling…
No comment yet.

Announcing: New Auto-Scaling Standard Streaming Endpoint and Enhanced Azure CDN Integration

From azure.microsoft.com

We are excited to announce Standard Streaming Endpoint and additional Azure CDN provider integration in Azure Media Services.
No comment yet.

Discover Which Deprecated Features Are Being Used - SQL Nuggets

From www.sqlnuggets.com

With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated.  These deprecated features are not immediately disabled or removed, but they are considered to be features not supported in a future version of SQL Server, and should no… Continue reading
Gé @ SQLBrander.com:

Very useful query for migration projects to newer versions of SQL Server! Just one line added for easy dicovery:

SELECT object_name, instance_name, cntr_value

FROM sys.dm_os_performance_counters

WHERE counter_name = 'Usage'

ORDER BY cntr_value DESC

 

No comment yet.

How to Setup Kerberos Correctly - SQLServerCentral

From www.sqlservercentral.com

David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL Saturday Denmark. I have had a quick chat with him via email since he got back and he said he had a great time.
No comment yet.

Memory/Storage Technology Hierarchy and SQL Server - SQLPerformance.com

From sqlperformance.com

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.
No comment yet.

Seattle SQL Pro Workshop 2016

From www.eventbrite.com

Eventbrite - Jason Brimhall presents Seattle SQL Pro Workshop 2016 - Monday, October 24, 2016 at Springhill Suites, Seattle, WA. Find event and ticket information.
No comment yet.

Why Attend the SQL Server & BI Conference | PASS Summit 2016

From www.sqlpass.org

PASS Summit delivers the best technical content and speakers of any SQL server event. Discover the latest in BI, analytics, big data, cloud and more.
No comment yet.

PowerShell to create Azure SQL DBs

From blobeater.wordpress.com

Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So I decided to find a scripted approach via PowerShell where I could just change some parameters and hit enter. I will go through the individual cmdlets that I use then provide the completed script. The…
No comment yet.

SQL Server Execution Plan formats - SQLServerCentral

From www.sqlservercentral.com

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor.
No comment yet.

Public vs private? Hybrid gives the biggest gains

From azure.microsoft.com

Want to hear about the best examples of enterprise computing today? At Open Stack Silicon Valley, August 9-10 you will hear about some of the most innovative implementations in the market.
No comment yet.

Introduction to Microsoft R Services in SQL Server 2016 - SQLServerCentral

From www.sqlservercentral.com

General introduction to R Services in SQL Server 2016 and how R server works with external stored procedure.
No comment yet.

Azure DocumentDB powers the modern marketing intelligence platform

From azure.microsoft.com

Affinio is an advanced marketing intelligence platform that enables brands to deeply understand their users in a deeper level.
No comment yet.

SQL Server Operations: Monitoring Disk Space with WMI and OLE Automation Objects - SQLServerCentral

From www.sqlservercentral.com

Abstract
This article talks about various SQL methods to fetch the disk usage details and use of T-SQL in conjunction with invoking OLE automation procedures and WMI class libraries using SQL Windows Shell interface.
No comment yet.

JSON support is generally available in Azure SQL Database

From azure.microsoft.com

We are happy to announce that JSON support is now generally available in Azure SQL Database.
No comment yet.

Azure Cognitive Services API’s with SQL Server 2016 CLR - SQLServerCentral

From www.sqlservercentral.com

Azure Cognitive Services is relatively new functionality within Azure that exposes some truly amazing APIs that have the ability to do some truly amazing things.
No comment yet.

Move data From Amazon Simple Storage Service using Azure Data Factory

From azure.microsoft.com

Learn about how to move data from Amazon Simple Storage Service (S3) using Azure Data Factory.
No comment yet.