Sites anglophones


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 …

Upgrading SQL Server–Day 5

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

As I noted yesterday, Lenovo recently submitted a TPC-E benchmark result for a Lenovo ThinkSystem SR650 two-socket system, with two 14nm Intel Xeon Platinum 8180 28-core Skylake-SP processors and 1.5TB of DDR4 RAM. This system had a raw score of 6,598. …

SQL SERVER – FIX: The Log for Database Cannot be Shrunk Until All Secondaries Have Moved Past the Point Where the Log was Added

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

While preparing for a demo for a client I was hit with an interesting error in AlwaysOn Availability Group backup and restore scenario. In my lab setup, I had four nodes SQLAUTH1 to SQLAUTH4 and I have always on high availability turned on SQL Server 2 …

Upgrading SQL Server–Day 4

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

For Day 4 of this series, I want to talk briefly about server hardware. If you are running a legacy version of SQL Server, it is very likely running on old, probably out of warranty hardware. This presents several problems. First, older server hardware …

The Power of Python and SQL Server 2017

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

MS SQL Server 2017 has added to its Advanced Analytics Extension, now called ‘Machine Learning Services ‘, by enabling SQL server to execute Python scripts within TSQL via ‘Machine Learning Services with Python’. This basically …

Chaining Agent Tasks The Right Way

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

Step By Step When you think about setting up maintenance, a persistent fear is that tasks may step on each other. You probably don’t want backups and CHECKDB and statistics maintenance running at the same time as statistics maintenance (notice I …

Chaining Agent Tasks For Alerting The Right Way

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

Step By Step When you think about setting up maintenance, a persistent fear is that tasks may step on each other. You probably don’t want backups and CHECKDB and statistics maintenance running at the same time as statistics maintenance (notice I …

Release Candidate 2 for Microsoft SQL Server 2017 Announced

Publié le 4 août 2017 sur sqlmag.com
 

Fast on the heels of Release Candidate 1 (RC1) of SQL Server 2017 less than three weeks ago, Microsoft has announced the availability of Release Candidate 2 of SQL Server yesterday.   read more


Pages :