Sites anglophones


Introduction to SQL Server Spatial Data

Publié le 18 mars 2020 sur simple-talk.com
 

With the introduction of so many handheld devices that support features such as GPS and maps, the need to store spatial data in a relational database is greater than ever. Database systems such as IBM, DB2, and Oracle have supported spatial data for so …

The Staging Phase of Deployment

Publié le 17 mars 2020 sur simple-talk.com
 

Staging is a vital part of doing the deployment of any application, particularly a database quickly, efficiently, and with minimum risk. Though vital, it only gets noticed by the wider public when things go horribly wrong. On 2nd February 1988, We …

Free Fundamentals of Query Tuning Week: Part 2, How to Find the Right Queries to Tune

Publié le 17 mars 2020 sur brentozar.com
 

Well, it turns out that toilet paper doesn’t cure the coronavirus, so during the quarantines, I’m giving away free training. Yesterday, I kicked off the Fundamentals of Query Tuning class with the first module, building a query plan. Make s …

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

Publié le 17 mars 2020 sur journey to sqlauthority
 

SQL Always-On feature is so tied to cluster that sometimes you would need to look at various logs to fix a failure. In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO fail …

Fetch Web Data in Power BI

Publié le 17 mars 2020 sur sqlservercentral.com
 

Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this arti …

Spring discount on health checks for new clients

Publié le 16 mars 2020 sur sqlskills.com - paul randall
 

  It’s Spring on Saturday so it’s a perfect time to ensure your SQL Server instances are configured correctly and performing well. For all new clients, we’re dropping the price of our signature health check down to US$2,495 …

Working From Home…with Kids

Publié le 16 mars 2020 sur SQLSkills.com - Erin Stellato
 

Before I worked for SQLskills, I worked for a software company, Hyland Software.  One of the best things about working at Hyland was the Child Enrichment Center (CEC).  It was a day care until the kids were about 3, and then it was Montessori …

Free Fundamentals of Query Tuning Week: Part 1, Building a Query Plan

Publié le 16 mars 2020 sur brentozar.com
 

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals, our conference plans, maybe even how we wanted to do our first user group presentations or SQL Sa …

SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC

Publié le 16 mars 2020 sur journey to sqlauthority
 

While trying to try PolyBase on my laptop, I was getting an error. When I looked further, the solution was so different and the error message has no relation to it. In this blog, I would share my findings of error Msg 46530 – External data source …

Overview of Azure Cache for Redis

Publié le 16 mars 2020 sur sqlservercentral.com
 

The post Overview of Azure Cache for Redis appeared first on SQLServerCentral.

Moving on from Volunteer Projects

Publié le 16 mars 2020 sur sqlservercentral.com
 

The post Moving on from Volunteer Projects appeared first on SQLServerCentral.

Combining many crossing intervals

Publié le 16 mars 2020 sur sqlservercentral.com
 

Problem Combining overlapping or continuous intervals could be a discouraging task even for advanced programmers. This article presents a new solution based on usage of the geometry data type and an unknown function (if not, maybe less used function) s …

How to Decode @@OPTIONS Value? – Interview Question of the Week #268

Publié le 15 mars 2020 sur journey to sqlauthority
 

There are situations where set options can change the query behavior of a session. The session-level options can be found using the @@options variable in SQL Server. In this blog, I am sharing a useful script which can be used to decode the value of th …

SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?

Publié le 14 mars 2020 sur journey to sqlauthority
 

One of my clients contacted me and asked me the reason for this message? And my first reaction was, did you keep the database in very cold weather? It might be freezing over there and that’s why SQL is saying:   “I/O is frozen on …

Online class recordings available to purchase

Publié le 13 mars 2020 sur sqlskills.com - paul randall
 

By popular demand we’ve made the recordings of our live, online classes available to purchase – now you have a way to learn from us while you’re stuck working from home! These classes were all delivered live during 2019 and recorded u …


Pages :