Sites anglophones

Streamline Log Shipping Failovers: DR Made Just For You…

Publié le 14 décembre 2018 sur

A look at a SQL script solution that can help you easily fail over and back from log shipping scenarios.

SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted

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

It is indeed a pleasure when we write a timeless article for SQL Server and DBAs read it after many years. In the year 2007, I wrote an article about an error related to Could not open a new database. It has been one of the top viewed blog posts a …

Finding the Slowest Query in a Stored Procedure

Publié le 13 décembre 2018 sur - Erin Stellato

This post, Finding the Slowest Query in a Stored Procedure, originally appeared on the PASS website.  It has been re-posted here with permission.Figuring out exactly what causes slow performance for a stored procedure can sometimes feel like tryin …

Never Judge A Query By Its Cost

Publié le 13 décembre 2018 sur

Signs and Numbers When tuning queries, or even finding queries to tune, there’s a rather misguided desire to look for queries with a high cost, or judge improvement by lowering query cost. The problem is that no matter what you’re looking a …

Native SQL Backups for Amazon RDS Databases

Publié le 13 décembre 2018 sur

Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.

Whitepaper: Data Catalogs – the case for SQL Server

Publié le 13 décembre 2018 sur

This whitepaper discusses the importance of data catalogs, the benefits they bring to businesses, and the capabilities and features required. It also outlines how data catalogs help organisations comply with data privacy regulations such as HIPAA, SOX …

SQL SERVER – Error: Parameter ‘ProbePort’ does not exist on the cluster object. Unable to set Probe Port for Azure Load Balancer

Publié le 13 décembre 2018 sur journey to sqlauthority

Azure is gaining popularity and I am getting clients who want to create Always On availability group as their high availability solution in Azure Virtual machine. To keep myself up to date, I also try creating the customer’s scenario in my lab. I …

Does low fill factor affect SELECT performance?

Publié le 12 décembre 2018 sur

Sometimes good intentions lead to big problems. Imagine a system where page splits were thought to be causing a big enough performance problem that it made sense to change the fill factor setting of a lot of indexes. Now imagine you thought the fill fa …

PowerShell Module to Read Directory Contents and Store in a SQL Server Table

Publié le 12 décembre 2018 sur

In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.

Stairway to SQL Server Security Level 11: Auditing

Publié le 12 décembre 2018 sur

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway …

Detect and Diagnose SQL Server Performance Issues with Spotlight Cloud

Publié le 12 décembre 2018 sur journey to sqlauthority

Every user wants their applications to run faster. My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces. Today we will discuss how we can detec …

Tell Us What You Make: The 2019 Data Professional Salary Survey

Publié le 11 décembre 2018 sur

It’s time for our annual salary survey to find out what data professionals make. You fill out the data, we open source the whole thing, and you can analyze the data to spot trends and do a better job of negotiating your own salary: We make Stacks …

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

Publié le 11 décembre 2018 sur

Microsoft announced the release or CTP 2.1 for SQL Server 2019. This is the second CTP released for SQL Server 2019, and it has lots of new exciting features, like  » UDF inlining ». Read on to find out more!

Database Snapshot Use Case: Service Migration

Publié le 11 décembre 2018 sur

In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would tak …

SQL SERVER – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists

Publié le 11 décembre 2018 sur journey to sqlauthority

New client, new idea and a new blog! That’s how I have been writing a daily blog for many years now. In this blog, I would share my learning from a client who faced error “xp_create_subdir() returned error 183, ‘Cannot create a file w …

Pages :