Sites anglophones


Asymmetric Processor Cores

Publié le 20 février 2018 sur sqlblog.com
 

Most Intel processors use one of two cores, the main-line core and the Atom core. Desktop processors might use the newer Kaby Lake or Coffee Lake micro-architecture cores, while the Xeon SP lines uses the previous generation Skylake micro-architecture. …

How to Throttle Logins to SQL Server

Publié le 20 février 2018 sur brentozar.com
 

So, uh, you can use WAITFOR in a logon trigger:CREATE OR ALTER TRIGGER SorryNorm ON ALL SERVER FOR LOGON AS BEGIN IF ORIGINAL_LOGIN()= ‘NormTheNewGuy’ WAITFOR DELAY ’00:00:15′; END; GO You probably don’t want it to be TOO long, lest their app rep …

Validating naming conventions in Oracle

Publié le 20 février 2018 sur simple-talk.com
 

This article was originally published on Nick’s site, APEXPLAINED. We are republishing it here with his permission. Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension …

Sign up for more free training from Redgate

Publié le 20 février 2018 sur sqlservercentral.com
 

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presen …

Solve Sudoku with T-SQL – Part 1

Publié le 20 février 2018 sur sqlservercentral.com
 

A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new ar …

How to Move a TDE Encryption Key to Another SQL Server Instance

Publié le 20 février 2018 sur sqlservercentral.com
 

If you have a database backup of a Transparent Data Encryption (TDE) enabled database, the database backup will contain encrypted data. Because the database backup contains encrypted data you can’t just restore it to any instance. You can only re …

SQL SERVER – Improve Index Rebuild Performance by Enabling Sort In TempDB

Publié le 20 février 2018 sur journey to sqlauthority
 

During recent Comprehensive Database Performance Health Check, the customer put forward a compelling request. They wanted to improve their index rebuild performance as their index rebuilding process is taking forever to complete. When they asked m …

Changing Data Types on Large Tables: The INT to BIGINT Conundrum

Publié le 19 février 2018 sur simple-talk.com
 

During one of our regular SQL Server heath checks, using sp_blitz, one of our largest production tables raised a worrying alert. The ID column of a table holding customer order information was an INT datatype, and it was running out of numbers. The tab …

The Many Levels Of Concurrency

Publié le 19 février 2018 sur brentozar.com
 

“Concurrency is hard” Construction begins on the Tower of Babel, 610 BCE (colorized) When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s …

How to reformat a database in one operation

Publié le 19 février 2018 sur sqlservercentral.com
 

Inherited a database from another team? Changed your team policy on the way that you format SQL? What’s to stop you formatting the code of an entire database nicely, when you’re developing it? It can be done, but the process can take longer …

Questions about Data Governance that You Were Too Shy to Ask

Publié le 19 février 2018 sur sqlservercentral.com
 

A company’s data is one of its most valuable and important resources. Managing and protecting that data are big responsibilities, and a data governance processes must be put into place to avoid misuse and to meet regulations. In this article, Wil …

SQL SERVER- Unable to Failover AlwaysOn Availability Group to Disaster Recovery Site

Publié le 19 février 2018 sur journey to sqlauthority
 

One of my clients took my assistance to deploy Always On availability group. After few months, they added a Disaster Recovery node to windows cluster and availability group also. Later, they contacted me that they are not able to move availability grou …

How to Get VLF Count and Size in SQL Server? – Interview Question of the Week #161

Publié le 18 février 2018 sur journey to sqlauthority
 

Question: How to Get VLF Count and Size Information in SQL Server? Answer: Well, if you are seeking an answer to this question in earlier versions of SQL Server, I have previously blogged about it here: SQL SERVER – Detect Virtual Log F …

[Video] Office Hours 2018/2/14 (With Transcriptions)

Publié le 17 février 2018 sur brentozar.com
 

This week, Brent, Tara, and Richie discuss the lack of backward compatibility for SQL Server backups, deploying SQL Server on VMs with shared SAN storage, query tuning, replication, full-text indexes, backup and restore, saying “no” to your …

SQL SERVER – Patch Rule Failure: Not Clustered or the Cluster Service is Up and Online

Publié le 17 février 2018 sur journey to sqlauthority
 

One of my clients contacted me for quick assistance. They were trying to install a Service pack for SQL Server 2016 instance, but it was failing with below error message about cluster service. From the error message its clear that machine is a node of …


Pages :