Sites anglophones


Replace Bad Characters in Table

Publié le 28 juin 2017 sur sqlservercentral.com
 

Learn how to clean bad characters from lots of data in this article.

SQL SERVER – Puzzle – Incorrect Results with Decimal

Publié le 28 juin 2017 sur journey to sqlauthority
 

It has been a while we have seen a puzzle on this blog and I keep on receiving emails and comments that you all would love to see one more puzzle. Let us see a new puzzle “Incorrect Results with Decimal”. So the question is very simple and …

The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data

Publié le 27 juin 2017 sur simple-talk.com
 

The series so far: The Basics of Good T-SQL Coding Style The Basics of Good T-SQL Coding Style – Part 2: Defining Database Objects The Basics of Good T-SQL Coding Style – Part 3: Querying and Manipulating Data If you’ve been around SQ …

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Publié le 27 juin 2017 sur simple-talk.com
 

It has never been as easy to run and maintain SQL Server on AWS as it is with Azure, but if your organization uses AWS, then it makes sense to do so. Amazon Relational Database Service (RDS) for SQL Server now makes it much easier to set up, operate, a …

Announcing Expert SSIS Training with Andy Leonard

Publié le 27 juin 2017 sur brentozar.com
 

SQL Server Integration Services has changed a lot over the last decade, but one thing has remained the same: Andy Leonard has been the go-to name in the business. I’m excited to announce that we’ve partnered with Andy for online delivery of …

Filegroup restoring and database consistency

Publié le 27 juin 2017 sur sqlservercentral.com
 

In this article, we’ll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don’t reveal any issue.

How to Read the Transaction Log File

Publié le 27 juin 2017 sur sqlservercentral.com
 

Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file? Greg Larsen shows you how to browse the transaction log using an undocumented function. How to fix SQL Server disk I/O bottlenecks (without a …

MySQL – Fix – Error – Your Password does not Satisfy the Current Policy Requirements

Publié le 27 juin 2017 sur journey to sqlauthority
 

Just the other day I received an email from a MySQL user who has been struggling to set up his password due to the current policy requirements in MySQL. Let us see how we can identify what is his root cause and how to fix the issue with password securi …

[Video] Office Hours 2017/06/21 (With Transcriptions)

Publié le 26 juin 2017 sur brentozar.com
 

This week, Brent, Erik, Tara, and Richie discuss cross-database transactions in AGs, agent job owners, column store indexes, linked servers, migrating SQL Server databases to AWS cloud, synchronous readable secondary, rebuilding indexes, backups using …

Workplace Encounters: Using Volume Mount Points in SQL FCIs

Publié le 26 juin 2017 sur sqlservercentral.com
 

How we overcame the A to Z Windows Drive-Letter limitation using Volume Mount Points

SQL SERVER – FIX: Msg 3009, Level 16 – Could not Insert a Backup or Restore History Detail Record in the msdb Database

Publié le 26 juin 2017 sur journey to sqlauthority
 

As most of my blogs, this blog is also an outcome of an interesting engagement with a client. While trying to help one of my clients to recover from a hardware failure, I learned something about a trace flag. Let us learn about backup or restore histor …

BI Beginner: Using R Forecasting Visualization

Publié le 25 juin 2017 sur sqlblog.com
 

There are new HTML 5 enabled custom visualization for making interactive R visualizations in Power BI Desktop. Read the documentation and find the download links here . Because of the dependency on R packages that are loaded with the R library command. …

What is Copy Only Backup in SQL Server? – Interview Question of the Week #128

Publié le 25 juin 2017 sur journey to sqlauthority
 

Question: What is Copy Only Backup in SQL Server? Answer: This is another interesting question I received the other day. The question was in the image form and I am re-producing the image again here. The answer of this question can be very long. Howeve …

24 Hours of PASS (July 2017) – Summit Preview

Publié le 25 juin 2017 sur sqlblog.com
 

Which topics can you expect to see at the PASS Summit 2017 ? Find it out from July 19 to 20, 2017 at the 24 Hours of PASS Summit Preview edition.Register now at this link, thanks to the Sponsors, the 24 Hours of PASS is presented at no cost for yo …

Cosmos DB References

Publié le 24 juin 2017 sur sqlblog.com
 

Here is a list of links to get you started in understanding Cosmos DB, Microsoft’s new cloud based globally distributed multi-model database. Cosmos DB development started in 2010 as project Florence. When it was initially released to the public …


Pages :