Sites anglophones


Introduction to C# Scripting for SQL Server DBAs

Publié le 16 décembre 2016 sur sqlservercentral.com
 

Microsoft has introduced an interactive C# scripting technology inside the Visual Studio 2015 environment. In this post, Jeffrey Yao looks at how we can use this to perform SQL Server tasks.

Managing Log Files Sizes the Easy Way

Publié le 16 décembre 2016 sur sqlservercentral.com
 

Learn an easy, rough, and ready way to manage log files in this piece.

SQL SERVER – Unable to bring resource online – Error DoREPLSharedDataUpgrade : Failed to create working directory

Publié le 16 décembre 2016 sur journey to sqlauthority
 

A few days ago I wrote a blog about a cluster related issue where the configuration was not same on both the nodes, which was causing issues. SQL SERVER – Unable to bring resource online. Error – Data source name not found and no defau …

DLM (Database Lifecycle Management)

Publié le 15 décembre 2016 sur sqlblog.com
 

As I type, SQL in the City Streamed is running on another monitor, and Alex Yates [ DLM Consultants | @_AlexYates_ ] is screaming (almost), “Don’t do that!” I know a lot of data professionals. I know some of you read this blog. And I …

Useful Hardware Utilities – HWiNFO64

Publié le 15 décembre 2016 sur sqlskills.com - glen berry
 

Since I have a personal and professional interest in PC hardware (I have actually been accused by my friend Steve Jones of “loving hardware”), I like to find and talk about useful hardware utilities that are relevant for both personal machi …

Indexing Temp Tables

Publié le 15 décembre 2016 sur brentozar.com
 

People often don’t give this thought Which is a shame, because I see people sticking fairly large amount of data into temp tables. On the rare occurrence that I do see them indexed, it’s a nonclustered index on a column or two. The optimzer …

Listing Duplicate Values by Group

Publié le 15 décembre 2016 sur sqlservercentral.com
 

Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their dat …

Deploying schema changes to multiple databases using the SQL Compare command line

Publié le 15 décembre 2016 sur sqlservercentral.com
 

Feodor Georgiev explains how SQL Compare Pro makes it possible to automate the process of synchronizing a source and target database. By calling SQL Compare from a simple batch script, he shows how to make it work for a whole list of targets, one after …

Solving an SSIS Error – Cannot convert between Unicode and non-Unicode

Publié le 15 décembre 2016 sur sqlservercentral.com
 

When loading data with SSIS, sometimes there are various errors that may crop up. This article provides a solution when you get have a problem between Unicode and non-Unicode fields. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this …

SQL SERVER – Discovery Report – How to Find Information About Installed Features?

Publié le 15 décembre 2016 sur journey to sqlauthority
 

Many times, we need to find information about the various features / version of SQL Server installed on a machine.  If you ask a DBA, he can provide you information by looking at services and tell what all are installed. He might run some WMI/T-SQ …

Build Me A Build: What’s Your Hardware Budget?

Publié le 14 décembre 2016 sur brentozar.com
 

Spending Brent’s Money Reason number infinity spacetime + 1000 why working here rules is having a generous annual tax writeoff hardware budget. The first time around, I basically blew it all on working from home essentials. This time around I …

Things I Would Love to Put In sp_BlitzCache

Publié le 14 décembre 2016 sur brentozar.com
 

This is my favorite script to work on Getting stuff to work sp_BlitzCache is so rewarding because XML querying is so ridiculous. I wish Mikael Eriksson would write a book already; it’d make my life a whole lot easier. Along the way, I see a lot o …

The Hibernate ORM and SQL Server

Publié le 14 décembre 2016 sur sqlservercentral.com
 

Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step- …

Configure and use Apache Zeppelin with SQL Server: the Basics

Publié le 14 décembre 2016 sur sqlblog.com
 

In the previous post I’ve shown how to download and run Apache Zeppelin 0.6.2 for SQL Server, using Docker to simplify the installation procedure. It’s now time to start to use the fantastic Apache Zeppelin to connect to SQL Server and run …

SQL SERVER – Performance Analysis of Backup to Azure

Publié le 14 décembre 2016 sur journey to sqlauthority
 

It is second to human nature to compare when given options. When I wrote about the blog, SQL SERVER – Playing with Backups and Compression, I did compare some of the space savings one will achieve when working with backups and compression. T …


Pages :