Sites anglophones


SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library

Publié le 14 mars 2017 sur journey to sqlauthority
 

One of my client was trying to start SQL Service and it was failing. I asked to hare ERRORLOG so that we will get some idea about the cause. Here is the information from ERRORLOG file. 2017-01-31 01:32:25.61 Server The server was unable to initialize e …

SQL WTF for T-SQL Tuesday #88

Publié le 14 mars 2017 sur sqlblog.com
 

The topic for this month’s T-SQL Tuesday is: “Be inspired by the IT horror stories from http://thedailywtf.com, and tell your own daily WTF story. The truly original way developers generated SQL in project X. Or what the grumpy « DBA » impose …

SQLskills SQL101: Temporary table misuse

Publié le 13 mars 2017 sur sqlskills.com - paul randall
 

As Kimberly blogged about recently, SQLskills is embarking on a new initiative to blog about basic topics, which we’re calling SQL101. We’ll all be blogging about things that we often see done incorrectly, technologies used t …

DATA TALES #12: The Case of the Code that Refused to Execute

Publié le 13 mars 2017 sur sqlmag.com
 

Over recent months the articles that I’ve written have focussed on the database engine. I’ve recently rolled many of the tools that I’ve been building for working with the database engine into a set of free downloads. You’ll fin …

[Video] Office Hours 2017/03/08 (With Transcriptions)

Publié le 13 mars 2017 sur brentozar.com
 

This week, Erik and Richie discuss creating/updating statistics, tools for viewing large flat file tables, the worst code they have ever seen, high disk queue length, dealing with databases that store blobs, reindexing jobs, transparent data encryption …

2016 Salary Survey in PowerBI

Publié le 13 mars 2017 sur sqlservercentral.com
 

A PowerBI Presentation using the data from the 2016 Salary Survey

SQL SERVER – FIX : Error Msg 8672 – The MERGE Statement Attempted to UPDATE or DELETE the Same Row More Than Once

Publié le 13 mars 2017 sur journey to sqlauthority
 

While I have been blogging about SQL Server for a long time, I still believe that there is still a lot of error which are not discovered by me. It is always fun to see new error and find a fix for the issue. Let us see how to fix error related to MERGE …

Why Automate?

Publié le 12 mars 2017 sur sqlblog.com
 

Because, as Jen Underwood ( jenunderwood.com | LinkedIn | @idigdata ) states in an upcoming podcast: The future of data science is automation . If automation is the future, how do we decide what to automate? We look for the long pole . What’s the …

How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113

Publié le 12 mars 2017 sur journey to sqlauthority
 

Question: How to Get Status of Running Backup and Restore in SQL Server? Answer: One of the reasons I started my blog long ago was to have a repository of scripts which can be very useful by DBA during daily troubleshooting. There are many times w …

In the Cloud: Free Azure Training

Publié le 11 mars 2017 sur sqlblog.com
 

Microsoft has many free Azure training courses found at https://openedx.microsoft.com/ . Each course is estimated to take 16-24 hours to complete. Oh my, I just realized Free Azure Training as a TLA is FAT. As a nurse, I’d never tell anybody to g …

[Video] Office Hours 2017/03/01 (With Transcriptions)

Publié le 11 mars 2017 sur brentozar.com
 

This week, Brent and Tara discuss Always On failure scenarios, partitioning without consulting vendors, multi-subnet clustering with AGs, licensing, long running queries, replication, improving index maintenance, avoiding deadlocks, index space usage, …

SQL SERVER – PRINTing Status Using RAISERROR With NOWAIT Option

Publié le 11 mars 2017 sur journey to sqlauthority
 

In this blog post we are going to learn about PRINTing Status Using RAISERROR With NOWAIT Option. The Problem  There are many situations where you want to know which line of code is completed in the batch. Mostly this is a series of commands …

New Technology Considerations – SQL Server 2016 on Hyperconverged Infrastructure

Publié le 10 mars 2017 sur sqlmag.com
 

Sponsored by: Nutanix Wednesday, April 19, 2017 at 2:00 PM EDT – Duration: 1 hour read more

New White Paper: How to Build a SQL Server Disaster Recovery Plan with Google Compute Engine

Publié le 10 mars 2017 sur brentozar.com
 

You’re a systems administrator or database administrator who wants to protect your production SQL Server. However, you don’t have a separate data center or another colo site. Learn about what we call Log Shipping 2.0 You’re looking fo …

TroubleShooting SQL Server Memory Consumption

Publié le 10 mars 2017 sur sqlservercentral.com
 

Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.


Pages :