Sites anglophones


How to Automatically Create and Refresh Development and Test Databases

Publié le 8 août 2017 sur sqlservercentral.com
 

In order to be able to deliver database changes more quickly, there are several tasks that must be automated. It can be a daunting job to ensure that the whole team has the latest database build when there is a proliferation of copies, and the database …

Interviews and niches

Publié le 8 août 2017 sur sqlblog.com
 

T-SQL Tuesday turns this month to the topic of job interviews. Kendra Little (@kendra_little) is our host, and I really hope her round-up post is in the style of an interview. I’m reminded of a T-SQL Tuesday about three years ago on a similar top …

SSMS 17.2 is now available

Publié le 8 août 2017 sur sqlblog.com
 

  The newest version of SQL Server Management Studio is now available for download. Lots of new features and fixes. The details and download links can be found here . Happy managing, Andy Kelly…(read more)

SQL SERVER – How to Build Three Part Name from Object_ID – Part 2?

Publié le 8 août 2017 sur journey to sqlauthority
 

Earlier this week, I posted an interesting interview question How to Build Three Part Name from Object_ID? – Interview Question of the Week #134. In its response, I have received a very interesting reply from Rin Sitah over here. Rin suggest …

SQL Server Diagnostic Information Queries for August 2017

Publié le 7 août 2017 sur sqlskills.com - glen berry
 

This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make additional minor updates to the queries periodically during the month, so if you are in doubt, downloading the …

Upgrading SQL Server–Day 7

Publié le 7 août 2017 sur sqlskills.com - glen berry
 

When it comes down to actually migrating from a legacy version of SQL Server to SQL Server 2016/2017, there are several different methods for performing the migration, depending on what legacy version of SQL Server your are using. Here is a high-level …

[Video] Office Hours 2017/08/02 (With Transcriptions)

Publié le 7 août 2017 sur brentozar.com
 

This week, Brent, Erik, and Richie discuss unit testing, tSQLt, availability groups, duplicate indexes, reporting services 2016 on availability groups, troubleshooting Entity Framework queries, joining views in tables, SQL Server caching issues, and wh …

Azure SQL: work with JSON files where they are

Publié le 7 août 2017 sur sqlblog.com
 

Dealing with CSV or JSON data today is more and more common. I do it on daily basis, since the our application send data to our microservice gateway backend is in a (compressed) JSON format. Sometimes, especially when debugging or developing a new feat …

Monitoring UnmatchedIndexes Warning

Publié le 7 août 2017 sur simple-talk.com
 

If you are using filtered indexes, it worth monitor the UnmatchedIndexes warning, it can give us very interesting insights. Filtered indexes and parameterized are terrible enemies. I explained a bit about parameterized queries in my article about how t …

Using Super Keys to Enforce Database Constraints

Publié le 7 août 2017 sur sqlservercentral.com
 

Example of Using Super Keys to Enforce Database Constraints, instead of procedural code

SQL Server Management Studio Recovery, Reporting, Key Combinations and Efficiency Tips

Publié le 7 août 2017 sur sqlservercentral.com
 

Serget Gigoyan is back with another set of 5 common SSMS tips.

SQL SERVER – How to Convert CollationID to Collation Name?

Publié le 7 août 2017 sur journey to sqlauthority
 

One of my blog readers sent email to me asking if there is a way to convert CollationID to Collation name. I replied asking more details about the requirement. Here is her reply. Pinal, I am in a trouble right now. Due to a hardware crash, I lost many …

Upgrading SQL Server–Day 6

Publié le 6 août 2017 sur sqlskills.com - glen berry
 

SQL Server Standard Edition License Limits One thing you need to consider as you are contemplating an upgrade and migration effort from a legacy version of SQL Server Standard Edition to a new version of SQL Server Standard Edition are the per instance …

SQL Updates Newsletter – July 2017

Publié le 6 août 2017 sur sqlblog.com
 

    SQL Updates Newsletter – July 2017 It has been a few months since my last post on these but here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each m …

How to Build Three Part Name from Object_ID? – Interview Question of the Week #134

Publié le 6 août 2017 sur journey to sqlauthority
 

Question: How to Build Three Part Name from Object_ID? Answer: I have heard about this multiple times before and I have blogged about this over here as well. Think about it, if you only have object id, how will you get the name of the object along …


Pages :