Sites anglophones


Database on a diet (Part 1)

Publié le 28 janvier 2016 sur sqlblog.com
 

Hi Folks, My next article for SQL Server Magazine is out now. I’ve decided that New Year is the time that most people discuss diets and databases don’t have to be an exception. I’m discussing one large client who had a database that r …

Manipulating Filetable Files Programatically

Publié le 28 janvier 2016 sur sqlservercentral.com
 

Learn how you can work with FileTable files from T-SQL as an alternative to the drag and drop methods of using Windows Explorer

A Review of rsNeatPublish

Publié le 28 janvier 2016 sur sqlservercentral.com
 

rsNeatPublish: Toolset to automate deployment of all SSRS 2008R2/12/14/16 objects

Using PowerShell for SQL Server Replication Tracking

Publié le 28 janvier 2016 sur sqlservercentral.com
 

Tim Smith shows how using PowerShell can be an effective way to track SQL Server snapshot and transactional replication counts for sources and destinations. « A real time saver » Andy Doyle, Head of IT ServicesAndy and his team saved time by automating b …

SQL SERVER – Fixing Annoying Network Binding Order Error – Notes from the Field #112

Publié le 28 janvier 2016 sur journey to sqlauthority
 

[Note from Pinal]: In this episode of the Notes from the Field series database expert Ryan Adams explains a very critical error user receive when binding network error. Ryan is one guy who spends more time with real world issues with SQL …

SQL Select: Eight Great (and Free) SQL Server eBooks

Publié le 27 janvier 2016 sur sqlmag.com
 

Check out these eight great free SQL Server eBooks read more

SQL Server Diagnostic Information Queries Detailed, Day 27

Publié le 27 janvier 2016 sur sqlskills.com - glen berry
 

For Day 27 of this series, we start out with Query #61, which is Volatile Indexes. This query retrieves information from the sys.objects object catalog view, the sys.stats object catalog view, and the sys.dm_db_stats_properties dynamic management funct …

Data Tales: The Case of the Database Diet (Part 1)

Publié le 27 janvier 2016 sur sqlmag.com
 

DATA TALES #6: The Case of the Database Diet (Part 1) (in which Dr. Greg Low begins his plans of placing a VLDB on a diet… read more

Data Tales: The Case of the Rogue Index

Publié le 27 janvier 2016 sur sqlmag.com
 

DATA TALES #6: The Case of the Rogue Index (in which Dr. Greg Low begins his plans of placing a VLDB on a diet… read more

SQL Server Agent is an application server.

Publié le 27 janvier 2016 sur brentozar.com
 

Application server. SQL Server Agent is a job scheduler. When we first get started managing SQL Server, we usually use it for backups, index maintenance, DBCC CHECKDB, and other common maintenance tasks. And then one day, we say, “Hey, I nee …

Configuring R Services in SQL Server 2016

Publié le 27 janvier 2016 sur sqlservercentral.com
 

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.

Automate Alerting for SQL Server Suspect Database Pages

Publié le 27 janvier 2016 sur sqlservercentral.com
 

We suspect there are some issues with our disk subsystem and would like to be alerted by email if SQL Server encounters any corruption in any of the data files that reside on the disk in question. How can we add this automated monitoring?

SQL SERVER – Add failover cluster node fails with “number of cluster nodes supported for edition”

Publié le 27 janvier 2016 sur journey to sqlauthority
 

A lot of my blog readers contact me via comments and I try my best to reply to all of them. Sometimes issue is so interesting that I ask them to contact via email. This blog is result of such an interaction. Asif (name anonymized) was trying to Add thi …

Using R Machine Learning Script as a Power BI Desktop Data Source

Publié le 27 janvier 2016 sur simple-talk.com
 

You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple example that shows how to connect to data sources over the Internet, cleanse, transform and enrich the data through the …

SQL Server System Views: The Basics

Publié le 27 janvier 2016 sur simple-talk.com
 

Even if you know what SQL Server’s system views actually are, It isn’t always entirely obvious when and why you should use them. Many of us could do with a simple explanation, and who better to provide one than Rob Sheldon?


Pages :