Sites anglophones

The Surprising Behavior of Trailing Spaces

Publié le 13 avril 2017 sur

In every training class we do, I learn stuff from students. Here’s last week’s surprise. Create a temp table, and put in a value with trailing spaces. Then query for it using the = and <> operators, using different numbers of trailing …

Data Wrangling Concepts: Latency and Staleness

Publié le 13 avril 2017 sur

Latency is the amount of time between data creation and load. Staleness is the amount of time since data in a target was refreshed. In many data integration use cases, a latency or staleness of one day, one week, or even one month is acceptable. Enterp …

Ordered Set Functions: What’s New–and Missing–in SQL Server vNext

Publié le 13 avril 2017 sur

This article provides a reminder of what ordered set functions are, what’s new in vNext, and what’s still missing. read more

Nuance of datetime data type in SQL Server

Publié le 13 avril 2017 sur

One of the most confusing data types in SQL Server is the datetime datatype.

Harmful, Pervasive SQL Server Performance Myths

Publié le 13 avril 2017 sur

Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.

SQL SERVER – Slow Installation Wizard on Cluster – Please Wait While Microsoft SQL Server 2016 Setup Process the Current Operation

Publié le 13 avril 2017 sur journey to sqlauthority

Have you come across a situation where setup is taking many hours while navigating from one screen to another in clustered environment?  Have you ever waited for many hours watching following message related to slow installation wizard on the clus …

Does a TempDB spill mean statistics are out of date?

Publié le 12 avril 2017 sur

When you see a yellow bang in an execution plan, and you hover over it to discover that SQL Server spilled out to TempDB, your first reaction is to wail in pain and rend your clothes. Crying over spilled memory After that, though, it seems like people …

Automating database deployments to and from source control using SQL Compare and PowerShell

Publié le 12 avril 2017 sur

Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.

Using PerfMon and PAL to Diagnose SQL Issues

Publié le 12 avril 2017 sur

Free tools to help you find and diagnose SQL issues

PASS Application Development Virtual Group

Publié le 12 avril 2017 sur

I’ve been involved with PASS, once named Professional Association of SQL Server users, now just…PASS, since 2006 when I stepped up as president of SQL Server Italian User Group. Now that I moved to Redmond, WA, I’m still involved with it, but of cour …

SQL SERVER – Script Upgrade Failure – RsFxFt.Dll::RsFxMgmtInitialize failed: Error 0x80070002

Publié le 12 avril 2017 sur journey to sqlauthority

In the recent few days, I have found many clients having various script upgrade failures while applying service packs or cumulative updates. Here are few of them. Let us learn about  Script Upgrade Failure. SQL SERVER – Script level upg …

Free Webcast Next Tuesday: How to Triage SQL Server Emergencies

Publié le 11 avril 2017 sur

I’m speaking at the PASS DBA Fundamentals Virtual Chapter next Tuesday! Here’s the topic: When the phone rings, you need a repeatable process to discern the symptoms, root cause, what will happen if you don’t take action, and based on …

Fun With Logging Dynamic SQL

Publié le 11 avril 2017 sur

While working on a demo I thought this might make a fun aside to share on the blog, because working with dynamic SQL can be challenging. Especially if you don’t have a monitoring tool or application profiling to figure out who ran what and when, …

SQL Server vNext Release Date: May 31?

Publié le 11 avril 2017 sur

At the SQLbits conference in the UK, Victoria Holt sat in on a session about the State of the SQL Nation. She writes: “SQL Server vNext will be launched this year with the UK launch 31 May 2017.” Keep in mind that “launch” is a …

Time waits for no one

Publié le 11 avril 2017 sur

And technology changes as quickly as the numbers on a clock. A digital clock, of course – the numbers never change on an analogue one. I think it’s nice to have this month’s T-SQL Tuesday (hosted by Koen Verbeeck (@ko_ver)) on this to …

Pages :