Sites anglophones


How to Change the File Extension for a Data File

Publié le 8 janvier 2018 sur sqlservercentral.com
 

This is a fix to primary data file that is created with a different file extension or accidentally renamed to a different file extension

SQL SERVER – Puzzle – Solution – Why Does UNION ALL Work but UNION Produces Error?

Publié le 8 janvier 2018 sur journey to sqlauthority
 

Last week, I asked a very simple puzzle about SQL SERVER – Puzzle – Why Does UNION ALL Work but UNION Produces Error?. The puzzle was very simple and interesting both together. I got quite a few valid answers to the puzzle so far. You …

How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155

Publié le 7 janvier 2018 sur journey to sqlauthority
 

Question: How to List All the clustered and nonclustered Indexes of Your Table in SQL Server? I have previously blogged about this few years ago but at that time SQL Server did not supported Columnstore Indexes as well other kind of indexes. I recently …

[Video] Office Hours 2018/1/3 (With Transcriptions)

Publié le 6 janvier 2018 sur brentozar.com
 

This week Brent and Richie discuss the latest big Intel CPU security flaw, distributed transactions, rebuilding indexes, SQL Server health check, GDPR regulations, Availability Groups issues, improving server performance, patching for instances th …

SQL SERVER – Log Shipping Monitor Not Getting Updated

Publié le 6 janvier 2018 sur journey to sqlauthority
 

One of my clients has implemented log shipping and everything was working fine. Recently they implemented a reporting tool which reported alerts that data missing for few log shipping tables. The data for “last_backup_file” and “last_ …

Blog moved

Publié le 5 janvier 2018 sur sqlblog.com
 

Blog has been moved to: jorgklein.com Follow me on twitter: twitter.com/jorg__klein

Automating Complacency

Publié le 5 janvier 2018 sur brentozar.com
 

There’s no Latin word for Robot I’m all for automation, especially when it comes to the boring stuff. As awesome as the automation routines we have for that are, I still see people messing it up. Right now, there’s no Clippy/HAL mashu …

Historical Stock Prices and Volumes from Python to a CSV File

Publié le 5 janvier 2018 sur simple-talk.com
 

Python’s rich web connectivity capabilities offer a convenient way to collect data from the Internet, and its ability to write csv files provide a medium for sharing collected data. This article focuses on enabling you to output end-of-day ticker …

Building a Custom Blocked Process Report

Publié le 5 janvier 2018 sur simple-talk.com
 

The blocked process report was introduced with SQL Server 2005 and it hasn’t changed much since then. From one SQL Server version/edition to another, it helps us troubleshoot blocking by generating an XML document which describes who the blocker …

Questions about Data Masking That You Were Too Shy to Ask

Publié le 5 janvier 2018 sur sqlservercentral.com
 

The General Data Protection Regulation (GDPR) will be in effect in May of 2018. Data masking is one technique that can help your organization comply with this and other regulations. William Brewer answers those questions about data masking that you wer …

Critical SQL Server Patches for Meltdown and Spectre

Publié le 5 janvier 2018 sur sqlservercentral.com
 

Everyone needs to learn about these hardware bugs and apply patches as soon as possible.

SQL SERVER – Error: 17142 – SQL Server Service has Been Paused. No New Connections Will be Allowed

Publié le 5 janvier 2018 sur journey to sqlauthority
 

Recently I was looking around in my virtual machine to find a topic to blog. Within a few minutes, I was having an idea. In this blog we would talk about an interesting feature “Pause SQL Server”. As stated via official Microsoft documentat …

Microsoft SQL Server Updates for Meltdown and Spectre Exploits

Publié le 4 janvier 2018 sur sqlskills.com - glen berry
 

Over the last couple of days, you have probably heard quite a bit of chatter and speculation about some newly disclosed ways to attack various processors. The initial reports were that only Intel processors were affected, but some sources indicate that …

The Perils Of VSS Snaps

Publié le 4 janvier 2018 sur brentozar.com
 

So much, so often Ah, backups. Why are they so tough to get right? You start taking them, you find out you’re not taking enough of them, or that they’re not the right kind, or that you’re not using checksums or compression, or that yo …

SQL Server Patches for Meltdown and Spectre Attacks

Publié le 4 janvier 2018 sur brentozar.com
 

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 unrela …


Pages :