Sites anglophones


Top 6 MySQL DBA Mistakes

Publié le 14 novembre 2016 sur sqlservercentral.com
 

To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In this article, Rob Gravelle goes over a few of the most common DBA mistakes to avoid. Some …

SQL Server 2016 Distributed Availability Groups

Publié le 14 novembre 2016 sur sqlservercentral.com
 

High availability solution with cross cluster support using the new Distributed Availability Groups How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fi …

SQL SERVER – FIX: Incorrect Syntax Near the Keyword ‘PROCEDURE’

Publié le 14 novembre 2016 sur journey to sqlauthority
 

Along with freelancing, consulting, I also spend time in replying to my blog comments to learn something new. Few such conversations end up in business deals, few in emails and few in the blog. This blog originates from one of such conversation regardi …

How to Find Size of All the Indexes on the Database – Interview Question of the Week #097

Publié le 13 novembre 2016 sur journey to sqlauthority
 

Question: How to Find Size of All the Indexes on the Database? Answer: Just another day while I was doing SQL Server Performance Tuning for a leading organization, I was asked by if I have a query which brings out all the indexes on the table with its …

Watch Brent Tune Queries [Video]

Publié le 12 novembre 2016 sur brentozar.com
 

I recently presented this for the PASS DBA Fundamentals Virtual Chapter. It’s basically what it says on the tin: I start with 15 minutes of explaining my query tuning process, and then about 40 minutes of actually tuning a query: To get the datab …

SQL SERVER – How to Get List of SQL Server Instances Installed on a Machine?

Publié le 12 novembre 2016 sur journey to sqlauthority
 

There are multiple ways by which we can find a list of SQL Server instances name instances on a machine. In this blog, I would show a few ways to do it. Command Prompt Based on my research, registry key would have an entry whenever SQL is installed. So …

Coming Soon: A Command-Line Interface for Managing SSIS Catalogs

Publié le 11 novembre 2016 sur sqlblog.com
 

I’m excited to announce CatCompare – a command-line interface (CLI) for SSIS Catalog Compare – is in pre-release testing. I plan to release the next update of SSIS Catalog Compare with an option to purchase the GUI product stand-alone …

Migrating from SQL Server to MySQL, PostgreSQL, and Aurora

Publié le 11 novembre 2016 sur brentozar.com
 

I’m getting an increasing number of requests these days that say: “We’re considering migrating our application from SQL Server to a cheaper, easier-to-scale database. Can you help?” Well, kinda: why are you doing it? If you …

Multi-Step Input Forms in ASP.NET MVC

Publié le 11 novembre 2016 sur sqlservercentral.com
 

It is a common problem with a web page that a form is too complex to fit easily on the page. You can, of course, rely on the scrollbar, but it soon becomes a daunting and erratic process for the poor user. Wizards, that allow you to guide the user thro …

Performance Improvement for Cursors in Stored Procedures

Publié le 11 novembre 2016 sur sqlservercentral.com
 

Exploring some differences between using cursors, local fast forward cursors and using set logic. How to fix SQL Server disk I/O bottlenecks (without a hammer)In this new article, Simple-Talk editor Tony Davis explains step-by-step how to find and fix …

Understanding Database Scalability – Horizontal and Vertical Scalability Better Together

Publié le 11 novembre 2016 sur journey to sqlauthority
 

When I wrote the blog around Understanding Database Scalability – Vertical and Horizontal, I saw few have conversations with me on if it is this or that. And these discussions could take a course all by itself. There is no one size fits all when …

Top 5 Overlooked Index Features

Publié le 10 novembre 2016 sur brentozar.com
 

I see a lot of indexes Most of them are pretty vanilla. Some are pretty memorable, like one that I saw with 93 INCLUDES. A lot of things that people could do with indexes get overlooked, either because they don’t know about them, or they’re …

Azure SQL Database – Implementing Azure AD Authentication

Publié le 10 novembre 2016 sur sqlservercentral.com
 

Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.

Data Lifecycle Management using SQL Server

Publié le 10 novembre 2016 sur sqlservercentral.com
 

With the data proliferation issues, a well-defined lifecycle for data retention is a growing demand.

SQL SERVER – Unable to bring resource online. Error – Data source name not found and no default driver specified

Publié le 10 novembre 2016 sur journey to sqlauthority
 

One of my blog readers reported a strange issue to me. As per the issue described, they were unable to bring SQL Server resource in cluster online, only on one node of the cluster. I always use for error messages, but they said that SQL resource goes t …


Pages :