Sites anglophones


Vote Now to Pick the GroupBy Conference Lineup

Publié le 9 décembre 2016 sur brentozar.com
 

Voting closes soon at GroupBy, the new free online conference where YOU pick the lineup. Here’s the sessions up for votes – there’s a lot of them, so maybe focus on rating the sessions you find the most interesting – quantity of …

Some Tips for Minimising the Pain of HTML Input Forms

Publié le 9 décembre 2016 sur sqlservercentral.com
 

HTML Input forms are, by their nature, tiresome for the user of any website. However, with some attention to detail and a dash of JavaScript, it is possible to reduce the drudgery of form-filling to the minimum and minimise mistakes. Dino explains four …

Troubleshooting a painful query using execution plans in SQL Monitor

Publié le 9 décembre 2016 sur sqlservercentral.com
 

When something’s wrong with your database you need to be able to identify the primary pain points within SQL Server and get to the root cause of the problem fast. Grant Fritchey explains how you can use execution plans inside SQL Monitor to help quickl …

SQL SERVER – Error: 26014 – Unable to Load User-Specified Certificate

Publié le 9 décembre 2016 sur journey to sqlauthority
 

After seeing various issues with SQL Server startup problem, I felt that I know almost most of the errors, but I was wrong till someone contacted me with a new error. But I learned that Errorlog is always a good place to start with. SQL SERVER …

Should I Install Multiple Instances of SQL Server?

Publié le 8 décembre 2016 sur brentozar.com
 

Marina Towers in Chicago Instance stacking is the technique of installing multiple instances of SQL Server on the same Windows instance. For example, you might have a VM or server named SQLPROD1, and have: SQLPROD1 – default instance of SQL Serve …

Downloading multiple files from internet with SSIS and C#

Publié le 8 décembre 2016 sur sqlservercentral.com
 

This is a tutorial to download multiple files from internet using the SSIS Script Task. 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 the root c …

Can comments hamper stored procedure performance?

Publié le 8 décembre 2016 sur sqlservercentral.com
 

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.

SQL SERVER Management Studio – Taking DB Offline Made Easier

Publié le 8 décembre 2016 sur journey to sqlauthority
 

I have an appetite to observe and learn from what happens around me more. These are the best ways we realize how life has been gifted to us. Since I have been traveling lately like mad with families where there has been enough vacation filled with some …

SQL Server Management Studio (SSMS) v16.5.1 Now Available

Publié le 7 décembre 2016 sur sqlblog.com
 

An updated version of SQL Server Management Studio (SSMS) for SQL Server 2016 (v16.5.1) is now available . :{>…(read more)

SQL Server Diagnostic Information Queries for December 2016

Publié le 7 décembre 2016 sur sqlskills.com - glen berry
 

This month, I have added a separate set of queries for SQL Server vNext. Right now, they are almost identical to the SQL Server 2016 queries, but I will make changes to surface new functionality in SQL Server vNext over time. I have also added support …

Availability Groups: More Planned Downtime for Less Unplanned Downtime

Publié le 7 décembre 2016 sur brentozar.com
 

I often hear companies say, “We can never ever go down, so we’d like to implement Always On Availability Groups.” Let’s say on January 1, 2016, you rolled out a new Availability Group on SQL Server 2014. It’s the most …

Cloning a SQL Server Login with all permissions using PowerShell

Publié le 7 décembre 2016 sur sqlservercentral.com
 

Cloning a SQL Server login with permissions that match another login is a common task. In this post, Jeffrey Yao shows how this an be done using PowerShell.

Stairway to Exploring Database Metadata Level 5: Exploring Facts About Tables

Publié le 7 décembre 2016 sur sqlservercentral.com
 

Now that we’ve explored, in preceding levels, some of the information that is available about indexes, triggers, keys and distribution statistics, we can concentrate on the tables themselves and their columns.

SQLBits 2017

Publié le 7 décembre 2016 sur sqlservercentral.com
 

SQLBits 2017 has been announced. The conference will take place on April 5-8, 2017 in Telford, UK.

SQL SERVER – FIX – Error: 26023 – TCP Port is Already in Use

Publié le 7 décembre 2016 sur journey to sqlauthority
 

One of my clients approach me that after patching of SQL instances, database mirroring stopped working. As usual, I asked them to share ERRORLOG file SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location.  In this blog …


Pages :